Cannot generate SSPI context

• Truword

  SSC Enthusiast

  Points: 178

  More actions

  July 28, 2003 at 10:10 am

  #81345

  I installed Ms SQL server 2000 standard edition on my Windows 2000 Active Directory Server.For the past 3 days, it has been running well. I managed to install the client version on 2 PCs and these PCs have been connecting perfectly to the database on the AD server. I changed the password for the Administrator account on the AD server. I'm now getting this error "Cannot generate SSPI context" each time I want to add an additional client to connect to the AD server SQL Db. I configured my SQL to recognise Windows Authentication. I have restarted the Active directory server and I cannot even view the databases, the SQL Server task that I had set to automatically start at Logon is nolonger starting the server. Trying to start the SQL server (on the AD server) gives me an error message like;

  "A connection could not be established to <SERVER>

  SQL Server does not exist or access is denied.

  ConnectionOpen(Connect())..

  Please verify that SQL Server is running and check your SQL server registration properties by righht clicking on the <SERVER> node and try again."

  How can I enable SQL to see the new password because I think that all this has been caused by the password change that I did?

  Please help me.

• Dale Corey

  SSCrazy Eights

  Points: 9019

  More actions

  July 28, 2003 at 10:52 am

  #467321

  For some reason, you posted this topic twice. Redirect to http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14642&FORUM_ID=6&CAT_ID=1&Topic_Title=Cannot+generate+SSPI+context&Forum_Title=Security.

  All the best,

  Dale

  
  All the best,
  
  Dale

  Author: An Introduction to SQL Server 2005 Management Studio