November 23, 2006 at 12:09 pm
Hi all.
I am pretty new to programming, and i've lately ran into a problem trying to connect to an SQL server through an asp .NET application.
The error Im getting is as in the topic: Cannot generate SSPI context.
I am not sure if the problem is in the source (my pc) or the destination (the server), but I tend to think its from the server.
What more can I add - If Im using the "NAMED PIPES" option (in the client tool of the MSSQLserver) insead of the TCP/IP protocol, I am able to connect to the server, But I want (and need) to connect to the server with TCP/IP protocol, and then I have a problem doing that.
I would really appreciate any help and hits on how to fix or bypass, or whatever it takes to make things work.
Thanks in advance.
November 24, 2006 at 4:08 am
Hi,
There's a good explanatory article with some troubleshhooting tips on this site:
http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp
Good luck
Cath
November 27, 2006 at 12:09 pm
Thats a good article, but id didn't help me.
Plus, I don't have the setspn utility and have no outside internet connection because Im working on a closed network.
Is there another way I could delete the SPN safely (if that is the problem, ofcourse), or does anyone have another suggestion on how I can solve this problem?
Again, Im pretty amature and I don't have any more ideas.
Thanks in advance
November 28, 2006 at 1:36 pm
Based on my experience, this problem occurs when changing local system account. You need to modify settings in your domain with domain admin privilege. Although you use an intranet, if I am right, you still need to have a domain.
Hopefully, it will help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply