The logon attempt failed [SQLSTATE 42000] (Error 780) OLE DB provider "SQLNCLI10" for linked (4250135)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

The logon attempt failed [SQLSTATE 42000] (Error 780) OLE DB provider "SQLNCLI10" for linked
Description

The following error may appear when trying to run the data collect job in Capacity Manager for SQL Server.
Message
Executed as user: SQL Server Network Interfaces: The logon attempt failed [SQLSTATE 42000] (Error 780) OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Cannot generate SSPI context". [SQLSTATE 01000] (Error 7412). The step failed.
Cause

Corrupt Registry on the monitored SQL Server.
Resolution

WORKAROUND:
1. Please go to start | Run | type in Regedit
2. Please go to the following registry key: HKeyLocalMachine\Software\Microsoft\MSSQLServer\Client\SNI9.0
3. Look at the 2 values there (ProtocolOrder and ProtocolsSupported),
These should be REG_MULTI_SZ values.
ProtocolsSupported should be sm tcp np via.
ProtocolOrder should have an entry for each protocol you have enabled, in the order from right to left that you want them to be.
sm = Shared Memory
tcp = TCP/IP
np = Named Pipes
via = VIA
So, if you have TCP/IP enabled and listed first, then Named Pipes, then Shared Memory, and VIA is disabled your value for ProtocolOrder would be
tcp
np
sm

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title