Having trouble with you SSPI context, Gettting errors like „Cannot generate SSPI context” in visual studio when your laptop is not at work. Look no further the answer is simple.

Do you remember that you wanted to connect from the database from another machine and you turned on TCP/IP in the SQL server configuration tool most likely about the same time you started having issues. There is your problem if you are no longer on the network it can’t get the SSPI context. Just make sure that the Protocol for the alias name you are using is set to named pipes and the problem will go away.

Don’t start messing around with the accounts under which the server starts that will only cause more headaches. You could however at a push just turn off tcp/ip but then what fun would that be ;-)

 http://support.microsoft.com/kb/811889/en-us