• 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

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.

9 7 4
38,600 points

Related questions

0 votes
1 answer 5 views
Problem: an attempt was made to access a socket in a way forbidden.
asked Feb 22 Dan phillip 2.4k points
1 vote
2 answers 405 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.2k points
0 votes
1 answer 225 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 11 views
Problem A blocking operation was interrupted by a call to wsacancelblockingcall
asked Feb 9 charles mathews 3.9k points
0 votes
1 answer 16 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, 2020 Raphael Pacheco 4.9k points
0 votes
1 answer 89 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, 2020 LizzyM 6.1k points
0 votes
1 answer 249 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
0 votes
1 answer 11 views
Problem: if you assign an alias to one table in a join, you have to
asked Feb 18 charles mathews 3.9k points
0 votes
1 answer 33 views
I have this simple python server-client file transfer project going on. There are two parts to each side. First, the client sends a file to server for the first part. Server then appends a line and sends back the file to client in the second part. My issue is that for some ... fw: while True: data = csFT.recv(1024) if not data: break fw.write(data) fw.close() print("Received..") csFT.close()
asked Oct 27, 2020 psandprop 2.4k points
0 votes
1 answer 204 views
Problem: I am very new to .Net programming. Recently I was trying to run the .Net socket server code on my Win7-64bit machine. But I am receiving the below error: System.Net.Sockets.SocketException: An address incompatible with the requested protocol was used. Error Code: 10047 ... -XP sp3 . I have already checked the error code details on MSDN but it does not make any sense to a beginner like me.
asked Aug 22, 2020 Raphael Pacheco 4.9k points