Solved

Troubleshooting freetds sql server connections

Posted on 2004-10-12
5
426 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
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…

632 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