I'm getting an intermittent error when trying to access a SQL 2000 database with a Windows XP machine. This XP machine is authenticating to a 2000 DC. The error is a file access error and is as follows File (dbo.TApptNote) could not be opened. Error: Cannot generate SSPI context (S1000). Usually if the machine is rebooted the error will not occur when trying to access again, until later in the day. Any help would be greatly appreciated, thanks.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Error when trying to access SQL database
- Thread starter leap35
- Start date
Bernadette
MIS
Hi There
Check your MDAC version. Ver2.6 always tries to use NT Authentication. (hense SSPI errors) Try using another MDAC version. Version 2.7 has support for XP (I am nearly sure). I know that they fixed the problem in ver 2.6 sp1. Bernadette
Check your MDAC version. Ver2.6 always tries to use NT Authentication. (hense SSPI errors) Try using another MDAC version. Version 2.7 has support for XP (I am nearly sure). I know that they fixed the problem in ver 2.6 sp1. Bernadette
Thanks for your replies guys.....
By way of a follow up, I discovered that this was a connectivity issue as described in another post on this subject.
Check that the connection string etc is OK as otherwise the problem may be due to this, as was the case with me.
By way of a follow up, I discovered that this was a connectivity issue as described in another post on this subject.
Check that the connection string etc is OK as otherwise the problem may be due to this, as was the case with me.
- Status
Similar threads
- Locked
- Question
