Re: Trusted connection

Hi
If you ( a computer name ) is a member of domain admin so you probably is
loged on as DOMAIN\YourComputerName
and of cause it is a member of the Local Admistrators group

When you log in "localy" as you siad you should be a member of Local
Admistrators group or any group that has an access to SQL Server




<maciek@xxxxxxxxxxxxxxxx> wrote in message
news:1135248664.368196.289790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> Can I log on to SQL Server 2000 being loged on to a computer (local
> user account) which is added to a domain? Here is the issue:
>
> I am logged on to my Win XP using local account which is a member of
> local Administrators group (I am NOT logged on to a domain) but the
> same login exists in Active Directory and is a member of Administrators
> and Domain Administrators group. I somehow managed to login in QA to
> SQL Server using trusted connection but it shows as I am logged as
> domain administrator, but i do not remember how I did it. I need
> another user being loged on to local WinXP account to use trusted
> connection to SQL Server. I do not know if I am making myself clear but
> if you have any ideas, i'd appreciate.
>
> TIA
> Maciek Szymanski
>


.

Relevant Pages

  • Re: Windows Service - Event Log
    ... I didn't say the Administrator account. ... Administrators group on the local machine." ... I didn't advocate using a member of the Administrator's group; ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Membership...
    ... Administrators group in some computers contrain members with deleted domain ... account such as this: ... >> REMOTELY using vb script. ... >> following script can remove the member of the Administrators group if the ...
    (microsoft.public.scripting.vbscript)
  • Re: cannot add local user to local group
    ... You can control the Local Administrators group with the Restricted Groups Policy. ... This posting is provided "AS IS" with no warranties, and confers no rights. ... One local user account "test" and one domain user ... "Member of" tab is empty. ...
    (microsoft.public.win2000.active_directory)
  • Re: Domain Lockout
    ... > No regular user who is not a member of the local administrators group ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Problems running SQL Services under a not privileged user account
    ... SQL Server Agent should be running under Domain account (which is a member ... of Local Admin Group on SQL Server machine) ... > I created a local user account, member of the USER group and setup the SQL ...
    (microsoft.public.sqlserver.security)