other computer can't connect to my sql server 2000

some of my colleagues need to connect to my database to retrieve some report
s
but they can't connect to my computer. i didn't set any specific passwords a
s
i'm using my window account ( username - Administrator , password - ** )
during the nistallation but the system always show "Connection to Database
Server Fail! Login Failed For User 'sa'" error message whenever they try to
connect to my database. Although i changed the user id in the .ini file to
Administrator also the same. Surely i did wrong somewhere. Please help guys.
Thanks a lot.What version of SQL Server?
Is SQL Authentication enabled?
Why are others attempting to connect using the 'sa' account? (Very BAD
idea!)
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
"Andres" <Andres@.discussions.microsoft.com> wrote in message
news:2090B026-13E1-43E8-BB84-FF34D1AB8840@.microsoft.com...
> some of my colleagues need to connect to my database to retrieve some
> reports
> but they can't connect to my computer. i didn't set any specific passwords
> as
> i'm using my window account ( username - Administrator , password - ** )
> during the nistallation but the system always show "Connection to Database
> Server Fail! Login Failed For User 'sa'" error message whenever they try
> to
> connect to my database. Although i changed the user id in the .ini file to
> Administrator also the same. Surely i did wrong somewhere. Please help
> guys.
> Thanks a lot.

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
>