How to connect to a MsSQL 2012 database using SQL Server Management Studio


Remote Database is not allowed in our Shared Servers.  For getting Remote Access for Management Studio, please open support ticket @ https://www.tvmserver.com/clients/submitticket.php mentioning your connecting Public IP address and Database Version.  The remote connection will active only for 2 hours

Open the program SQL Server Management Studio Express and you will be prompted with a Connect to Server box. Fill out the fields with your database information.

The Server Name field is the IP/Hostname of the Database Server.
You must include ",1437' after the IP/Hostname to specify port '1437' for MSSQL 2012 eg: eg: servername,1437.
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.

The Password field is the password you have set up for the user.

and Click Connect.

 

  • 25 Users Found This Useful
Was this answer helpful?

Related Articles

How to connect to a MsSQL 2008 database using SQL Server Management Studio

Remote Database is not allowed in our Shared Servers.  For getting Remote Access for Management...

How to connect to a MsSQL 2014 database using SQL Server Management Studio

Remote Database is not allowed in our Shared Servers.  For getting Remote Access for Management...

How to connect to a MsSQL 2016 database using SQL Server Management Studio

Remote Database is not allowed in our Shared Servers.  For getting Remote Access for Management...

How to connect to a MsSQL 2017 database using SQL Server Management Studio

Remote Database is not allowed in our Shared Servers.  For getting Remote Access for Management...