This guide shows you how to establish a remote connection to your Microsoft SQL Server database using SQL Server Management Studio (SSMS). You'll configure the connection settings and authenticate using SQL Server credentials to access your database remotely.

How to Connect

  1. Step 1: Launch SQL Server Management Studio

    Open Microsoft SQL Server Management Studio on your computer.

    SQL Server Management Studio launch screen

  2. Step 2: Open the Connect to Server Dialog

    The "Connect to Server" dialog box will appear on the screen.

    Connect to Server dialog box

  3. Step 3: Configure Connection Settings

    Fill in the connection details:

    • In the Server type list box, choose "Database Engine."
    • In the Server name text box, input the server name or IP address.
    • In the Authentication list box, opt for "SQL Server Authentication."
    • In the Login text box, enter the Microsoft SQL database username.
    • In the Password text box, provide the password.
    • To avoid re-entering the password with each connection, select the "Remember password" checkbox.

    Connection settings filled in

  4. Step 4: Connect to the Database

    Click on "Connect" to establish the connection.

  5. Step 5: Verify Connection

    The database will be visible in the Object Explorer window, confirming a successful connection.

    Database visible in Object Explorer