Can not connect to SQL server 2000 on windows authentication mode

Hello everyone,

We have SQL server 2000 on windows 2000. From our desktop MS Access was connected to database through ODBC. Since yesterday (after our consultant had updated another asp application in the same server) we are getting “SQL Server Error: 18452. ….. Login failed for user ‘(null)’. Reason: not associated with a trusted SQL Server connection. “

The consultant saying he did not touch any settings on server (?). And the problem is even server’s security property shows it has mixed mode authentication. But I cannot connect to server even through my SQL server enterprise manager in windows authentication mode. I can connect if I use SQL server authentication. Through ODBC I can connect also and test fine, if I use SQL authentication. But the Access application wouldn’t connect using SQL authentication in ODBC.

So, can any one help me to find out what else could be done to make sure that the server is going to accept windows authentication. I’m thinking any other settings or registry change … etc. Please help.

Thanks

You are getting the error during the communication with the Web Servcie, right ? Then you probably changed the Security of the ASP application to not allow Integrated authentication. Are you using an asp or an ASP.nET application ?

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

No our web service is fine. We are trying to connect through ODBC and SQL enterprise manager.

|||

Hi Taposh,

Did any of the security settings on the SQL Server itself changed? (ie. was some Windows user account access removed from SQL security settings?) You can verify this by using Enterprise manager and login using "sa" and expand the server; expand Security, and then click Logins.

Unfortunately, there are a few scenarios in which you will receive an 18452 error back from the server. Some of the typical scenarios include; missing login rights for Windows users; client and server on different domains (Kerberos trust issue).

Please have a look at http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

I would also recommend searching on the web using the error message as the key phrase.

HTH,
Jimmy