Home » Categories » Multiple Categories |
What is my MS SQL Connection String on my SQL Management Studio tool? |
Article Number: 54 | Rating: 4.3/5 from 14 votes | Last Updated: Thu, Oct 26, 2017 at 3:30 AM
|
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
![]()
There are no attachments for this article.
|
Can I have more than one MySQL database on my hosting account?
Viewed 8438 times since Tue, May 1, 2012
I receive this error message: "Unknown file type (binary data)" when trying to deploy my SQL CE database. What did I do wrong?
Viewed 4253 times since Thu, May 3, 2012
Can I set up additional logins for my MySQL database?
Viewed 2876 times since Mon, Apr 30, 2012
Can I have one database user associated to more than 1 MS SQL database?
Viewed 3263 times since Tue, May 1, 2012
I receive this error message: "The server principal A is not able to access the database B under the current security context (Microsoft SQL Server, Error:916)"
Viewed 4029 times since Mon, Apr 30, 2012
How to Restore MSSQL Database by using "Import Dump"?
Viewed 278 times since Sun, Mar 9, 2025
How can I backup my MS SQL database?
Viewed 4852 times since Tue, May 1, 2012
Do you support SQL 2012?
Viewed 3324 times since Fri, May 4, 2012
Do you support MS SQL Profiler?
Viewed 3223 times since Wed, May 23, 2012
How often do you backup my website?
Viewed 4751 times since Tue, May 1, 2012
|