Simple way to check UAT connection to Production database server

Posted on Updated on

Today, I had a chance to talk with our Senior Solution Architect via Skype about checking the connection between UAT environment and Production database server.

The goal is just to check if it’s working, as we’re planning to create a mimic of Production CM and CD in the UAT environment using the production database server

Note that this concept is also applicable to the rest of the environments,

  1. SIT > UAT
  2. UAT > SIT
  3. SIT > PROD
  4. PROD > SIT
  5. Others

A very high-level representational diagram:

UAT connecting to Production database server diagram.png
Two-way connection

So, to check, Open the command prompt and start typing the below command.

telnet <SPACE><IP_ADDRESS_OF_PROD_DATABASE_SERVER><SPACE>1433

eg.

telnet 10.1.2.345 1433

Important note: 1433 is the default TCP port of the SQL Server default instance. This is the common port allowed through the firewall. It applies to routine connections to the default installation of the Database Engine, or named instance that is the only instance running on the computer. More about configuring the Windows Firewall to Allow SQL server access here.

You would be able to see this window if successful connection.

telnet

For failed connection, you would encountered a Connection failed message.

telnet_not_successful.png

Happy Sitecore’ing!

Advertisements

One thought on “Simple way to check UAT connection to Production database server

    […] issue caused by a task whereby I have to transfer PROD SC instance to UAT environment and that I have to change the sources in the connectionstrings, thus the issue […]

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s