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 Studio, please open support ticket @ https://www.tvmserver.com/clients/submitticket.php mentioning your connecting Public IP address and Database Version.

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 ",1435' after the IP/Hostname to specify port '1435' for MSSQL 2008 eg: eg: servername,1435.
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.

  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

How to View Database via PhpMyAdmin / ASP.Net Enterprise Manager in Odin Plesk Panel

To View Database via PhpMyAdmin / ASP.Net Enterprise Manager in Plesk, Please follow the...

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

Connection String for MsSQL 2008 database

Remote Database is strictly not allowed in Shared Hosting Servers. You can use the following...

Connection String for MsSQL 2012 database

Remote Database is strictly not allowed in Shared Hosting Servers. You can use the following...

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