Re: Error when trying to execute a job from windows service.

SQL Server 2000 SP4
Both SQLServer + SQLAgent run under a domain account (different to the
service)
ServiceUser has login to sql server not an admin, however I've tried using
the SQL Agent Proxy account still no success.

The SQL 2000 Books Online <instsql.chm::/in_overview_6k1f.htm> states that
the SQL Agent service account must be a member of the local Administrators
group in order to "Create CmdExec and ActiveScript jobs belonging to someone
other than a SQL Server administrator".

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Paul Coulson" <nospam@xxxxxxxxxx> wrote in message
news:OZUDQ3WOGHA.3144@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm trying to execute a DTS package from a .NET service. The service is
running under a domain account that owns the job which it executes using
'sp_start_job'. The call to the sp succeeds however checking the Job
history gives: -

"The job failed. Unable to determine if the owner (DOMAIN\ServiceUser) of
job <JobName> has server access (reason: Could not obtain information
about Windows NT group/user 'DOMAIN\ServiceUser'. [SQLSTATE 42000] (Error
8198))."

SQL Server 2000 SP4
Both SQLServer + SQLAgent run under a domain account (different to the
service)
ServiceUser has login to sql server not an admin, however I've tried using
the SQL Agent Proxy account still no success.

Any ideas?

thanks Paul




.

Relevant Pages

  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 login with Windows Authentication
    ... I obviously installed SQL Server using my Francois (admin) local user ... So having stated that I chose windows authentication as ... And the reason for this is that a Windows login also can have access ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE password change for "sa"
    ... I login to the machine as a local admin and connect via the ... > Upgrading to SQL Server isn't too bad. ... You will be asked if you want to upgrade ...
    (microsoft.public.sqlserver.server)
  • RE: Linked server issue
    ... SQL Server logins to the Admin account of the Access database. ... Add a new linked server using SQL Server Enterprise Manager. ... Remote login: Admin ...
    (microsoft.public.sqlserver.tools)
  • Re: Capture IP Address
    ... I have some MS Access front end databases linked to SQL Server 2000 ... logins for every user that requests access to the database and capture every ... The interesting part is that the Login Failed attempt ... any of our databases named 'Admin' especially to our Master. ...
    (microsoft.public.sqlserver.security)