Solved

Troubleshooting freetds sql server connections

Posted on 2004-10-12
5
389 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
ID: 12296630
>>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
ID: 12300011
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]
ID: 12309249
Grade C ???
0
 

Author Comment

by:paranoid_droid
ID: 12314000
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]
ID: 12316444
No problem. Just to understand.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Creating and Managing Databases with phpMyAdmin in cPanel.
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…

867 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

15 Experts available now in Live!

Get 1:1 Help Now