“Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

justin — Wed, 01 Aug 2012 05:40:30 GMT

that was awesome. I ve been searching for 2 hours till I got this article , which fixed my issue in a minute. Hats off to you.

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

Marnee — Thu, 12 Apr 2012 22:46:13 GMT

What do you do when none of the followings are true?

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

Sanjay — Fri, 17 Feb 2012 06:19:15 GMT

I received this error

and solved by restarting "DNS Client" service from services.msc

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

Dean — Wed, 05 Jan 2011 17:24:30 GMT

Thanks for your post Nan Tu - not only was it helpful but very interesting and informative

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

Pietjegates — Wed, 08 Dec 2010 07:36:08 GMT

I received this error because the password of the "functional user account" running my webservice was expired.

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

Jay Converse — Tue, 07 Sep 2010 19:58:34 GMT

Bless you! I'm the classic laptop software professional, with a domain in the office, and no domain at home. Changing my code from my laptop's name to 127.0.0.1 was the trick.

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

Mohammed — Tue, 27 Jul 2010 06:38:35 GMT

Hi ,

im facing problem cannot generate sspi context after some time the application is open. once i logged off and login again, im able to connect for some duration, again it will raise the same error message.

Please guide me on this

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

jpedroalmeida — Thu, 08 Apr 2010 08:51:44 GMT

I there,

I have just experienced this error and the problem was in the server where SQL Server instance was running because the time in Operating System was not correct and assincronous from the Active Directory server time. The error was solved fixing the time in the operating system where SQL Server was running.

Cheers

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

Satyen — Wed, 17 Feb 2010 23:05:38 GMT

Superb , it helped me solved my problem in Biztalk

re: “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

Mr. Andersen — Tue, 05 Jan 2010 09:28:31 GMT

I just experienced this error again, on a computer that is a member of a domain, but where the computer is disconnected from the network.

The error occurs not only when using the TCP/IP protocol, but also when using Shared Memory (I tried disabling all other client protocols and also all other server protocols).

The error I get, when trying to use the osql.exe utility, to connect to the server, looks like this:

[SQL Server Native Client 10.0]SQL Server Network Interfaces: The Local

Security Authority cannot be contacted

[SQL Server Native Client 10.0]Cannot generate SSPI context

The computer has a loopback interface which allows it to still use TCP/IP, but doesn't allow it to connect to anything.

The only workaround that has worked on this computer has been to enable the TCP/IP protocol again and connect to 127.0.0.1/InstanceName instead of using .\InstanceName or ComputerName\InstanceName.