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?Could be an issue with your SPN - you can find more info and
troubleshooting steps for the error in the following
article:
How to troubleshoot the "Cannot generate SSPI context" error
message
http://support.microsoft.com/?id=811889
-Sue
On 17 Jan 2006 05:43:12 -0800, "jgrubbs@.pgsd.org"
<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?|||Thanks, we figured out the issue. The SQLSERVER and the SQLSERVERAGENT
service were set to use the old password. Once we changed this, we
were able to connect.

No comments:

Post a Comment