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 |
|
dbconsole
Starting Member
1 Post |
 Posted - 2008-06-03 : 22:49:22
|
| hello everyone,i meet a problem with sqlserver. i have a hp rx6600 server running windows 2003 sp2 for ia + sqlserver 2005 stardard edition for ia ,and i use sa user to login the server. recently, when the server works for two or three days,the client can't login the sqlserver ,and a reboot will resolve the problem,but after the same time ,the problem occers again. i check the error log in my server which is: SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 172.16.8.41] Have anyone meet this problem before or had some idea about it ,pls give some advice , thank you very much! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 23:05:57
|
| Take look at following link, quick fix is connecting to sql with named pipes:http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=84680&highlight_key=y&keyword1=sspi |
 |
|
|
|
|
|
sql server 2005 error