Unable to connect to server - Cannot generate SSPI context

[varajan]

While trying to connect to the SQL error, the following message appears:

Under the SQL Query Analyser message box, the following message appears:

Unable to connect to server XXXXXXX:

Server: Msg 1311, Level 16, State 1
[Microsoft][ODBC SQL Server driver] Cannot generate SSPI context

Can somebody please help with the above issue ?

In addition, tries installing the MSDE component again. Issue remains.

 

[JamesLean]

Couple of questions:

-What version of SQL are you using?
-What version of Windows is SQL installed on?
-What version of Windows is your local PC on?

--James

 

[mrdenny]

Have you changed the password of the account the SQL Server runs under recently? This error is often caused by the SQL Server running under a domain or local account that the password has been changed and the SQL Server has not been restarted under the new password.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[varajan]

James,

Answer to your queries are a follows:

-What version of SQL are you using?
SQL Server 2000

-What version of Windows is SQL installed on?
Windows 2000 Advanced Server Edition

-What version of Windows is your local PC on?
The application is being done on the console itself.
Windows 2000 Advanced Server Edition

____________________________________________________________

Denny,

Answer to your queries are a follows:


Have you changed the password of the account the SQL Server runs under recently?
Local account password has been changed.

This error is often caused by the SQL Server running under a domain or local account that the password has been changed and the SQL Server has not been restarted under the new password.

SQL Server was re-started after the password change.

 

[mrdenny]

I'd recommend restarting the service again. It may not have taken correctly.

You might also want to reset the password in the services control pannel. It may be logging it in with the wrong password and cashed credintials for some reason.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)