News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud



Why am I getting the error: SQL Network Interfaces: The Local Security Authority cannot be contacted.[SQL Native Client]Cannot generate SSPI context

The full error message looks like this:

[SNAC] “[SQL Native Client]SQL Network Interfaces: The Local Security Authority cannot be contacted.[SQL Native Client]Cannot generate SSPI context”
[MDAC] “Cannot generate SSPI context”;
[.Net1.0/2.0]” Failed System.Data.SqlClient.SqlException: Cannot generate SSPI context”

When this message occurs--especially when the same access 20 minutes ago worked, chances are you've logged off of your primary network. An example would be that at work you were using an ODBC connection to reverse engineer a database into a Visio diagram on a local MSSQL Express instance, then when you went to work on it after hours at home offline the connection fails with this error message.

In essence, your desktop/laptop with the local db  instance is disconnected from its domain.  The immediate solution in this case would be to VPN back into the network and keep moving forward!

There are other causes, and there are workarounds to the disconnected network roadblock that are explained exceptionally well in this MSDN blog:

http://blogs.msdn.com/sql_protocols/archive/2005/10/19/482782.aspx

Tuesday, January 20, 2009 9:54 AM

Feedback

No comments posted yet.


Post A Comment
Title:
Name:
Email:
Comment:
Verification: