Web Development

Ask something
Discussion Locked

Anonymonus Authentication:SQL Server2000

0 helpful
2 replies

by jsramos

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am experiencing AUTHENTICATION problems which is due to the fact that the SQL server and the IIS server are on two different NT machines.
I have Challenge/Response authentication method setup for the first page of my Intranet web site (which does not have the call to the database) and then once the user is allowed access to the first page, I want to access the SQL Server through the next pages using anonymous authentication. Here is my connection string from my .asp page: MyConn.Open "Provider=SQLOLEDB; Data Source=lzsql2k01; Initial Catalog=cbstest; Integrated Security=SSPI;"
I keep getting the same error: Login failed for user 'NG AUTHORITY\ANONYMOUS LOGON"
Both the IIS server and the SQL Server 2000 are running on seperate Win2000 servers. How do I setup SQL Server to accept anonymous logins and how do I code my connection string in my asp code?
Please and thanks,

2 replies

by aaronh

Most likely you need to grant the IUSR_MachineName account that your website is running under access to the database. If your DB server and web server are not in a domain then you need to create a local windows account on the DB server that is the same name and has the same password as the IUSR account on the web server. Then grant this new local account access to the DB as needed. If they are in a domain, then you can create a domain level service account to replace the IUSR account. Then grant this new account access to the database as needed. With either of these, the connection string you are using should be okay.

Give this a try. If that doesn?t work then please post a note that details if you are using a domain or not, what type of accounts your users are using and where they are created and what the NTFS permission on your website .asp files are.

This discussion is closed to new replies.