SSPI error message

Thank you. It is working based on changes you suggested. how ever I am not able to understand why it suddenly stops working.

Thanks

"Kevin McDonnell [MSFT]" wrote:

 > Simple fix.
 > Change the Client Network Utility to use Named Pipes instead of TCP/IP.
 > Or create a Named Pipes alias.
 >
 > Otherwise, you'll need to use network monitor and Netdiag.exe to narrow
 > down the source of the problem.
 >
 > Thanks,
 >
 > Kevin McDonnell
 > Microsoft Corporation
 >
 > This posting is provided AS IS with no warranties, and confers no rights.
 >
 >
 >
 >
 >> Stay informed about: SSPI error message 

I have a similar problem occasionally with an app that I run. Usually this
error occurs for me when I am attempting to connect to a SQL Server that was
turned off before I launched the app, but turned on after the app was
launched. Shutting down the app and restarting fixes it for me.

Thanks,
Michael C.

"Kris" wrote in message

 > When I am trying to connect to SQL Server I am getting error message
 >
 > "SQL Server registration failed because of the connection failure
displayed below.
 > Can not generate SSPI context".
 >
 > Can anyone please help. How can i fix this problem.
 >
 > Thanks
 > -Kris
 >
 >
 >
 >> Stay informed about: SSPI error message 

Hi Kris,
Its failing to authenticate the user over TCP/IP. In order to do this
we have to call an additinal API , SSPI. We also have to communicate with
the DC to make the connection succeed. With Named Pipes the client
impersonation is built-in. There's no additional overhead associated with
it.


Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.
 >> Stay informed about: SSPI error message 

Thanks Kevin, simple fix to the big trouble.

GU

"Kevin McDonnell [MSFT]" wrote:

> Hi Kris,
> Its failing to authenticate the user over TCP/IP. In order to do this
> we have to call an additinal API , SSPI. We also have to communicate with
> the DC to make the connection succeed. With Named Pipes the client
> impersonation is built-in. There's no additional overhead associated with
> it.
>
>
> Thanks,
>
> Kevin McDonnell
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
>
>
 >> Stay informed about: SSPI error message