SQL Server Error : 165, Severity: 16. Privilege %ls may not be granted or revo

SQL Server Error : 165 Details

SQL Server Error: 165
Severity: 16
Event Logged or not: No
Description:
Privilege %ls may not be granted or revoked.
Severity 16 Description:
Indicates general errors that can be corrected by the user.

 

Solution for Resolving the Error

SQL Server [165] ODBC Error: 0, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]

It normally occurs very frequently like 10-20 times an hour and it to any job failures related to Named pipes. All of other jobs on the same SQL instance might be working.

Make sure named pipes is running and troubleshoot jobs usiing named pipes.

SQL Server Error Code and solution summary

SQL Server Error: 165
Severity: 16
Event Logged or not: No
Description:
Privilege %ls may not be granted or revoked.