Need Help with SQL Server Authentication

[Terry Olsen]

Not sure if this question belongs here or in the aspnet group...but here
goes...

Ive got a Datagrid bound to a dataset connected to an SQL Server DB on the
local machine. I don't have any trouble creating the database using the SQL
Web Manager from Microsoft. Everything connects up just fine in design mode
using ASP.NET 2003, but when I try to view the web page I get...

---- Begin Error Message ------

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'NT AUTHORITY\NETWORK SERVICE'.

Source Error:


Line 76:
Line 77: Private Sub Button1_Click(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles Button1.Click
Line 78: SqlDataAdapter1.Fill(DsCenters1)
Line 79: DataGrid1.DataBind()
Line 80: End Sub


Source File: c:\inetpub\wwwroot\Lessons\HelloWeb\links.aspx.vb Line: 78

---- End Error Message ----

I've added "system\ASPNET" to the database users but that didn't help. Can
anyone help me get this working?

Thanks!
Terry

 

[Miha Markic [MVP C#]]

Hi Terry,

Does this thread help?
http://groups.google.com/groups?hl=...=images&ie=UTF-8&as_ugroup=*adonet*&lr=&hl=en

 

[Guest]

Terr

The Account NT Authority does not have permissions for the SQL Server database, check in the Enterprise Manager Logins section to verify this

You will need to either create the login and allow permissions or impersonate another account for access to the SQL server. It is worth pointing out that all data access should be performed by a single user in the interesting of connection pooling for DB busy applications

 

[Terry Olsen]

I added the IIS_WKS group to my SQL users and now it works. What kind of
security issuses should I be aware of when making this site available to the
internet?