How to connect to MSSQL Server from local SQL Server Management Studio

How to connect to MSSQL Server from local SQL Server Management Studio

This article will guide you on how to connect to MS SQL Server from your local SQL Server Management Studio. You can obtain login details from VPS setup mail or by sanding a request to our support mail-id i.e. support@diadem.in from your registered mail-id. 

1. Go to Start -> All Programs -> Locate Microsoft SQL Server , Click on SQL Server Management Studio.

2. Enter following details in Connect to Server Window:

  • Server type: Database Engine
  • Server name: VPS_IP_address,5000
  • Authentication: SQL Server Authentication
  • Login: sa
  • Password: #Password provided in login details#

Click on Connect button. 

3. You are now connected to MSSQL Server.


    • Related Articles

    • Delete MSSQL Server DB from SQL Management Studio

      How to Delete a SQL Server DB from management studio Before we begin we must know about Limitations and Restrictions while deleting a database from SQl server DB. System databases cannot be deleted. Prerequisites Delete any DB snapshots that exist on ...

    • Restoring MSSQL database with Management Studio

      Restoring MS SQL database with management Studio To restore a database we can follow two below mentioned procedure to restore the database. Restore SQL database using T-SQL Restore SQL database using SQL Server Management Studio Restore SQL DB using ...

    • How to Create MS SQL Database Through SQL Server Management Studio

      This article will assist you to create MS SQL database through SQL Server Management Studio. 1. Open Run box by pressing Windows key + R. 2. In Run box type SSMS and hit enter. This will open connect to server window.

    • Take Full backup of MS-SQL database using management studio

      To take the full backup of MS-SQL database, please follow the below steps 1. Open SQL Server Management Studio and connect to the appropriate instance of Microsoft SQL Server Database Engine in Object Explorer. 2. Expand Databases node and then right ...

    • How To Restore a Microsoft SQL Database Backup Using SQL Server Management Studio

      Steps to Restore a Microsoft SQL Database Backup Using SQL Server Management Studio. Open SQL Server Management Studio and Connect to the SQL Server you want to restore the database to. Once you Connected to the SQL server, right click on the ...