osql login with an instance

Our software installs a copy of MSDE 2000 on the clients computer during
install. On several of the computers I can not log in to the server via
osql (or my software).
The problem seems to be referencing the instance. The instance is {computer
name}\RR, so for example the guy I currently have trouble with his computer
name is AUTOMGR so I should be able to log in with:
OSQL -S AUTOMGR\RR -E
but when I try it returns:
Login failed for user 'AUTOMGR\Greg'.
Same if I try -U sa -P XXXXXX instead of -E
Where Greg I think is his login name.
So it ignores my instance name and uses Greg, I have this happening with
several of my customers.
Does anyone have any ideas?
Thanks in advance,
Rob
That was the whole error, I copied and pasted the screen when it happened,
this is from that session:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Greg>hostname
AUTOMGR
C:\Documents and Settings\Greg>osql -S automgr\rr -E
Login failed for user 'AUTOMGR\Greg'.
C:\Documents and Settings\Greg>
RR should be our instance. The instance looks to be installed when I look
at the folders.
If this is not enough info, then I will need to wait until another user
reports it and I can investigate further.
If that is so, do you have an things you think I should look at?
e.g. How the registry looks, folder structure, is it in add and remove
programs, etc.
Thanks,
Rob
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4vvr0mF1e0dvpU1@.mid.individual.net...
> hi,
> Rob wrote:
> 'AUTOMGR\Greg' is not related to the istance (default or named) but
> actually is the WinNT login name..
> can you please provide the "full" exception message?
> thank you
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
|||I will check in to this. thanks for you help.
BTW- I really like your DbaMgr2K; thanks.
-Rob
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:50028gF1e4bv2U1@.mid.individual.net...
> hi,
> Rob wrote:
> ok... by default MSDE setup generates a group login for
> Bulitin\Administrators, so that all local WinNT login members of that
> group are allowed to connect to the installed instance.. but other kind of
> WinNT logins are not granted login permissions as well... is "Greg" member
> of that WinNT group?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>