How do I connect to MSSQL Server 2012 from SQL Server Management Studio?

This article will guide you on how to connect to MS SQL Server 2012 from SQL Server Management Studio. You can obtain login details from client area under title "MSSQL Server Details".

 

  1. Go to Search -> Type "Management studio" OR Go to Run -> Type SSMS and Hit Enter.

    Open SQL Server Management Studio

  2. You will see SQL Server Management Studio Window. Enter following details in that window:

    • Server type: Database Engine
    • Server name: VPS_IP_address, 1533
    • Authentication: SQL Server Authentication
    • Login: sa
    • Password: Password provided in login details. 
    • Click on Connect.


    Specify Details to Connect to MSSQL 2012 Server


  3. You are now connected to MS SQL Server 2012. 

    Successful Connection to MSSQL Server 2012


Note: Replace your VPS IP address with VPS_IP_address in server name field.


Read More:

Related Articles

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...

How to check active connections on your MS-SQL Database ?

To check active database connection in the MS SQL server please follow the below steps. Open...

How to Change MS SQL Database Recovery Model?

This article describes how to to change recovery model of a MS SQL database through SQL Server...

How do I close active connections in MSSQL Server?

Please refer to the following steps to close active connections in the MS SQL server. Open the...

How to add db_owner role to newly created users?

From Plesk version 12, MSSSQL users created from the Plesk panel will not have the db_owner...

  • 14 Users Found This Useful

Was this answer helpful?