RE: SQL Agent jobs not run by the domain account

anonymous_at_discussions.microsoft.com
Date: 11/19/04 

Date: Fri, 19 Nov 2004 11:19:39 -0800

Rand,
SQL services are starting on the local box by the same
domain account w/out any problem to be authenticated.
But can not be used to execute job from SQL Agent.
Thank you,
Leo
>-----Original Message-----
>The error indicates that the SQL Server startup account
does not have
>access the domain controller to verify that the user. If
you start SQL
>Server with a domain admin account, does the problem
still occur.
>
>Using sa eleminates the need to authentticate the user at
the DC.
>
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>
>.
>

Relevant Pages

  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" ...
    (comp.databases.oracle.server)
  • 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)