• 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?

6 5 3
7,540 points

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.

9 7 4
38,600 points

Related questions

1 vote
2 answers 349 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.1k points
0 votes
1 answer 144 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 15 views
Problem: I have fundamental knowledge on .Net. Currently I am trying to call the functions from the 32-bit unmanaged DLL on my 64-bit system. But I am facing below unexpected error: "BadImageFormatException: An attempt was made to load a program with an incorrect format. ( ... the dependency but I checked and I found that they are all there. What else can be done to fix above .Net related error?
asked Jul 21 Raphael Pacheco 4.9k points
0 votes
1 answer 55 views
Problem: I am seeing "{writer,send_failed,{error,closed}}" error on server side and "java.net.SocketException: Connection reset by peer: socket write error" error on java client side intermittently. What could possibly go wrong here? Both server and ... rabbitmq.client.impl.ChannelN.basicPublish(ChannelN.java:630) at com.rabbitmq.client.impl.ChannelN.basicPublish(ChannelN.java:621) Please help me.
asked Mar 23 LizzyM 6.1k points
0 votes
1 answer 191 views
Problem : I am trying to implement an HTTP Server using Sockets but getting bellow error java net socketexception connection reset by peer socket write error
asked Oct 31, 2019 peterlaw 6.9k points