Re: Login failed using domain account

anonymous_at_discussions.microsoft.com
Date: 06/30/04 

Date: Wed, 30 Jun 2004 06:40:24 -0700

Thanks for the reply.

It does work that way but when I am trying to use isql -U
domain\username and failed. The SQL security option is set
to Windows and SQL.

Error message said:

Msg 18456, Level 14, Stat 1:
Login failed for user 'domain\username".
DB-Library: Login incorrect

Steve

>-----Original Message-----
>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: 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)
  • 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: SQL job owner and right
    ... It is the wrong type of account. ... who can login with that account can manage those jobs. ... Windows group that both windows users belong to and have that own the ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Users
    ... To change sa login do I connect via an ODBC connection - and is an account with local admin on my machine would accomplish that change. ... What type of access would you allow network engineers to have in sql, the main functionality is a network back up they run and include SQL in that. ...
    (microsoft.public.sqlserver.server)
  • Re: Win98 user acct cant connect - admin acct can
    ... I have made sure that everybody can login from the ... >If the administrator is the Domain Administrator, ... >account used a password that had a letter in it that ... A standard domain user account gets the ...
    (microsoft.public.windows.server.networking)