Solved

Troubleshooting freetds sql server connections

Posted on 2004-10-12
5
373 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:paranoid_droid
  • 3
  • 2
5 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
Comment Utility
>>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
 

Author Comment

by:paranoid_droid
Comment Utility
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
Grade C ???
0
 

Author Comment

by:paranoid_droid
Comment Utility
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
No problem. Just to understand.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now