Hi,
I came up with another article for the issue of Microsoft System Center Operation Manager 2012 secondary server installation issue. So sharing my experience here how I dealt with this situation.
OS - Microsoft Windows 2008 R2
Apps - Microsoft System Center Operation Manager 2012
Issue - While try to install SCOM 2012 secondary server into existing Management Group by selecting custom port for Data-Ware house, installation gets failed.
Here I have analyzed the set up log and found below error.
I came up with another article for the issue of Microsoft System Center Operation Manager 2012 secondary server installation issue. So sharing my experience here how I dealt with this situation.
OS - Microsoft Windows 2008 R2
Apps - Microsoft System Center Operation Manager 2012
Issue - While try to install SCOM 2012 secondary server into existing Management Group by selecting custom port for Data-Ware house, installation gets failed.
Here I have analyzed the set up log and found below error.
Error:
:StackTrace: at System.Net.Dns.InternalGetHostByName(String
hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at Microsoft.EnterpriseManagement.OperationsManager.SetupCommon.SetupUtils.CheckIsRemoteSqlServer(String
sqlInstanceName)
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupHelpers.GetAccountForDB(Account
dasAccount, String sqlServerInstance, String& dasAccountForDB)
at
Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsDelegates.OMDataWarehouseProcessor.SetDataWarehouseSecurity()
[16:17:36]:
Error: :FATAL ACTION: SetDataWarehouseSecurity
[16:17:36]:
Error: :FATAL ACTION: DWInstallActionsPostProcessor
[16:17:36]:
Error: :ProcessInstalls: Running the PostProcessDelegate returned false.
Cause:
The setup failed because we use 1443 as the SQL service port for
data warehouse server, there’s a known issue that when GUI passed the port
number to the setup, the format is not correct and causing exception.
The work around is to install the management server with command
line, however the SDK and data write account have special characters in the
password and could not be used in CMD prompt.
Resolution:
We change the port back to default 1433 port from SQL server
configuration manager and use following steps to update the databases.
1. On
the server hosting the operational database, update the OperationsManager
database table.
a. Open SQL Server Management Studio.
b. Expand Databases, OperationsManager, and Tables.
c. Right-click dbo.
MT_Microsoft$SystemCenter$DataWarehouse, and then click Edit
Top 200 Rows.
d. Change the value in the MainDatabaseServerName_2C77AA48_DB0A_5D69_F8FF_20E48F3AED0F
column from server name,1433 to server name.
e. Close SQL Server Management Studio.
2. On
the data warehouse server, update the member database.
a. Open SQL Server Management Studio.
b. Expand Databases, OperationsManagerDW, and Tables.
c. Right-click dbo.
MemberDatabase, and then click Edit Top 200 Rows.
d. Change the value in the ServerName
column from server name,1433 to server name
e. Close SQL Server Management Studio.
After the changes had been made, we rerun the setup and the
management server was successfully installed. So using another port will not work by design and treated as a Bug,
Reference-
Installing Operations Manager by Using the Command Prompt Window
- See Here
How to install Operations Manager 2012 single server
configuration from the command prompt - See Here
How to Install Additional Management Servers - See Here