An attempt to log in to SQL Server failed.

Details
Product: SQL Server Notification Services
Event ID: 1011
Source: NotificationServices
Version: 2.0.9999.9
Message: An attempt to log in to SQL Server failed.
   
Explanation
This error maps to SQL Server error 18456, which indicates that a given user does not have the appropriate permissions to log in.

The event log entry for this error includes the description of the SQL Server error that triggered it, which looks similar to the following:

Login failed for user <user_name>.</user_name>

   
User Action
Check that the user name noted in the error message has the appropriate permissions.

For more information, see the topic “Troubleshooting” in Notification Services Books Online.

Related:

Leave a Reply