Login failed using domain account

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

Date: Tue, 29 Jun 2004 07:15:02 -0700

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 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.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)