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,
- SIT > UAT
- UAT > SIT
- SIT > PROD
- PROD > SIT
A very high-level representational diagram:
So, to check, Open the command prompt and start typing the below command.
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.
For failed connection, you would encountered a Connection failed message.