Home » Categories » Multiple Categories

What is my MS SQL Connection String on my SQL Management Studio tool?

The connection string of your MS SQL database will always depend on the MS SQL version that you create via our Control Panel. You can find the connection string details by logging into our Control Panel -> Database.

When you connect from your local PC to your database located on our server, there is a remote connection made between your PC and your database on our server. Hence, you need to use our server's IP address to connect. You can find our server's IP Address on the activation email that we sent you during the activation of your account.

The following is just an example of the SQL Server connection:




For the new Control Panel, please do NOT use the private IP to connect on your SSMS tool. Please check the following screenshot:


 
For the above case, the IP used on your SSMS tool is NOT 10.70.15.211,778. However, the correct IP Address is always your Control Panel IP Address, together with the correct SQL Server Port Number (e.g. 159.253.151.168,778)


The following is our SQL Server Port Number:

SQL 2008: Port 777
SQL 2008 R2: Port 778
SQL 2012:
Port 779
SQL 2014: Port 780
SQL 2016: Port 781

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Do you support MySQL WebAdmin Access?
Viewed 1935 times since Tue, May 1, 2012
How can I change my SQL Server collation name?
Viewed 2219 times since Mon, May 21, 2012
Do you support SQL 2014?
Viewed 1638 times since Tue, Feb 3, 2015
Do you support SQL Reporting Service (SSRS)?
Viewed 2242 times since Tue, May 1, 2012
How often do you backup my website?
Viewed 2826 times since Tue, May 1, 2012
How can I access my nightly database backup?
Viewed 1632 times since Tue, May 1, 2012
Can i login to my MySQL database via my own mySQL tool?
Viewed 1785 times since Mon, May 7, 2012
Do you support MS SQL WebAdmin access?
Viewed 3734 times since Tue, May 1, 2012
Can I have more than one MS SQL database on my hosting account?
Viewed 2117 times since Tue, May 1, 2012