[freetds] connection to SQL server 2008 express

Mahendra T mahendra.t at tcs.com
Wed Feb 24 06:12:29 EST 2010


> If you can telnet locally but not from the FreeTDS host, show those
> results to your network guy.

> Besides the *machine* being given network access over the port, the
> SQL*Server must also be enabled to allow external connections.

> Using SQL*Server management studio, right-click on the database cylinder
> after establishing a connection to it and choose "Properties".
> Then, choose the page "Connections" and click the check box "Allow
> remote connections to this server"

> Restart the SQL*Server service.

Hi, 
I was able to figure out the problem.
Dynamic ports were enabled in the SQL server configuration, It started 
working after I disabled them and mentioned 1433 as TCP/IP port.
Thanks for the suggestions !!

Mahendra
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you





More information about the FreeTDS mailing list