Login failed for user ‘%ls’. Only administrators may connect at this time.

Details
Product: SQL Server
Event ID: 18451
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Login failed for user ‘%ls’. Only administrators may connect at this time.
   
Explanation
SQL Server is in the process of shutting down. During shutdown, only members of the sysadm fixed server role can make new connections. A shutdown may be initiated by a person or by a program such as cluster administrator, or the shutdown may be the result of problems such as an unhandled exception.
   
User Action
Wait for the SQL Server shutdown to complete, and then restart SQL Server. Once SQL Server is restarted, retry your connection. If you must connect to SQL Server before the shutdown is complete, you can try to connect with a member of the system administrators role; this will only succeed until a certain point in the shutdown process is reached.

If the shutdown was unexpected, review the SQL Server error logs and the event logs for related messages that can help to determine the cause of the shutdown.

For more information refer to the Books Online topics, “Stopping SQL Server” and “SHUTDOWN.”

Related:

Leave a Reply