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
account ?

<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: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Trusted connection
    ... Can I log on to SQL Server 2000 being loged on to a computer (local ... user account) which is added to a domain? ... local Administrators group but the ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)