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.