SQL Connection Error

[swayda]

I have a user at work who is trying to connect with an SQL server outside the orgasnization. Everytime I try to connect I get the following error messages.
SQL State '01000'
SQL Server Error 10060
[Microsoft etc etc]
Connectin failed
SQL State '08001'
SQL Server Error 17
SQL Server does not exist or access denied.

I have absolutely no experience with this but it appears that no one here does either.
She can reach the web site with her browser, but is going through a proxy. We are using a non-routable ip address.
Can anyone help with this?

Don Swayser
swayser@optonline.net

 

[cutiger93]

Don,
Try the following:
1. Make sure that you can ping the server from your machine.
2. Try to connect to the server by using the IP address instead of the Name
3. Go to Client Network Utitily and then to the Alias in SQL 2000, general tab in 7.0 and make sure that you have tcp/ip as your connection with your server name as the server alias and your connection parameters set up as your ip address to the server.


Hope this helps.

 

[swayda]

Hi Cutiger. Thanks for the rapid response but I have done all these things. Yes I can ping the site. I am connecting to the address and I have used the client setup to use TCP. Sorry I forgot to mention all that. I have also spoken to the DB Admin (thrice)and he hasn't the foggiest idea what's wrong. Don Swayser
swayser@optonline.net

 

[FilthPig]

If you're going through a firewall make sure that port 1433 is open. Maybe make sure it's open on their firewall if applicable also. Marc Creviere