Re: Login Failed

From: James (jamesATnorton-associates.co.ukREMOVE)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 10:40:39 +0100

Is there anything which could be blocking the connection?

Are the machines part of a workgroup or domain?

Some Links:
http://support.microsoft.com/default.aspx?scid=kb;en-us;822502&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql2k 

-- 
Cheers,
James Goodman
"Murphy" <murphy@murphy.com> wrote in message
news:evoz1NpLEHA.1388@TK2MSFTNGP09.phx.gbl...
>
> "Murphy" <Murphy@murphy.com> wrote in message
> news:u3stcLpLEHA.1052@TK2MSFTNGP12.phx.gbl...
> > I have installed MSDE on a w/s and when logged in as administrator I can
> > access the server using OSQL -E however if I am logged in as a user and
> try
> > to access the server I am denied access.
> >
> > I have the SQL tools installed on a different machine and would like to
> > access this server using EM across the LAN, on the machine running EM do
I
> > need to login as administrator in order to connect the MSDE server
machine
> ?
> >
> > Thanks
> >
> > Murphy
> >
> >
>
> I have just logged in ad administrator on the machine running EM and tried
> to connect to the MSDE server using:
> C:\>osql -S MachineA -E
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> C:\>
>
> This command works perfectly when run on the machine runnng MSDE when
logged
> in as adminsitrator...
>
> What am I missing ?
>
> Thanks
>
> Murphy
>
>

Relevant Pages