Amazon RDS - MS SQL Connecting to DB



To connect to Amazon RDS MSSQL server we need a client software. In this case we use Sql Server Management Studio. Install it using the link SSMS .

After it is successfully installed we follow the steps below to connect it to the Amazon RDS.

Step-1

From the DB instance details get the end point.

 mssql_endpoint.jpg

Step-2

Use the end point and the master user credentials as the connection details.

 mssql_conn_details.jpg

Step-3

Once connected, we get the following window.

 mssql_connected.JPG

Step-4

We can also query the MSSQL DB as shown below.

 mssql_query.JPG
Advertisements