By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,436 Members | 2,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,436 IT Pros & Developers. It's quick & easy.

Query analyzer error message - Cannot generate SSPI context

P: 1
Hi all,
This is my first post, so please be gentle. hahaha
I have a SQL Server running Windows 2003, and SQL Server 2000.
I am able to VPN into the server fine, however no one is able to access the server through Enterprise Manager or Query Analyzer. The Server has been fine lately, but it seems that something as of lately has happened. All client machines have not been updated lately or anything of the sort which would
lead me to think that it is anything other that the server itself.

I Get the following Message in Query analyzer when trying to logon:

[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.

Any HELP would be greatly appreciated.

Feb 20 '06 #1
Share this Question
Share on Google+
1 Reply

P: 1
I checked the system log and was told the SPS server could not connect to a timing/clock computer...

I ran the net time command to sync the SPS server time with our domain server and that eliminated the problem.

net time \\<ip or computer name> /SET /Y
Oct 2 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.