Login Failed

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
"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
|||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...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k
Cheers,
James Goodman
"Murphy" <murphy@.murphy.com> wrote in message
news:evoz1NpLEHA.1388@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> "Murphy" <Murphy@.murphy.com> wrote in message
> news:u3stcLpLEHA.1052@.TK2MSFTNGP12.phx.gbl...
> try
I[vbcol=seagreen]
machine
> ?
> 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
>
|||There's no local firewall running etc and the machines are part of a domain.
Thanks
Murphy
"James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:uqnZ0cpLEHA.556@.tk2msftngp13.phx.gbl...
> 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...&Product=sql2k
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
>
>
> --
> Cheers,
> James Goodman
> "Murphy" <murphy@.murphy.com> wrote in message
> news:evoz1NpLEHA.1388@.TK2MSFTNGP09.phx.gbl...
can[vbcol=seagreen]
and[vbcol=seagreen]
to[vbcol=seagreen]
do[vbcol=seagreen]
> I
> machine
tried
> logged
>