Remotely Connecting to SQL Server

Remotely Connecting to SQL Server

Description: To connect to SQL server 2014 remotely you have to download “SQL server 2017 management studio express edition” and install it. To install it the prerequisite is .NET framework 4.7 to be installed in the computer then only u can install the management studio.

Step 1:  First open the "SQL server management studio express” and provide your domain name or SQL Database Server IP address in Place of "Server Name". Choose Authentication as "Sql Server Authentication". Provide your database Username and Password.

                          or

You can open your SQL Server Management Studio using Windows Authentication.

                             

Step 2: Click connect to connect to your database.

 

Step 3: When you have finished working click on Disconnect to exit from the Active connection.



    • Related Articles

    • Truncate SQL DBs remotely without admin privileges

      SQL Log: It records recent database transactions and is used to ensure database integrity in the event of a system restore, like database queries, updating/insertion/deletion of the records and all other database action. You can say it is a temporary ...

    • MS SQL database creation

      Log in SQL Server Management Studio to create database. Create a folder in "C:\SQLdomain\" as your domain name. C:\SQLdomain\testdomain.com Click right mouse button on Databases to open database menus and click New Database link. Assign a Database ...

    • 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.

    • 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 ...

    • 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 ...