Solved

Troubleshooting freetds sql server connections

Posted on 2004-10-12
5
413 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 143

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 143

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 143

Expert Comment

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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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…

839 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