Dear folks, I have hosted my asp.net site in a web server. which has sql server 2008, and 2012 has installed. I want to connect with sql server 2008 with my local SSMS tool. Its connecting fine from other ISP's connection. but it's not connecting from the internet connection in my office. in my office i am using ADSL connection. I have issue the ticket for the server provider, they told me that they are disabled the firewall for my issue. its not working yet.. I will very thankful if any one help me to solve the issue.
You can test if the default sql port 1433 and our alternative sql port 14330 were indeed unblocked in your firewall by running the following test in your command prompt: telnet s05.Winhost.com 1433 telnet s05.Winhost.com 14330 In case port 1433 is blocked, you can connect to your sql server with alternative port 14330 by typing the following in server name field in ssms: s05.Winhost.com,14330 Please make sure you are connecting to your sql server as s05 above is just an example.
