View Single Post
  #10 (permalink)  
Old December 22nd, 2006, 04:14 PM
robprell robprell is offline
Friend of Wrox
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts

troubleshooting is best done a piece at a time. I suggest the following.

1) goto the actual sql server and connect using the userid/password that you plan to use.

2) on a different box (that does not go through a firewall) try to connect using the same userid/password.

3) On the box your trying to connect from ping the server.

4) on the box your trying to connect with use the MS-SQL tools and connect with the userid/password your using.

5) setup an odbc connection using the same userid/password.

Don't proceed to the next step until the previous results in a connection. You may have firewall issues, wrong userid/password, you can't ping the server, etc. Take it a step at a time to find the problem.

Reply With Quote