Office Servers and Services

"La connaissance ne vaut que si elle est partagée" / "An effective Knowledge is a shared one"

SCOM 2012 R2 enable to connect on SQL Server 2012 X64 SP1 and SP1 CU9 [Solved]

Posted by Teruin laurent sur mars 27, 2014


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

Laisser un commentaire

Choisissez une méthode de connexion pour poster votre commentaire:

Logo WordPress.com

Vous commentez à l'aide de votre compte WordPress.com. Déconnexion / Changer )

Image Twitter

Vous commentez à l'aide de votre compte Twitter. Déconnexion / Changer )

Photo Facebook

Vous commentez à l'aide de votre compte Facebook. Déconnexion / Changer )

Photo Google+

Vous commentez à l'aide de votre compte Google+. Déconnexion / Changer )

Connexion à %s

 
%d blogueurs aiment cette page :