[Sgt.TheDarkness]

If you are hosting the server on the same box that is hosting the SQL server, you can set the hostname to "localhost"

Sometimes I have to set it as localhost because it just wouldn't connect by typing in the IP address.

But if that isn't the case here, I would suggest contacting your host for further help on the issue