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



.

Relevant Pages