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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Cannot connect remotely

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.
   

- Advertisement -