ASP.NET data access

[DMS]

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?

[Ray at]

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

"DMS" <dyanna.waters@hqisec.army.mil> wrote in message
news:011201c386a6$c79e9da0$a401280a@phx.gbl...

> 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?