Sunday, February 12, 2012

Cannot generate SSPI context

I'm getting this error from my SQL client. I'm developing a web app that
connects to a SQL Server, but after some time I get that error. I have to
restart and it works again. It only happens in my laptop. Other computers
from the intranet are working normally. I use windows authentication -I'm in
a windows 2003 domain-
Regards,
Diego F.This happens when your machinr can't access the DC to obtain an SSPI context
= Trusted Connection = Validated Logon.
Trying pinging the DC's when this happens - I think you will find a network
failure.
"Diego F." <diegofrNO@.terra.es> wrote in message
news:O2GnrF0aFHA.2968@.TK2MSFTNGP10.phx.gbl...
> I'm getting this error from my SQL client. I'm developing a web app that
> connects to a SQL Server, but after some time I get that error. I have to
> restart and it works again. It only happens in my laptop. Other computers
> from the intranet are working normally. I use windows authentication -I'm
> in a windows 2003 domain-
> --
> Regards,
> Diego F.
>
>|||Sorry for that, but what do you mean y DC?
Regards,
Diego F.
"Mercury" <me@.spam.com> escribi en el mensaje
news:d8432l$4ac$1@.lust.ihug.co.nz...
> This happens when your machinr can't access the DC to obtain an SSPI
> context = Trusted Connection = Validated Logon.
> Trying pinging the DC's when this happens - I think you will find a
> network failure.
>
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:O2GnrF0aFHA.2968@.TK2MSFTNGP10.phx.gbl...
>|||BTW, if you mean domain controler, I can access the server normally. I must
say that from once to once I lose the connection with the network, but not
so often as the SQL error.
Regards,
Diego F.
"Mercury" <me@.spam.com> escribi en el mensaje
news:d8432l$4ac$1@.lust.ihug.co.nz...
> This happens when your machinr can't access the DC to obtain an SSPI
> context = Trusted Connection = Validated Logon.
> Trying pinging the DC's when this happens - I think you will find a
> network failure.
>
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:O2GnrF0aFHA.2968@.TK2MSFTNGP10.phx.gbl...
>|||DC = domain controller here.
Depending on how the program is written, it could be connecting to the DC
much more often than it should. If your network connection really is flakey
then that would explain it.
To test this out, try and recreate the problem with a ping -t
dc-machine-ip-address running in the background. The -t switch means 'run
continously'.
- Tim
"Diego F." <diegofrNO@.terra.es> wrote in message
news:eKVkWK3aFHA.2664@.TK2MSFTNGP15.phx.gbl...
> BTW, if you mean domain controler, I can access the server normally. I
> must say that from once to once I lose the connection with the network,
> but not so often as the SQL error.
> --
> Regards,
> Diego F.
>
> "Mercury" <me@.spam.com> escribi en el mensaje
> news:d8432l$4ac$1@.lust.ihug.co.nz...
>

No comments:

Post a Comment