Re: Strange integrated authentication success

Additionally from my xp's management studio I can't see the win2003 server
on my object explorer / network servers.

"Han" <hp4444@xxxxxxxxxxxxxxxx> wrote in message
news:OSDVVcfIHHA.3268@xxxxxxxxxxxxxxxxxxxxxxx
No, I am using script, connecting from xp to win2003. Something like,

set con=createobject("adodb.connection")
con3="provider=SQLOLEDB; server=w3; Database=air; trusted_connection=yes;"

con.open con3
msgbox con.state

That's all. Result is success or 1. I think it should fail.

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:Of0BMPfIHHA.1008@xxxxxxxxxxxxxxxxxxxxxxx
Han
You said that you log in xp server as administrator and open query
analyzer can connect to win2003 serer by using a xp login?



"Han" <hp4444@xxxxxxxxxxxxxxxx> wrote in message
news:e$fOgFfIHHA.3668@xxxxxxxxxxxxxxxxxxxxxxx
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: FIRED IT ADMIN HAS LOCKED US OUT OF SBS
    ... you have risen to an Administrator this would be a given. ... server and run all LOB apps on these. ... If there are no encrypted files, just reset the DSRM account ...
    (microsoft.public.windows.server.sbs)
  • Re: FIRED IT ADMIN HAS LOCKED US OUT OF SBS
    ... Teneo> Interesting post and Im now gonna be a party pooper... ... connections) before cutting power to the server and to the Internet ... If there are no encrypted files, just reset the DSRM account ... and try old domain Administrator account's passwords. ...
    (microsoft.public.windows.server.sbs)
  • Re: Remote desktop: cannot copy files why still not working
    ... I created a new user on the XP box, set as an administrator ... this new user account is local to the XP system, ... In my environment, when I do an RDP connection to a server, I first log ... member of the local administrators group on the server. ...
    (microsoft.public.windows.server.security)
  • Re: Remote desktop: cannot copy files why still not working
    ... this new user account is local to the XP system, and a member of the local administrator's group on that workstation. ... In my environment, when I do an RDP connection to a server, I first log on to the xp workstation using my regular, non-privileged domain account, run mstsc, and then logon to the server using a domain account that is a member of the local administrators group on the server. ... In addition, I frequently use runas to run privileged applications on the workstation using my "administrator" account, and have found that files cannot be copied between those applications and anything running under the credentials of my regular account - even though my administrator account actually does have full access to everything on the workstation - just not through my regular account's view of that workstation. ...
    (microsoft.public.windows.server.security)
  • Re: Shared Fax device not available anymore after reboot server!?!
    ... the error message one by one to the Newsgroup for accurate research. ... You can send fax by using Administrator account. ... after the reboot of the server no account is able to fax anaymore. ...
    (microsoft.public.windows.server.sbs)