[freetds] freeTDS to access sqlserverExpress
James K. Lowden
jklowden at freetds.org
Mon Mar 16 20:10:34 EDT 2009
Duncan Kerr wrote:
> It still fails. However, I have realised a couple of points
> 1) The documentation says that sqlServer doesn't allow remote
> connections by default - this may be stopping me from connecting
That is the most likely problem.
See if you can telnet to the port. If telnet won't connect, nothing will.
If you're not sure of the port number (or if you want to double-check)
tsql from a recent snapshot supports -L to list the server's instance
information. (It's totally a hack right now; I'm working on documentation
and a nicer interface.)
More information about the FreeTDS