"Cannot Create SSPI Context" and how to fix it

Just a quick note for anyone who has ever gotten this error before: “Cannot create SSPI context”. I started getting this error when I was trying to establish a connection to a SQL Server when I wasn’t connected to the internal Microsoft corporate network. Connection strings that worked just fine when I was connected just wouldn’t work at all, and I could not figure out how to fix it.

GIYF (Google Is Your Friend) I googled it and found out that I had my connection string set wrong. I was using localhost for the server name in the connection string, which is not correct. I needed to use the SQL Server name, not the hostname.

So I changed the server to brian-thinkpad, my machine name, and everything worked just fine.

Hopefully this will save someone else the hour or so of confusion I spent trying to fix this.

— bab

posted on Sunday, January 09, 2005 1:51 PM

Feedback

# re: "Cannot Create SSPI Context" and how to fix it 1/9/2005 8:58 PM Raymond Lewallen

This will also happen if you are logged into your machine for days or weeks at a time and your password has expired. The PDC knows your password has expired, but your machine doesn't. So when Sql Server goes to authenticate you, you will fail due to password expiration on the domain account, thus receiving the error you mentioned above.

# re: "Cannot Create SSPI Context" and how to fix it 9/28/2006 4:16 AM et

# re: "Cannot Create SSPI Context" and how to fix it 9/28/2007 3:04 AM biseo

Thank you sharing this info.

# re: "Cannot Create SSPI Context" and how to fix it 1/24/2008 2:02 PM edongzkisiete

Another great post. Thanks

# software 2/24/2008 6:41 AM sheva

[url=http://potik.info]Warez[/url]

# soft 3/14/2008 7:34 AM Cemen

# re: "Cannot Create SSPI Context" and how to fix it 6/16/2008 2:21 AM Harsh

# re: "Cannot Create SSPI Context" and how to fix it 6/17/2008 7:22 AM from shop

its just a simple error..

# re: "Cannot Create SSPI Context" and how to fix it 11/7/2008 1:22 PM exnavyNuke

Another thank you for sharing this information and to Raymond too. Raymond's description was the reason we were getting this error.

Title

Name

Url

Spam Protection:

Enter the code you see:

If you can't read it, click your refresh button to get a new image.

Comments

Remember Me?

# re: "Cannot Create SSPI Context" and how to fix it 1/9/2005 8:58 PM Raymond Lewallen

# re: "Cannot Create SSPI Context" and how to fix it 9/28/2006 4:16 AM et

# re: "Cannot Create SSPI Context" and how to fix it 9/28/2007 3:04 AM biseo

# re: "Cannot Create SSPI Context" and how to fix it 1/24/2008 2:02 PM edongzkisiete

# software 2/24/2008 6:41 AM sheva

# soft 3/14/2008 7:34 AM Cemen

# re: "Cannot Create SSPI Context" and how to fix it 6/16/2008 2:21 AM Harsh

# re: "Cannot Create SSPI Context" and how to fix it 6/17/2008 7:22 AM from shop

# re: "Cannot Create SSPI Context" and how to fix it 11/7/2008 1:22 PM exnavyNuke

Brian Button - One Agile Coder

My Links

Blog Stats

News

Archives

Post Categories

Agile Solutions Group

Blogs I read

Enterprise Library V1 Team

"Cannot Create SSPI Context" and how to fix it

Feedback