Re: Login failed using domain account

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 09:41:48 +0530

Hi,

FOR Trusted (Domain user login) login, In the local machine first you have
to login to the Operating system using the
same Domain user. After that open query analyzer and select "Windows
Authentication" and click OK.

If you are following the above and getting error, then post the error
message. 

--
Thanks
Hari
MCDBA
<anonymous@discussions.microsoft.com> wrote in message
news:22e6d01c45de3$7803f0a0$a401280a@phx.gbl...
>
> All,
>
> I could login sql server using SQL login account but could
> not login using domain account that is also created in SQL.
>
> I could run the Query Analyzer using the same domain
> account on the server.
>
> SQL 2k on windows 2k dc
>
> Any ideas,
>
> Steve

Relevant Pages

  • Re: SQL 2k5 SP2 Mirroring - SQL in Mixed mode.
    ... US\sqlservices (old SQLservice account) still member of built-in local admin ... Login: US\sqlservices ... How can I transfer the SQL logins to ... Here is SP_help_revlogin results from the Principal Server (NYSQL-3) ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Connection with .udl and domain accounts
    ... work because it's not recognised by SQL-Server as a valid User Id. ... difference between a SQL account and a domain account. ... Login account using a SQL Login name and password that will ...
    (microsoft.public.sqlserver.connect)
  • Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... If a SQL account is used then the only thing needed on the ... machine running SQL is SQL login and database grants. ... If integrated, then in addition, I have seen the account need ... then changing this to use trusted connection ...
    (microsoft.public.windows.server.security)
  • Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... If a SQL account is used then the only thing needed on the ... machine running SQL is SQL login and database grants. ... If integrated, then in addition, I have seen the account need ... then changing this to use trusted connection ...
    (microsoft.public.win32.programmer.wmi)