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