473,323 Members | 1,560 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

SQL Server 2000 and Windows 2003 SBS


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
3 4529
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
> 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


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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Yvon Bouchard | last post by:
I am wondering if we can install this Server on Windows 2003 Server without any problems. Is there anybody that did that before? Thanks in advance if someone know the answer. Yvon Bouchard, B....
0
by: Vincent Zhu | last post by:
I moved ASP WebPages from Windows 2000 server to Windows 2003 server platform. Those double-byte characters (Japanese) retrieved from SQL server 2000 are corrupted. I am using Macromedia...
1
by: Simon Chester | last post by:
Hello! Can anyone help me with this problem?... I have developed an ASP.NET (version 1.1) application which I have deployed to a number of webservers. The web application works fine on Windows...
2
by: Vaap | last post by:
I did lot of googling to see if I can solve the SQL server not found problem while trying to run ASP.Net community starter kit from an XP machine to Windows 2003 server hosting SQL server 2000...
9
by: gdonald | last post by:
Hi Wonder if anyone can help me. I am running an access 2000 application with the backend on a server running windows 2003 and a seperate front end on each users machine. When i designed it,...
1
by: Ramesh Ramesh | last post by:
I have VStudio .net installed on workstation (Windows XP) and MS SQL Server 2000 installed on Server (MS Windows 2003 Standard Edition). Can I use MS SQL Server 2000 as Back-end database for V Studio...
2
Cyberdyne
by: Cyberdyne | last post by:
Hi guys, could you please provide me with the best solution to backup my MSSQL Server running on Windows 2003 Small Business Server. I am currently using software that runs on four client...
4
by: =?Utf-8?B?ZGlub28=?= | last post by:
We are currently in the process of upgrading our web server from Windows 2000 advanced server to Windows 2003 SP2. We have few ASP.Net applications built with .NET framework 1.1 running on the web...
1
by: =?Utf-8?B?Sm9obiBCYXJy?= | last post by:
We have asp.net application setup using Windows Authentication. For the website, under directory security the only thing checked is "Windows Authentication". We have the users specified in SQL who...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.