Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2002-05-30 : 16:28:31
|
| Hi, anybody got this error ???I updated my OS from win2000 to winXP, since then, I'm alway getting this error. Connection FailedSqlState : 's1000'SQL Server error : 0[microsoft][odbc sql server Driver] cannot generate SSPI contextI'm connecting to my SQL server with trusted domain connection. It's like after one hour of connection, I'm not trusted anymore in my domain, but when I reboot, everything fine for the next hour. Short time solution, reboot every hour....noAnd I don't want to get back to win 2000Thanks |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-30 : 18:18:46
|
| Try either1) Using SQL Authentication - this problem is only with NT authentication2) Change your default client network library to named pipesStart>Programs>Microsoft SQL Server>Client Network UtilityIn the Enable protocols by order move named pipes to the top of the list using the arrows and click apply. It can also help to set up a named pipe alias for the server.[url]http://support.microsoft.com/support/kb/articles/q269/5/41.asp [/url]This KB article (although it refers to SQL7) is relavent. Make sure the relavent registry key exists on the client and that the 'NT LM Security Support Provider' service is started and running.More info can be found by searching google groups for SQL XP SSPI[url]http://groups.google.com/groups?as_q=XP%20SSPI&as_ugroup=microsoft.public.sqlserver.*&lr=&hl=en[/url]HTHJasper Smith |
 |
|
|
|
|
|
Authentification error