How to Deploy and configure OpsMgr 2012 SP1 – Part 7 – How to validate the communication between OpsMgr 2012 SP1 and the SQL Servers

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

image

We will have only one choice

  • Click Finish

image

  • Type a description in name
  • It can be anything
  • Type MTLSQL01\OpsMgrOM
  • The SQL name Server with the instance name
  • Click Next

image

  • Leave the default
  • Here we will use the with Windows NT authentication ( the OMAdmin)
  • Click Next

image

  • Leave the default
  • Click Next

image

  • Leave the default
  • Click Finish

image

  • Click Test data Source

image

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

image

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

image

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

image

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

image

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

Leave a Reply

Your email address will not be published. Required fields are marked *