
June 23rd, 2004, 12:48 PM
|
|
Registered User
|
|
Join Date: May 2004
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Help with my connection to SQL Security database!!!
I am trying to connect to the Security table to authenticate users. It works well on my box when I’m logged in but it isn’t working when I have another user try to connect or when I try to connect remotely. I get a SQL error on the aspx page (System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON') but I have already removed the anonymous login for IIS and I have the connection string set to SSPI (.ConnectionString = "data source=servername;initial catalog=Security;Connection TimeOut=30;integrated security=SSPI) with the web.config’s identity set to impersonate=”true” />.
Do you have any other ideas or do you know of another way I can authenticate users and get a return value????
|