☰

SQL Server 2016 安装进入单用户模式

tag-icon • tag-icon windows sql-server windows-server-2016 sql-server-2016
SQL Server 2016 安装进入单用户模式

我们遇到了一个问题，在 Win 2016 上安装 SQL 2016 时，大约有 1/5 会出现此问题（使用 amazon EC2）。安装失败，似乎是因为 SQL Server 在安装过程中进入了单用户模式。我有完整的日志，但已附上发生此问题的引导日志部分。

似乎在发生之前已经完成了大约 3/4 的路程。有什么想法吗？

(01) 2017-09-20 09:21:06 Slp: Connection string: Data Source=\\.\pipe\SQLLocal\MSSQLSERVER;Initial Catalog=master;Integrated Security=True;Pooling=False;Connect Timeout=300;Network Library=dbnmpntw;Application Name=SqlSetup
(01) 2017-09-20 09:21:06 Slp: Sco: Connection error code from SqlException is : 18461
(01) 2017-09-20 09:21:06 ACE: ERROR: Unable to connect to SQL Server Engine. Exception: 'Microsoft.SqlServer.Configuration.Sco.ScoException: Login failed for user 'CORP\EC2AMAZ-536HENV$'. Reason: Server is in single user mode. Only one administrator can connect at this time. ---> System.Data.SqlClient.SqlException: Login failed for user 'CORP\EC2AMAZ-536HENV$'. Reason: Server is in single user mode. Only one administrator can connect at this time.
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.GetConnection()
   at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.Connect()
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.Connect()
   at Microsoft.SqlServer.Configuration.Agent.SqlScriptExecutionWrapper.PrepareScriptConnection()'
(01) 2017-09-20 09:21:06 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
(01) 2017-09-20 09:21:06 Slp: Login failed for user 'CORP\EC2AMAZ-536HENV$'. Reason: Server is in single user mode. Only one administrator can connect at this time.

答案1

今天我遇到了这种情况。我卸载了 SQL Server 并重新运行了安装。在此之前，我确实在 SQL Server 配置管理器中注意到 DB 引擎确实已安装并正在运行，我认为这很奇怪，因为 UI 在 DB 引擎安装旁边给了我一个红色的“X”。

第二次安装时，我收到同样的错误，但注意到“重试”选项。我选择了“重试”，一切顺利完成。

相关内容