Tuesday, February 14, 2012

Cannot generate SSPI context

Hi - I am trying to run a test environment with Windows Server 2003
(computer A) as my domain controller and a XP Pro machine (computer B). What
I want to do is to log in to sql server on A through B using windows
authentication. Everything works fine when I use sql server authentication,
but if I switch to windows authentication I get the error saying that it
"Cannot generate SSPI context."
I can use windows authentication fine if sql server is on the same
machine, it only doesn't work if I am trying to connect remotely.
The Sql Server service is running under the local system account, but I
have also tried to run it under a domain account (administrative) and the
same error occurs.
Any help will be appreciated,
Maer
I've had this problem before, when i use a laptop on a domain. Win Auth
works. However, if i detact the laptop from the network, and try connecting
to a local instance (on the laptop) using WinAuth, i get the SSPI Context
error. I can however connect using SQL Auth.
I have therefore concluded that the SSPI Context error is usual due to some
kind of DNS error. Check your DNS is working correctly between machine A &
B, and that he XP machine is correctly on the domain (you might try removing
and adding it back onto the domain). You may find that you can't rejoin the
domain because of some connectivity or DNS issue.
Good luck.
O
"Maer" <maer@.auditleverage.com> wrote in message
news:OvMlclQvEHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi - I am trying to run a test environment with Windows Server 2003
> (computer A) as my domain controller and a XP Pro machine (computer B).
> What I want to do is to log in to sql server on A through B using windows
> authentication. Everything works fine when I use sql server
> authentication, but if I switch to windows authentication I get the error
> saying that it "Cannot generate SSPI context."
> I can use windows authentication fine if sql server is on the same
> machine, it only doesn't work if I am trying to connect remotely.
> The Sql Server service is running under the local system account, but I
> have also tried to run it under a domain account (administrative) and the
> same error occurs.
> Any help will be appreciated,
> Maer
>

No comments:

Post a Comment