Introduction
In this document we will validate that from MTLMS01 and MTLMS02 you communicate with both SQL Servers. It is very important that the user OMAdmin can be connect with both SQL servers because OMAdmin will create the Database OperationsManager and the OperationsManagerDW Database during the installation.We will use ODBC Data Access Source to validate if the user can have access to both SQL servers
Validate the communication with SQL Servers
Validate that the OMAdmin User can connect to the MTLSQL01 Server from Server MTLMS01
- Open a session on MTLMS01 with OMAdmin user
- Click Start
- Click Administrative Tools
- Click Data Source(ODBC)
- Click Add
We will have only one choice
- Click Finish
- Type a description in name
- It can be anything
- Type MTLSQL01\OpsMgrOM
- The SQL name Server with the instance name
- Click Next
- Leave the default
- Here we will use the with Windows NT authentication ( the OMAdmin)
- Click Next
- Leave the default
- Click Next
- Leave the default
- Click Finish
- Click Test data Source
If the user OMAdmin can connect you will get Test Completed Succufully
- Click Cancel 3 times to close the SQL Server ODBC Data Source Test
Validate that the OMAdmin User can connect to the MTLRS01 Server From Server MTLMS01
Repeat the same step to connect to the MTLRS01
- Open a session on MTLMS01 with OMAdmin
- From MTLMS01 To connect to the MTLRS01
- Type MTLRS01\OpsMgrRS
Validate that the OMAdmin User can connect to the MTLSQL01 Server From Server MTLMS02
- Open a session on MTLMS02 with OMAdmin
- From MTLMS02 To connect to MTLSQL01
- Type MTLSQL01\OpsMgrOM
- Click Next
Validate that the OMAdmin User can connect to the MTLRS01 Server From Server MTLMS02
- Open a session on MTLMS02 with OMAdmin
- From MTLMS02 To connect to MTLSQL01
- Type MTLSQL01\OpsMgrOM
- Click Next
In the Next Document
In the next document we will install the first management Server 2012 SP1 server on MTLMS01
Cheers,
Alain Laventure
Senior Consultant
Exchange Expert, SCOM Expert and Lync specialist
Allain’s Bio: http://msmvps.com/blogs/andersonpatricio/pages/bio-alain-laventure.aspx