Re: connection to SQL server 2008 express

Mahendra T <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <OFD242DA6D.035AD26D-ON652576D4.003D4E31-652576D4.003D91C4@tcs.com>
> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.