SSPI ERROR - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SSPI ERROR

Author

Topic

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2002-12-21 : 02:04:16

hello,
I got an error can not initiate SSPI while i tried to configure sql server using windows authentication on one of the users . windows authentication works well on the remaining machines.we r using sql 2000 and the operating system on the users machine is windows XP.
help appreciated.
harshal.

Expect the UnExpected

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2002-12-24 : 08:09:42

can anyone please provide me any clues as in which direction I should
go about solving this error???
thankyou.
regards,
harshal

Expect the UnExpected

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-12-24 : 08:46:05

Do you get this error for all network protocols ? e.g. if you set up an alias for the server on the client using the Client Network utility using named pipes or TCP/IP do you get this error for both. Can you issue the following from a command prompt on the client to the server net use \\servername\IPC$ ? After you run that do you still get this error ? Also, is the XP client on XP SP1 ? If not, it might be worth applying that as well.

HTH
Jasper Smith

Edited by - jasper_smith on 12/24/2002 08:52:07

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2002-12-25 : 00:21:01

quote:

Do you get this error for all network protocols ? e.g. if you set up an alias for the server on the client using the Client Network utility using named pipes or TCP/IP do you get this error for both. Can you issue the following from a command prompt on the client to the server net use \\servername\IPC$ ? After you run that do you still get this error ? Also, is the XP client on XP SP1 ? If not, it might be worth applying that as well.

HTH
Jasper Smith

Edited by - jasper_smith on 12/24/2002 08:52:07

I have tried using named pipes and tcp/ip the error still persists.I have also used \\servername\ipc$ it says can not connect to \\servername\ipc$ ,invalid function.
the sp1 is not installed on the machines I'll try installling it.

thanks for the help.
regards,
harshal

Expect the UnExpected

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2002-12-25 : 05:37:51

the problem was solved by using multiprotocol .
thanks
regards,
harshal.

Expect the UnExpected

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources