Re: Strange integrated authentication success

No xp's account is not a member of win2003's Administrator Group if I
understand your question properly.

Sure win2003's account of Administrator is a member of win2003's
Administrator Group or Builtin\Administrators.

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:ODJIW0eIHHA.4848@xxxxxxxxxxxxxxxxxxxxxxx
Han
Is it possible that xp's account you connect to is a member of
Administrator Group on win2003 ?

"Han" <hp4444@xxxxxxxxxxxxxxxx> wrote in message
news:eVU9zveIHHA.5104@xxxxxxxxxxxxxxxxxxxxxxx
Hello

I am experiencing strange success of authentication.

I have two boxes, one xp-pro and another windows 2003, both have SQL2005.

Two boxes have no relationships except that they are in same network.
Really nothing such as account and trusted relationship.

Expecting failure, I tried to connect from xp to win2003 with integrated
authentication(trusted_connection=yes).

Result is success. I checked profiler and found the account name is
recorded as Administrator.

What happened?

The two boxes have same passwords for Administrator and I logged on with
the same passwords. But I don't think same password can be a free
passport to the databases.

Do you have any idea?





.

Relevant Pages

  • RE: Windows Updates
    ... I am set up as a member of the administrator group on the ... account is a member of Domain Administrators. ... the local machine administrator account, ...
    (microsoft.public.windowsxp.security_admin)
  • Loss of Profile When Changing From Administrator to Power User Gro
    ... How do I get the administrator group removed from a user's account without ... The security settings for this user's folder give full ...
    (microsoft.public.windowsxp.security_admin)
  • SQL2008 BuiltinAdministrators and etc
    ... SQLService account used to setup the SQL2008, member of the local ... requires SQL, also member of the local administrator group. ...
    (microsoft.public.sqlserver.server)
  • Re: iis & basic authentication
    ... Make sure that you can interactively login to the machine with a regular ... any user not part of the administrator group. ... > access I cannot access it with a user account only an admin account has ...
    (microsoft.public.inetserver.iis.security)
  • Re: Fix: Error connecting to existing session
    ... > Was your other account a member of the administrator group? ... XP wanted me to create at least one Admin level account which I did, ... however make it a member of the Remote Desktop Users group. ... >>login session was created from the console or remotely, ...
    (microsoft.public.windowsxp.work_remotely)