Trusted connection

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: User account for only SQL server
    ... But now he insisted to have Admininstrators Account so that he can log on to ... I did try adding his user account that includes Administrators permission to ... Add the new account to the local Administrators group on the SQL server ...
    (microsoft.public.windows.server.active_directory)
  • Re: Trusted connection
    ... is username/password the same for the local and domain account. ... did you map or open any shares/RPC to the sql server by using the domain ... > local Administrators group but the ... > SQL Server using trusted connection but it shows as I am logged as ...
    (microsoft.public.sqlserver.security)
  • Re: DBA Permissions
    ... I don't have a windows account, ... account with sysadmin priviledges.. ... >Columnist, SQL Server Professional ... >which is in the local administrators group and I am able ...
    (microsoft.public.sqlserver.security)
  • Re: Securing SQL Server after administration installation
    ... You don't always have to have the account in the local ... admins group and more people are moving away from adding the ... Change the SQL Server or SQL Server Agent Service ... >service user to the administrators group to get things running ...
    (microsoft.public.sqlserver.security)
  • Re: Kerberos from XP to IIS hosting ASP.NET 2.0 Web Service help
    ... What user account is the web application pool running under? ... What SPNs do you have registered for the *SQL Server*? ... The client is an XP machine. ...
    (microsoft.public.inetserver.iis.security)