| Author |
Topic |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2007-12-10 : 09:25:06
|
| SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. Has anyone seen this one before? I am trying to cennect through SSMS |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-10 : 09:36:31
|
Huh? You are able to set SSPI when working with SSMS?Post your actual code.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2007-12-10 : 09:47:37
|
| No code to post, just trying to connect to an instance in SSMS. I can connect to other instance just fine. All server are in the same Domian. |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2007-12-10 : 09:54:51
|
| If I remote into the server then do a trusted connection to the instance it works just fine. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-10 : 10:03:03
|
Do you have a firewall installed between your client machine and server machine?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-10 : 10:03:33
|
Is server machine on same network?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2007-12-10 : 10:11:48
|
| no firewall, same network |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-10 : 10:15:55
|
Which protocols have you enabled for SQL Server?Names pipes only?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2007-12-10 : 10:19:06
|
| TCp & Named pipes |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2007-12-10 : 10:40:15
|
| I can map a drive to the server. Ad I can used trusted to a sql 2000 instance on the same box |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2007-12-10 : 14:33:31
|
| Problem Solved:Control panel > User accounts > select user name > Click advanced tab > click manage passwords > removed stored password for server. |
|
|
|
|
Cannot connect to Db engine