Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Connecting to your Microsoft SQL Server DB instance

Focus mode
Connecting to your Microsoft SQL Server DB instance - Amazon Relational Database Service

After Amazon RDS provisions your DB instance, you can use any standard SQL client application to connect to the DB instance. In this topic, you connect to your DB instance by using either Microsoft SQL Server Management Studio (SSMS) or SQL Workbench/J.

For an example that walks you through the process of creating and connecting to a sample DB instance, see Creating and connecting to a Microsoft SQL Server DB instance.

Before you connect

Before you can connect to your DB instance, it has to be available and accessible.

  1. Make sure that its status is available. You can check this on the details page for your instance in the AWS Management Console or by using the describe-db-instances AWS CLI command.

    Check that the DB instance is available
  2. Make sure that it is accessible to your source. Depending on your scenario, it may not need to be publicly accessible. For more information, see Amazon VPC and Amazon RDS.

  3. Make sure that the inbound rules of your VPC security group allow access to your DB instance. For more information, see Can't connect to Amazon RDS DB instance.

Finding the DB instance endpoint and port number

You need both the endpoint and the port number to connect to the DB instance.

To find the endpoint and port
  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the upper-right corner of the Amazon RDS console, choose the AWS Region of your DB instance.

  3. Find the Domain Name System (DNS) name (endpoint) and port number for your DB instance:

    1. Open the RDS console and choose Databases to display a list of your DB instances.

    2. Choose the SQL Server DB instance name to display its details.

    3. On the Connectivity & security tab, copy the endpoint.

      Locate DB instance endpoint and port
    4. Note the port number.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.