Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rontornambe
Starting Member
1 Post |
Posted - 2011-03-09 : 23:48:27
|
I am running SQL Express 2008 R2 on a godaddy.com dedicated server. I have setup the instance to enable both Windows and SQL Server logins, have ensured that Allow Remote Connections is checked, have enabled TCP (SQL Configuration Manager) and set the port to 1433 for the domain IP and disabled all IPs except the loop-back (127.0.0.1) and removed dynamic port assignments for all other IPs. I also disabled the Windows Firewall.I can login to the SQL User on the server (using remote desktop connection) and strangely I can use a .NET application to connect. But Mgmt Studio 2008 R2 issues "server not found or not accessible (Error 53) I am stumped - this worked earlier in the week even with the firewall enabled. Any ideas are appreciated. |
|
|
|
|