MSSQL 2014 Database connection by using Microsoft SQL Server Management Studio


                  First download Microsoft SQL Server Management Studio Express from this link: http://www.microsoft.com/en-us/download/details.aspx?id=42299. Click Download, and select "MgmtStudio" for either 32 or 64 bit, depending on your processor. 

Once downloaded, open MSSQL Management Studio.

1. Connect to the Server with the server name and login credentials (Your login credentials are located within your web.config in the ConnectionString area as uid: and pwd: )

The Server Name field is the IP or Hostname of the Database Server. 
You must include ",1439' after the IP or Hostname to specify port '1439' for MSSQL 2014 eg: eg: YOUR-DOMAIN-NAME OR SERVER_IP,1439. servername needs to be replaced with your actual server name or domain name.

The Authentication field should be 'SQL Server Authentication' by default.
The Login field is the username you have set up for the database in plesk panel.
The Password field is the password you have set up for the user.

and Click Connect.


2. On the left navigation bar click on Databases.


After that select your database and execute your query against your databases

  • 16 Users Found This Useful
Was this answer helpful?

Related Articles

MSSQL 2008 Database connection by using Microsoft SQL Server Management Studio

                  First download Microsoft SQL...

MSSQL 2012 Database connection by using Microsoft SQL Server Management Studio

                  First download Microsoft SQL...

Powered by WHMCompleteSolution