Troubleshooting freetds sql server connections

Hello Experts,
I have banging my head against a wall trying to get freetds to connect to mssql.
I can connect to the sql server from my home machine with query analyser using sql server authentication on the remote server.
Does SQL server need to be configured specifically for freetds?
Do I have to restart any server on the linux box after altering freetds.conf?
My freetds.conf has this in it;
# A typical Microsoft SQL Server 2000 configuration
[MyServer2k]
        host = mail.somedomain.net.au
        port = 1433
        tds version = 8.0

Testing the connection;
[root@Linux etc]# tsql -H mail.somedomain.net.au -p 1433 -U XXXXXX -P xxxxxxxx
locale is "en_AU.UTF-8"
locale charset is "UTF-8"
src/tds/login.c: tds_connect: XXX.XX.XX.XX:1433: Connection timed out
Msg 20009, Level 9, State 0, Server OpenClient, Line 0
Server is unavailable or does not exist.
There was a problem connecting to the server


There is heaps of doc on the net on what to do next after you have connected successfully but nothing outlining what to do if it fails.
Any help would be much appreciated,

Terry
paranoid_droidAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>>src/tds/login.c: tds_connect: XXX.XX.XX.XX:1433: Connection timed out

can you ping the server?
can you telnet the server (on port 1433)?
Is there a firewall blocking port 1433 between the 2 machines?

0
 
paranoid_droidAuthor Commented:
thankyou angelIII,
I made a stupid assumption that because I could ping, telnet and connect from home that the two machines on the same switch wouldnt have these problems.... but telnet fails from the linux box so I'm now checking out the local firewall on the linix machine.

I'll let you know,
Terry
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Grade C ???
0
 
paranoid_droidAuthor Commented:
Sorry AngelIII,
I sort of browsed over the grading section without thinking... I thought I was to grade the question/answer overall as a usefull resource.  Your answer was correct and put me right on track and itself deserves an A.
Regards,
Terry
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
No problem. Just to understand.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.