"Michael Zander" <michael.zander@uniplex.de> wrote in message
news:ufw$sTp9GHA.1172@TK2MSFTNGP03.phx.gbl...
> Hi guys,
>
> i can't connect to my sqlserver 2000 with isql :
> isql -Slocalhost -U<username> -P<password>
> The sqlserver (no name, displays (LOCAL)) is running on the local box, i
> can
> connect with EnterpriseManager and QueryAnalyzer. Everything seems ok, but
> isql cannot connect (error message is something like "SQL Server not
> found,
> or Networkaccess denied; Net-Library error 53: ConnectionOpen
> (Connect()").
> If i look with netstat -a i can see the listeners. Also there is no
> error-message in the windows-event-history.
> I tried to connect to localhost, local, hostname, 127.0.0.1. But nothing
> works.
> Does anyone no what the reason can be ?
>
> Thanks a lot,
> Michael
>
>

"Arnie Rowland" <arnie@1568.com> wrote in message
news:e8VAq8r9GHA.1256@TK2MSFTNGP04.phx.gbl...
> If the server does NOT have SQL Server Authentication enabled, you will
have
> to use -E instead of -U<username> -P<password>.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> You can't help someone get up a hill without getting a little closer to
the
> top yourself.
> - H. Norman Schwarzkopf
>
>
> "Michael Zander" <michael.zander@uniplex.de> wrote in message
> news:ufw$sTp9GHA.1172@TK2MSFTNGP03.phx.gbl...
> > Hi guys,
> >
> > i can't connect to my sqlserver 2000 with isql :
> > isql -Slocalhost -U<username> -P<password>
> > The sqlserver (no name, displays (LOCAL)) is running on the local box, i
> > can
> > connect with EnterpriseManager and QueryAnalyzer. Everything seems ok,
but
> > isql cannot connect (error message is something like "SQL Server not
> > found,
> > or Networkaccess denied; Net-Library error 53: ConnectionOpen
> > (Connect()").
> > If i look with netstat -a i can see the listeners. Also there is no
> > error-message in the windows-event-history.
> > I tried to connect to localhost, local, hostname, 127.0.0.1. But nothing
> > works.
> > Does anyone no what the reason can be ?
> >
> > Thanks a lot,
> > Michael
> >
> >
>
>