Home » Categories » Multiple Categories |
I cannot login to my MS SQL database remotely. What did I do wrong? |
Article Number: 118 | Rating: 5/5 from 2 votes | Last Updated: Tue, Feb 3, 2015 at 11:05 PM
|
If you cannot login to your MS SQL database remotely via SQL Management Studio Express tool, there are few things you need to check: 1. Please make sure you use the correct SQL Server details. Since this is a remote SQL connection, it is recommended that you use the IP Address directly 2. Please make sure you specify the correct SQL Server Port. Just for your information, our SQL port is:
You can also find this details on your Control Panel -> Domain -> Database
3. If you have made sure point 1 and point 2 above are met and still, you cannot login, please kindly check whether your local PC or firewall blocks the SQL port. To check, please just TELNET our_server_IP_address port_number. For example: TELNET 174.37.255.232 777 (to check for SQL 2008 port). If you see an error message, this means that something is blocking port 777 and you need to unblock it. Please contact your local Network Administrator for more information 4. If all points above are met and you still cannot connect, please observe the error message. If you see an error message: "Login failed for user xxxxx", this means that your SQL Server user password is incorrrect OR your SQL user password is shorter than 6 characters OR longer than 14 characters. Please kindly reset the SQL password via our Control Panel. For the details to connect remotely, please check the article here. |
Attachments
![]()
There are no attachments for this article.
|
Do you support MS SQL Profiler?
Viewed 3233 times since Wed, May 23, 2012
Do you support MySQL WebAdmin Access?
Viewed 3180 times since Tue, May 1, 2012
Do you support SQL Server Integration Service?
Viewed 2862 times since Tue, May 1, 2012
How to Restore MSSQL Database by using "Import Dump"?
Viewed 302 times since Sun, Mar 9, 2025
How To Solve Problem with Connection String on EF (Entity Framework) 4 or above
Viewed 31769 times since Mon, Apr 1, 2013
Do you support SQL 2014?
Viewed 3370 times since Tue, Feb 3, 2015
How to Backup MSSQL Database by using "Export Dump"?
Viewed 228 times since Sun, Mar 9, 2025
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 4038 times since Mon, Apr 30, 2012
How can I access my nightly database backup?
Viewed 2781 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 4263 times since Thu, May 3, 2012
|