Home > Archive > MS SQL Server security > December 2005 > cannot generate SSPI context - time out at client









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author cannot generate SSPI context - time out at client
maxzsim via SQLMonster.com

2005-12-30, 3:23 am

Hi ,

My client has once again got the "cannot generate SSPI context" error and
this time i managed to notice that the time on the client is abt 20 mins
earlier than that of the server.

How can i synch the time bet the client & the server ? and prevent it from
happening again

apreciate ur advise

tks & rdgs

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...curity/200512/1
Dan Guzman

2005-12-30, 9:23 am

Time synchronization is usually done by the Windows Time Service. By
default, time synchronization is done using the standard AD hierarchy.
Clients and member servers get their time from a domain controller in their
domain. Domain controllers get their time from a domain controller in their
parent domain. Forrest root domain controllers are ultimately used as the
time source and use either a hardware clock or NTP source.

> How can i synch the time bet the client & the server ?


One method to resync the time is with the w32tm.exe: w32tm.exe /resync

Another method is with the NET TIME command: NET TIME /DOMAIN:MyDomain /SET

> and prevent it from happening again


See the technet article below for a discussion of the Windows Time Service:

http://www.microsoft.com/technet/pr...0f8236e210.mspx


--
Happy Holidays

Dan Guzman
SQL Server MVP

"maxzsim via webservertalk.com" <u14644@uwe> wrote in message
news:599906d9830e0@u
we...
> Hi ,
>
> My client has once again got the "cannot generate SSPI context" error and
> this time i managed to notice that the time on the client is abt 20 mins
> earlier than that of the server.
>
> How can i synch the time bet the client & the server ? and prevent it from
> happening again
>
> apreciate ur advise
>
> tks & rdgs
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...curity/200512/1



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com