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

SQL Server 2000 and Windows 2003 SBS

P: n/a

I have XP workstations and windows 2003 SBS. I setup an ODBC for an
application (tried both User and System DSN), but after a few usage, I get
the following error:

Connection failed:
SQLState: 'HY000'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.

Any ideas? Is this a bug?

--
Thank you
Please post only
Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi

This usually occurs when you are using Windows authentication and you can
not connect to the AD to authenticate the credentials. This may be due to a
network issue or you are not logged onto the domain. You may want to try
using SQL Server authentication

John

"!!bogus" <he***@microb.com> wrote in message
news:o8*********************@news20.bellglobal.com ...

I have XP workstations and windows 2003 SBS. I setup an ODBC for an
application (tried both User and System DSN), but after a few usage, I get
the following error:

Connection failed:
SQLState: 'HY000'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.

Any ideas? Is this a bug?

--
Thank you
Please post only

Jul 23 '05 #2

P: n/a
> This usually occurs when you are using Windows authentication and you can

That is true, but I need to use windows authentication.
not connect to the AD to authenticate the credentials. This may be due to a

Actually it works for a few times and then the problem stops to happen.
network issue or you are not logged onto the domain. You may want to try


I am logged on to the domain.
Jul 23 '05 #3

P: n/a


Hi

This is almost certainly a network issue then. Check your event logs and
maybe look at the network traffic to see if anything is amiss. Failing
that you may have to start swapping out/in network
cards/cables/routers....

John

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.