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: 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.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: 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)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)