Thursday, February 16, 2012

After password change, cannot connect to SQL servers.

We have 4 instances of SQL running on 4 different servers. We recently
had to change our administrator password. After doing that, we cannot
connect from our computers (Windows XP SP2) to any of our SQL servers
(1 Windows Server 2000, 3 Windows Server 2003). We see the following
error:
A connection could not be established to "servername"
Reason: Cannot generate SSPI context.
Please verify that SQL Server is running and check your SQL Server
registration properties and try again.
Any Ideas?
Check this article and see if it helps.
http://support.microsoft.com/default...b;en-us;811889
VM
"jgrubbs@.pgsd.org" wrote:

> We have 4 instances of SQL running on 4 different servers. We recently
> had to change our administrator password. After doing that, we cannot
> connect from our computers (Windows XP SP2) to any of our SQL servers
> (1 Windows Server 2000, 3 Windows Server 2003). We see the following
> error:
> A connection could not be established to "servername"
> Reason: Cannot generate SSPI context.
> Please verify that SQL Server is running and check your SQL Server
> registration properties and try again.
> Any Ideas?
>

No comments:

Post a Comment