• Register
0 votes

Problem :

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?

7.5k points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

If you really want to access SQL server on your hostgator remotely using SSMS then you must white list your IP in hostgator. Usually it will take around one hour to open the port for the whitelisted IP.

And after that your problem will be resolved.

38.6k points

Related questions

0 votes
1 answer 18 views
Problem: an attempt was made to access a socket in a way forbidden.
asked Feb 22 Dan phillip 4.8k points
0 votes
1 answer 14 views
Problem: Is anyone available to assist me and resolve this issue? An attempt was made to access a socket
asked May 10 Ifra 43.4k points
1 vote
2 answers 489 views
What is the meaning of the "connection reset by peer" error on a TCP connection? Why do we get the error "Connection reset by peer" during a web service call? Explaining Connection Reset by Peer Log Messages? Is it a fatal error or just a notification or related ... it mean when it says the connection was reset? How do I fix my connection reset? What does Connection reset by peer mean on Instagram
asked Jul 23, 2019 sadmin 2.3k points
0 votes
1 answer 1 view
1 view
Problem Only one usage of each socket address?
asked 3 days ago Nahil 122k points
0 votes
1 answer 10 views
Problem: So, what precisely is the problem here : Only one usage of each socket address is normally permitted?
asked Jun 23 Nahil 122k points
0 votes
1 answer 329 views
Problem : I am searching the working solution for following C# issue. only one usage of each socket address (protocol/network address/port) is normally permitted.
asked Nov 16, 2019 peterlaw 6.9k points
0 votes
1 answer 1 view
1 view
Problem: Tcp client server program in c linux?
asked 2 hours ago Mezbah 125k points
0 votes
1 answer 8 views
Problem: Tcp/ip and udp break large files into what?
asked Jul 13 Sawyer Parviz 166k points
0 votes
1 answer 7 views
Problem: I'm trying to figure out a solution, need help : Createboundsocket: ::bind returned error [no name available](10049).
asked Jun 19 Florina Gulnar 103k points
0 votes
1 answer 13 views
Problem: It’s a serious problem for me, can anyone help : How to create a chat application in java?
asked Jun 5 Sawyer Parviz 166k points