I recently just switched some of my clients to Windows XP Pro. When they are using the database after about 20 to 30 minutes they get an error message that says "Cannot generate SSPI context." I don't understand it but it worked fine with Win 2K pro. My clients are having to keep logging off then logging back on. Is there anything I can try?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cannot generate SSPI context
- Thread starter mcell0042
- Start date
You can start by reading this:
You might also try toying around with these connection string parameters.
1. Add "Connection Reset=false;" to your connection string.
2. Try a different network library. Use "Network Library=dbmssocn;" for TCP/IP or "Network Library=dbnmpntw;" for Named Pipes.
3. Try setting the "Persist Security Info" property to either true or false.
You might also try toying around with these connection string parameters.
1. Add "Connection Reset=false;" to your connection string.
2. Try a different network library. Use "Network Library=dbmssocn;" for TCP/IP or "Network Library=dbnmpntw;" for Named Pipes.
3. Try setting the "Persist Security Info" property to either true or false.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question