![]() ![]() ![]() You can find detailed information in the article “ SQL Server Startup Parameters“. If this problem occurred in a Cluster environment, you must clear this parameter from all nodes. Only one administrator can connect at this time. When I tried to connect with sqlcmd, I got this error: Login failed for user ‘MYDOMAIN\me’. So to change this parameter, you don’t have to connect to SQL Server Management Studio. Only one administrator can connect at this time Having somehow removed my own access to the database, I restarted SQL Server 2005 in single-user mode. SOLUTION:īecause SQL Server starts in single user mode, if your SQL Server Agent or another service (which usually becomes SQL Server Agent) connects to SQL Server before you, you will not be able to connect to your SQL Server Instance and encounter this error.Īdditionally, in SQL Server 2005 and later, SQL Server Startup parameters can be changed with SQL Server Configuration Manager. Therefore, only one admin can be connected at a time. The “-m” parameter starts the SQL Server service in single user mode. This problem may occur when you try to start the SQL Server service by putting “-m” as the startup parameter, and then restarting the SQL Server service. Only one administrator can connect at a time.” EXPLANATION: If you start SQL Server in single user mode only one administrator can connect at the same time. “A connection could not be established to . ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |