Re: After password change, cannot connect to SQL servers.



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@xxxxxxxx"
<jgrubbs@xxxxxxxx> 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?

.



Relevant Pages

  • FL -- Miami SQL Server DW/BI/SSAS/SSIS job opening
    ... SQL Server Data Warehouse & BI Engineer ... troubleshooting, documentation, SQL Server 2005 BI Suite, some ... Oracle and 2005/2008 MS BI Suite. ... Reporting To: Director of Data Engineering ...
    (microsoft.public.sqlserver.datawarehouse)
  • FL -- Miami SQL Server DW/BI/SSAS/SSIS job opening
    ... SQL Server Data Warehouse & BI Engineer ... troubleshooting, documentation, SQL Server 2005 BI Suite, some ... Oracle and 2005/2008 MS BI Suite. ... Reporting To: Director of Data Engineering ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: SSPI Contexts
    ... A very good source for troubleshooting the error is ... Sometimes these errors have to do with SQL Server registering the Service ... synchronize its clock with the domain controller correctly, ...
    (microsoft.public.biztalk.general)
  • Re: Cluster fails
    ... SQL Server Performance and Scalability References, ... 224587 INF: Troubleshooting Application Performance with SQL Server ... 150934 How to Create a Performance Monitor Log for NT Troubleshooting ...
    (microsoft.public.sqlserver.clustering)
  • RE: Performance Tweaks
    ... maybe these links could help him in troubleshooting --- ... Proper SQL Server Configuration Settings: ... Troubleshooting the Index Tuning Wizard ...
    (microsoft.public.sqlserver.server)

Quantcast