Re: Change service account with SQL server 2000 sp4

your SQL Agent service is running under a local account ?

"Fredrik" <Fredrik@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4783465E-2B9B-4D6E-83F4-D4346BAC1D36@xxxxxxxxxxxxxxxx
I have secured our SQL 2000 server on a Windows 2003 server.

I deleted the builtin administrator as systemadminstrator.
Then changed to a new serviceaccount that is administrator on the machine.
It is a AD domain account.
I then changed all SQL jobs to the new account. Restarted the services.

After that I got the failure
"The job failed. Unable to determine if the owner (domain\username) of job
testjob has server access (reason: Could not obtain information about
Windows
NT group/user 'domain\username'. [SQLSTATE 42000] (Error 8198)). "

It is only the SQL jobs that fails.
any idea?
If I use a SQL admin account as sa the jobs works. But I want to have a
doaimn account for this.

We are running mixed mode and SP4 with latest hotfix.

Kind regards.





.

Relevant Pages

  • Re: Jobs Failed do not work when scheduled done via DTS Scheduled Package
    ... the SQL info out within the PATH. ... running one of the Jobs and it executed without a hitch. ... > What does the DTS package do? ... the account used is whatever account you ...
    (microsoft.public.sqlserver.server)
  • 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)