ASP.NET data access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DMS - 29 Sep 2003 17:28 GMT

I am new to ASP.NET and IIS web applications, but not to
SQL databases. I can successfully build Windows apps using
Visual Studio that use ADO. However, for Web Forms, I
created data connection and sqladapter to my SQL Server -
Northwind - which I dragged from Server Explorer. I
generate a dataset, and Preview Data in the da, works
fine. I then enter vb code on Page_Load event:
SqlDataAdapter1.Fill(ds)
DataGrid1.DataSource = ds.Tables("Employees")
DataGrid1.DataBind()
When I build and browse (localhost), I get:
Server Error in myapp...SqlException: Login failed for
user (null). Reason: Not associated with a trusted SQL
Server connection. (I have since found error codes
SQLState 42000 and SQL Error 18452, which could be
permissions, but haven't found anything detailed on how to
fix this.) I've tried various settings in Web.config
connection, tried configuring IIS Virtual Directory
Managment on SQL Server setting Integrated Security (the
server mode is Windows auth) and I downloaded the .NET
framework onto SQL server. I still get the error.
Perhaps my workstation version of IIS is not enough or not
configured properly(?); do I need a IIS-server edition
installed?

Reply to this Message

Ray at <%=sLocation%> - 29 Sep 2003 18:20 GMT

I'm plagiarizing:

===============
This is a classic asp newsgroup. While you may be lucky enough to find a
dotnet-savvy person here who can answer your question, you can eliminate the
luck factor by posting your question to an appropriate group. I suggest
microsoft.public.dotnet.framework.aspnet.

HTH,
Bob Barrows
===============

Ray at work

> I am new to ASP.NET and IIS web applications, but not to
> SQL databases. I can successfully build Windows apps using
[quoted text clipped - 20 lines]
> configured properly(?); do I need a IIS-server edition
> installed?

Reply to this Message

Webmaster Forum / ASP / Database Access / September 2003

ASP.NET data access