473,320 Members | 1,722 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,320 software developers and data experts.

Cannot generate SSPI context

Hello all,

Back-end: SS2000 SP2 + NT4
Front-end: A97 + XP

We are currently trying to add a Domain Server to our network. We added our
SQL Server to the domain and added a client too. Everything is working
fine... for maybe 20 or 30 minutes. Then the client generates this error:

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

Then we have to logout and login again. There is many KB on this error. We
try almost everthing without success. Now, the team is questionning the SQL
Server software config. Making it, hypotheticaly, to close a previously
opened connection and prevent a new one to being created. Both named pipes
and TCP/IP protocols are enabled in SS config.

So my main question is: Could this error be related to SS config/setup?

For more information about the error, here:
http://support.microsoft.com/kb/811889/en-us
you can read:
------------------
The SQL Server driver on a client computer uses integrated security to use
the Windows security token of the user account to successfully connect to a
computer that is running SQL Server. The Windows security token is delegated
from the client to the computer that is running SQL Server. The SQL Server
driver performs this delegation when the user's security token is delegated
from one computer to another by using one of the following configurations:
. NTLM over Named Pipes (not using Security Support Provider Interface
[SSPI])
. NTLM over TCP/IP sockets with SSPI
. Kerberos over TCP/IP sockets with SSPI

Security Support Provider Interface (SSPI) is a set of Windows APIs that
permits delegation and mutual authentication over any generic data transport
layer, such as TCP/IP sockets. Therefore, SSPI permits a computer that is
running a Windows operating system to securely delegate a user security
token from one computer to another over any transport layer that can
transmit raw bytes of data.

The "Cannot generate SSPI context" error is generated when SSPI uses
Kerberos to delegate over TCP/IP and Kerberos cannot complete the necessary
operations to successfully delegate the user security token to the
destination computer that is running SQL Server.
-------------------

Many thanks for your feedback.

Yannick
Jul 20 '05 #1
0 9515

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Il Ventu | last post by:
Hi My company uses a Windows 2000 server with MS SQL Server 2000. We have many clients with administrative software that use the MS SQL server, the problem is that we experimented randomly the...
4
by: John.Arthur | last post by:
Hello, I need to create picture containing number that I will write in the picture. I need it to show it to the users of my application and they will write the number in a textBox, so this is to...
4
by: Chris Bower | last post by:
Reposted from aspnet.buildingcontrols: Ok, I've got a bunch of derived controls that all have a property Rights of type Rights (Rights is an Enumerator). I wrote a custom TypeConverter so that I...
0
by: Peter | last post by:
Hi I have this situation where I had all my ASP.NET application working fine until I installed one particular ASP.NET application the other day. Now, one of my applications raises this error...
1
by: A Traveler | last post by:
Hello, i am having this problem. The exact error message is: "Unable to generate code for a value of type 'System.Web.UI.Page'. This error occurred while trying to generate the property value for...
4
by: danman226 | last post by:
I will be using a companyname, user name, and password to authenicate users in my system. I am trying to save the company name in the session for later use. I cannot access the Session object in...
1
by: Kelay | last post by:
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...
2
by: Van den Driessche Willy | last post by:
I am writing a HTTP Module to generate an RSS feed for certain requests. For the moment everything is hardcoded and my code looks like (the idea is - for the moment to generate the RSS feed on the...
1
by: Allan Ebdrup | last post by:
I get the error: "Cannot create an object of type 'CustomWizard' from its string representation 'CustomWizard1' for the CustomWizard Property." when I view my custom server web control in...
0
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...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: 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.