How to sign into SQL Server Management Studio

Home > Search > How-to
  by

On the PC that SQL Server is installed, you can sign into SQL Server using the computer name followed by the instance name. For example, if the computer name is Server1 and the instance name is Instance1, you would enter Server1\Instance1 in the Server name field.

 

After you create a username and password in SQL Server, you can select SQL Server Authentication and enter your username and password.

 

Instead of using the computer name, if you want to use an IP address to connect, enable TCP/IP:

  1. Select the Windows Start icon, type mmc.exe in search, and select mmc.exe.
  2. In the Console, press Ctrl + M (or select File > Add/Remove Snap In).
  3. Move the SQL Server Configuration Manager to Selected snap-ins and select OK.
  4. Expand SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for instance_name.
  5. Right-click on Named Pipes and select Enable.
  6. Right-click on TCP/IP and select Enable.
  7. Right-click on TCP/IP, select Properties, and make the following adjustments:
    • Ensure the IP address matches the IP address of your SQL Server
    • Ensure Port number 1433 is listed
  8. Restart the PC.

 

You should now be able to connect using an IP address.

 

To connect to SQL Server from another computer in the network, ensure SQL Server is configured to allow remote connections:

  1. Sign into SQL Server
  2. In Object Explorer, right-click on the root object and select Properties.
  3. Select Connections.
  4. Ensure Allow remote connections to this server is checked.

 

Allow connections on port 1433 in Windows Firewall on the machine that has SQL Server installed.

  1. Select the Windows Start icon > Control Panel.
  2. Select Windows Firewall.
  3. Select Advanced settings.
  4. Select Inbound Rules.
  5. Select New Rule.
  6. Make the following selections in the New Inbound Rule Wizard:
    1. Check Port and select Next.
    2. Check TCP, enter port 1433, and select Next.
    3. Check Allow the connection and select Next.
    4. Check Domain, Private, and Public and select Next.
    5. Type Allow SQL Server port 1433 and select Finish.
  7. Select Outbound Rules.
  8. Select New Rule.
  9. Make the following selections in the New Inbound Rule Wizard:
    1. Check Port and select Next.
    2. Check TCP, enter port 1433, and select Next.
    3. Check Allow the connection and select Next.
    4. Check Domain, Private, and Public and select Next.
    5. Type Allow SQL Server port 1433 and select Finish.

You should now be able to connect to SQL Server from another PC in the LAN using the DNS name or IP address of the server.

 

To connect to SQL Server from a PC outside of the LAN, open port 1433 in your router.

 



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter in the box below so that we can be sure you are a human.




Comments