Deploy SCCM 2012 R2 Primary Site on existing CAS

Hello,

We are trying to install primary site of SCCM 2012 R2 set in a Central American country and that should be part of the hierarchy of the CAS installed in Europe.

Follow the instructions in the installation wizard and when reviewing the prerequisites runs, we received the following errors:

  • Connection to SQL Server on central administration site = FAILED
  • Parent/child database collation = FAILED
  • Site server computer account administrative rights = FAILED

We have reviewed the administrative account permissions, we reviewed the communication between firewall on CAS site and firewall on primary site and seems to be all right.

We appreciate that we can give some additional ideas to review and resolve these incidents and to complete the installation of the primary site that is associated with the CAS.

Best regards,

Manuel

August 24th, 2015 10:41am
Is the account running the setup and the computer account of the site local admin on the CAS and sysadmin in SQL?
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2015 10:44am

Hi,

My guess is that there is a communication/firewall/nameresolution issue as "Connection to SQL Server on central administration site = FAILED" then the collation error is because it couldn't reach the server. So I would start with the basic stuff, can you ping the DB server? can you resolve the DNS name?

Chech the C:\ConfigMgrPreReq.log for more detailed information.

Regards,
Jrgen

August 24th, 2015 10:47am

Thank you Torsten for advices.

We already checked the suggested configuration and discovered that computer account of the site local cannot be resolved on the domain where is installed the CAS and the SQL, so we are tryinng to fix it the configuration and later test the installation again.

I will let you know the results.

Best regards,

Manuel

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 10:49am

Hi,

We review some configurations and we had to open firewall ports that were blocking communications, now we can communicate between servers, but one SQL error persists as is described on the image

We have made sure to give the required permissions in SQL Server and SCCM .

In the SQL Server (which belongs to the domain of Central America ) we have assigned the following configurations:

* CAS Computer (Europe domain) - Added as Local Administrator and Sysmanager on SQL (CentralAmerica Domain)

* SQL from CAS (Europe domain) - Added as Local Administrator and Sysmanager on SQL (CentralAmerica Domain)

* SCCMAdmin (Europe domain account) - Added as Local Administrator and Sysmanager on SQL (CentralAmerica Domain) -- This is the account we are using to install the Primary Site on CentralAmerica domain

* SCCMPrimarySite computer (CentralAmerica domain) - Added as Local Administrator and Sysmanager on SQL (CentralAmerica Domain)

On the ConfigMgrSetupWizard.log we are getting this messages:

9/8/2015 12:45:20 PM: ConfigMgrSetupWizard Information: 1 : Selected sql server instance name = [DBSV01]
9/8/2015 12:45:20 PM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database CM_PM1 on server me01sidb023.me.inet.
9/8/2015 12:45:20 PM: ConfigMgrSetupWizard Error: 1 : Exception message: [Cannot open database "CM_PM1" requested by the login. The login failed.
Login failed for user 'TCORP\SCCMAdmin'.], Exception details: [System.Data.SqlClient.SqlException: Cannot open database "CM_PM1" requested by the login. The login failed.
Login failed for user 'TCORP\SCCMAdmin'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.SystemCenter.ConfigMgr.Setup.DatabaseUtility.GetSqlConnection(String databaseName, String serverName, Boolean encrypt)].

 

On the ConfigMgrPrereq.log we got this messages:

<09-08-2015 16:15:05> INFO: CheckLocalSys is Admin of <me01sidb023.me.inet>.
<09-08-2015 16:15:12> me01sidb023.me.inet;    Site server computer account administrative rights;    Error;    Configuration Manager Setup requires that the site server computer has administrative rights on the SQL Server and management point computers.
<09-08-2015 16:15:12> me01sidb023.me.inet;    SQL Server security mode;    Warning;    The SQL Server name specified is configured for SQL authentication security. It is recommended to configure the SQL Server to operate only in Windows authentication security before you continue Configuration Manager Setup.

I will appreciate advices about this issue.

Best regards,

Manuel

September 9th, 2015 1:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics