HI
On 27 March 2014 morning , we have just install a fresh Windows 2012 R2 french Standard version with only Microsoft components, Disabling firewall, install Sql Server 2012 (SQL_Svr_Standard_Edition_2012_w_SP1_French_Download_Only_64bit_-2_X18-78138) and try to install Scom 2012 R2 (SCOM_SW_DVD5_Sys_Ctr_2012_R2_French_OpsMgr_MLF_X19-18423)
No Way to connect. All is correct the Sql Browser listen on 1433 ports but no way to connect. Sql Management Studio connect correctly.
15:32:05]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: Le service spécifié n’existe pas en tant que service installé
[15:32:05]: Error: :InnerException.StackTrace:
[15:32:05]: Warn: :Could not start the SQL Service W-IMA-1\scom but we will attempt to connect anyway.
[15:32:05]: Debug: :Connection was not open. We will try to open it.
[15:32:05]: Debug: :SqlConnectionReady returned True.
[15:32:05]: Info: :Info:Using DB command timeout = 1800 seconds.
[15:32:05]: Info: :SQL Product Level: SP1
[15:32:05]: Info: :SQL Edition: Standard Edition (64-bit)
[15:32:05]: Info: :SQL Version: 11.0.3000.0
[15:32:05]: Always: :Current Version of SQL=11.0.3000.0 Required Version=10.50.2500.0
[15:32:05]: Always: :Entering GetRemoteOSVersion.
[15:32:05]: Info: :Info: remoteOS = 6.3.9600
[15:32:05]: Info: :Info:Using DB command timeout = 1800 seconds.
[15:32:05]: Info: :Info:Using DB command timeout = 1800 seconds.
[15:32:05]: Info: :The SQL Collation is valid.
[15:32:05]: Info: :Info:Using DB command timeout = 1800 seconds.
[15:32:05]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
[15:32:05]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
We try this on the Sql Server
Same issue.
After that we have installed on our local Sql Server the CU 9 : http://support.microsoft.com/kb/2931078
[18:21:48]: Always: :DatabaseConfigurationPage: Attempting to connect to database using server\instance W-IMA-1\scom. If we need it, the port is 1433
[18:21:48]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Le service MSSQL$scom est introuvable sur l’ordinateur ‘W-IMA-1’.
[18:21:48]: Error: :StackTrace: à System.ServiceProcess.ServiceController.GenerateNames()
à System.ServiceProcess.ServiceController.get_ServiceName() à System.ServiceProcess.ServiceController.GenerateStatus() à System.ServiceProcess.ServiceController.get_Status()
à Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[18:21:48]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: Le service spécifié n’existe pas en tant que service installé
[18:21:48]: Error: :InnerException.StackTrace:
[18:21:48]: Warn: :Could not start the SQL Service W-IMA-1\scom but we will attempt to connect anyway.
[18:21:48]: Info: :Info:Opening/Testing Sql Connection on W-IMA-1\scom, port:
[18:21:49]: Debug: :Connection was not open. We will try to open it.
[18:21:54]: Error: :Error opening SQL connection.: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: Une erreur liée au réseau ou spécifique à l’instance s’est produite lors de l’établissement d’une connexion à SQL Server. Le serveur est introuvable ou n’est pas accessible. Vérifiez que le nom de l’instance
est correct et que SQL Server est configuré pour autoriser les connexions distantes. (provider: SQL Network Interfaces, error: 26 – Erreur lors de la localisation du serveur/de l’instance spécifiés)
[18:21:54]: Error: :StackTrace: à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
à System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
à System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
à System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
à System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
à System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
à System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
à System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
à System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
à System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
à System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
à System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
à System.Data.SqlClient.SqlConnection.Open()
à Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.OpenAndTestSqlConnection(DbConnection sqlConnection, Int32 retries)
[18:21:54]: Always: :OpenAndTestSqlConnection: connection string – Data source=W-IMA-1\scom;Integrated Security=true;Connection Timeout=5
[18:21:54]: Debug: :Connection was not open. We will try to open it.
[18:21:54]: Error: :Error opening SQL connection.: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: Une erreur liée au réseau ou spécifique à l’instance s’est produite lors de l’établissement d’une connexion à SQL Server. Le serveur est introuvable ou n’est pas accessible. Vérifiez que le nom de l’instance est correct et que SQL Server est configuré pour autoriser les connexions distantes. (provider: SQL Network Interfaces, error: 26 – Erreur lors de la localisation du serveur/de l’instance spécifiés)
[18:21:54]: Error: :StackTrace: à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) à System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
à System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
à System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
à System.Data.SqlClient.SqlConnection.Open()
à Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.OpenAndTestSqlConnection(DbConnection sqlConnection, Int32 retries)
[18:21:54]: Always: :OpenAndTestSqlConnection: connection string – Data source=W-IMA-1\scom;Integrated Security=true;Connection Timeout=5
[18:21:54]: Debug: :SqlConnectionReady returned False.
[18:21:54]: Info: :Info:Opening/Testing Sql Connection on W-IMA-1\scom, port: 1433
[18:21:54]: Debug: :Connection was not open. We will try to open it.
[18:21:55]: Debug: :SqlConnectionReady returned True.
[18:21:55]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Le service MSSQL$scom est introuvable sur l’ordinateur ‘W-IMA-1’.
[18:21:55]: Error: :StackTrace: à System.ServiceProcess.ServiceController.GenerateNames()
à System.ServiceProcess.ServiceController.get_ServiceName()
à System.ServiceProcess.ServiceController.GenerateStatus()
à System.ServiceProcess.ServiceController.get_Status() à Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[18:21:55]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: Le service spécifié n’existe pas en tant que service installé
[18:21:55]: Error: :InnerException.StackTrace:
[18:21:55]: Warn: :Could not start the SQL Service W-IMA-1\scom but we will attempt to connect anyway.
[18:21:55]: Debug: :Connection was not open. We will try to open it.
[18:21:55]: Debug: :SqlConnectionReady returned True.
[18:21:55]: Info: :Info:Using DB command timeout = 1800 seconds.
[18:21:55]: Info: :SQL Product Level: SP1
[18:21:55]: Info: :SQL Edition: Standard Edition (64-bit)
[18:21:55]: Info: :SQL Version: 11.0.3412.0
[18:21:55]: Always: :Current Version of SQL=11.0.3412.0 Required Version=10.50.2500.0
[18:21:55]: Always: :Entering GetRemoteOSVersion.
[18:21:55]: Info: :Info: remoteOS = 6.3.9600
[18:21:55]: Info: :Info:Using DB command timeout = 1800 seconds.
[18:21:55]: Info: :Info:Using DB command timeout = 1800 seconds.[18:21:55]: Info: :The SQL Collation is valid.
[18:21:55]: Info: :Info:Using DB command timeout = 1800 seconds.
[18:21:55]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
[18:21:55]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
After 9 hours to try to install Scom back home … fucking bad Day !
28 March 2014 (after 9 Hours trying to install SCOM….)
Removing Sql Server / Renaming the windows machine WIMA1 without « – » caracter
Reboot / resinstalling Sql Server . Reboot / Trying to install Scom 2012R2 SP1 FR Non OK/ Verifying SqlBrowser = OK
Installing CU9 on SQL Server 2012 R2 SP1 …….. Rebooting / Trying to install Scom 2012R2 SP1 FR Non OK (Log below)
[10:26:39]: Always: :CheckPrerequisites: Return Value 1
[10:26:39]: Always: :Entering Page: AdditionalPrerequisitesPage
[10:26:39]: Info: :Info:Attempting to get the text for the prereq: memoryCheckTitle
[10:26:45]: Always: :Entering Page: InstallScenario
[10:26:50]: Always: :Entering Page: EulaPageCleanInstall
[10:26:50]: Always: :Displaying localized EULA for localization: fr
[10:26:50]: Always: :Displaying Eula: C:\Users\LTERUINEXTADM\AppData\Local\SCOM\Setup\fr\eula_fr_eval.rtf
[10:26:53]: Info: :Info:User has agreed to EULA.
[10:26:53]: Info: :Not all of the information on the screen is valid, so we’re not going to check disk space.
[10:26:53]: Info: :Not all of the information on the screen is valid, so we’re not going to check disk space.
[10:26:53]: Always: :Entering Page: FirstServerOperationalDb
[10:26:54]: Info: :Not all of the information on the screen is valid, so we’re not going to check disk space.
[10:26:54]: Info: :Not all of the information on the screen is valid, so we’re not going to check disk space.
[10:27:18]: Always: :DatabaseConfigurationPage: Attempting to connect to database using server\instance WIMA1\SCOM. If we need it, the port is 1433
[10:27:18]: Debug: :MSSQL$SCOM on server WIMA1 is in a running state
[10:27:18]: Info: :Info:Opening/Testing Sql Connection on WIMA1\SCOM, port:
[10:27:19]: Debug: :Connection was not open. We will try to open it.
[10:27:19]: Debug: :SqlConnectionReady returned True.
[10:27:19]: Debug: :MSSQL$SCOM on server WIMA1 is in a running state
[10:27:19]: Debug: :Connection was not open. We will try to open it.
[10:27:19]: Debug: :SqlConnectionReady returned True.
[10:27:19]: Info: :Info:Using DB command timeout = 1800 seconds.
[10:27:19]: Info: :SQL Product Level: SP1
[10:27:19]: Info: :SQL Edition: Standard Edition (64-bit)
[10:27:19]: Info: :SQL Version: 11.0.3412.0
[10:27:19]: Always: :Current Version of SQL=11.0.3412.0 Required Version=10.50.2500.0
[10:27:19]: Always: :Entering GetRemoteOSVersion.
[10:27:19]: Info: :Info: remoteOS = 6.3.9600
[10:27:19]: Info: :Info:Using DB command timeout = 1800 seconds.
[10:27:19]: Info: :Info:Using DB command timeout = 1800 seconds.
[10:27:19]: Info: :The SQL Collation is valid.
[10:27:19]: Info: :Info:Using DB command timeout = 1800 seconds.
[10:27:19]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
[10:27:19]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
[10:27:20]: Always: :DatabaseConfigurationPage: Attempting to connect to database using server\instance WIMA1\SCOM. If we need it, the port is 1433
[10:27:20]: Debug: :MSSQL$SCOM on server WIMA1 is in a running state
[10:27:20]: Info: :Info:Opening/Testing Sql Connection on WIMA1\SCOM, port:
[10:27:20]: Debug: :Connection was not open. We will try to open it.
[10:27:20]: Debug: :SqlConnectionReady returned True.
[10:27:20]: Debug: :MSSQL$SCOM on server WIMA1 is in a running state
[10:27:20]: Debug: :Connection was not open. We will try to open it.
[10:27:20]: Debug: :SqlConnectionReady returned True.
[10:27:20]: Info: :Info:Using DB command timeout = 1800 seconds.
[10:27:20]: Info: :SQL Product Level: SP1
[10:27:20]: Info: :SQL Edition: Standard Edition (64-bit)
[10:27:20]: Info: :SQL Version: 11.0.3412.0
[10:27:20]: Always: :Current Version of SQL=11.0.3412.0 Required Version=10.50.2500.0
[10:27:20]: Always: :Entering GetRemoteOSVersion.
[10:27:20]: Info: :Info: remoteOS = 6.3.9600
[10:27:20]: Info: :Info:Using DB command timeout = 1800 seconds.
[10:27:20]: Info: :Info:Using DB command timeout = 1800 seconds.
[10:27:20]: Info: :The SQL Collation is valid.
[10:27:20]: Info: :Info:Using DB command timeout = 1800 seconds.
[10:27:20]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
[10:27:20]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
Removing Sql Server / Rebooting / Installating Sql Server with Default Option (No Scom Name instance).
The issue is problably due to the instance Name (Scom). Is it too difficult to include in the developpement a verification task to check this fuck..value ?
Laurent Teruin
Travailler ensemble 