Re: freeTDS to access sqlserverExpress

James

I finally got this to work. I had a number of config errors, and it was
a question of getting them all setup correctly at the same time -
obviously.  The issues are as  follows

1) I was trying to connect to 2 instances, one of sqlserverExpress, one
of sqlServer proper.  Using telnet I saw  that only the sqlServer proper
is listening on 1433

2) my .freetfs.conf wasn't correct, it only works with port and no
instance

3) My sqlserver login only works in format FUENV4\fuadmin

========================================================================
===
So my final working config, was to connect to sqlServer with
.freetds.conf

[mcdb]
    host = ntdevmog451
    tds version=8.0
    port=1433

with command (ie with escaped backslash on unix)

lxdevws85 apps% tsql -S mcdb -U FUENV4\\fuadmin -P ful1ffe -Lv
locale is "C"
locale charset is "ANSI_X3.4-1968"
1>                       


I don't understand why changing .freetds.conf to below should stop it
working, and the instance exists, and port 1433 is the default.

[mcdb]
    host = ntdevmog451
    tds version=8.0
    instance= ntdevmog451

Anyway, thanks for your help.  

Duncan Kerr
NYSE Technologies 
t +44 (0)20 7655 7214

> -----Original Message-----
> From: [email protected] [mailto:freetds-
> [email protected]] On Behalf Of James K. Lowden
> Sent: 17 March 2009 22:34
> To: FreeTDS Development Group
> Subject: Re: [freetds] freeTDS to access sqlserverExpress
> 
> Duncan Kerr wrote:
> > % telnet ntdevmog451 1433
> >
> > Trying 10.230.204.151...
> >
> > Connected to ntdevmog451.admin.liffe.com (10.230.204.151).
> >
> > Escape character is '^]'.
> >
> > ^]
> >
> > telnet> q
> >
> > Connection closed.
> 
> OK, this is good.  we know *something* is listening to 1433 on
ntdevmog451
> and we're willing to believe it's SQL Server.
> 
> > % tsql -S mcdb -U 'allzse' -P allzse -Lv
> > locale is "C"
> > locale charset is "ANSI_X3.4-1968"
> > 16connecting to instance ntdevmog451 on port 0
> > There was a problem connecting to the server
> 
> The problem here is your freetds.conf entry:
> 
> > [mcdb]
> >     host = ntdevmog451
> >     tds version=8.0
> >     instance=ntdevmog451
> >     port=1433
> 
> You don't need instance and port; choose one.   The instance is the
name
> of the port (basically), and in reading freetds.conf instance
supersedes
> port.
> 
> My guess is there's no *instance* named 'ntdevmog451'; the client
queries
> for it, the server says there is none, and the client tries to use
port 0.
>  If you comment out the instance name (or use the right one) I bet it
will
> work.
> 
> > % tsql -H ntdevmog451 -p 1433 -U allzse -P allzse -Lv
> > locale is "C"
> > locale charset is "ANSI_X3.4-1968"
> > Msg 20017, Level 9, State -1, Server OpenClient, Line -1
> > Unexpected EOF from the server
> 
> I suspect your tsql commands are failing because the compiled-in
default
> TDS version is 5.0.  "tsql -C" will confirm that.  If so:
> 
> $ TDSVER=8.0 tsql -H ntdevmog451 -p 1433 -U allzse -P allzse
> 
> should work and
> 
> $ TDSVER=8.0 tsql -H ntdevmog451 -p 1433 -U allzse -P allzse -L
> 
> (using a recent snapshot) will return a list of instance names and
their
> ports.
> 
> HTH.
> 
> --jkl
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds

-----------------------------------------------------------------------------------------------------------
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient or have received this e-mail in error, please advise the sender immediately by reply e-mail and delete this message and any attachments without retaining a copy. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.