I have my website on HostGator and also the dedicated server of my own running SQL Server 2008R2. The connection string I use is the X.X.X.X,1433 which directly points to the IP address of the dedicated server. I have already made the firewall settings on the server so that I can use the SSMS & log into SQL Server from the home PC.
Having followed that, I was thinking that connecting to the SQL from my hostGator hosted-site should work. But I am facing the below error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - An attempt was made to access a socket in a way forbidden by its access permissions.)
I have just looked up this error and found a lot of explanations, but none of them are dealing with my circumstances. So the server is running on Windows 2008 w/IIS 7.5. And I was assured by the HostGator tech support team that there would be no problems from their end.
Is there anybody who can fix this issue for me?