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

Hi Dan,

Thanks that's sorted it. Also got it working using the proxy account
again this needed local admin rights.

Cheers Paul




"Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ueU6PriOGHA.1192@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)
  • 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: Get "credentials not valid" message installing SQL2008 Failver
    ... The user account (domain account) has to be pre-created. ... The network name gets created during the install process. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Domain Admin
    ... the account you are using to look at it ... > Make sure you have logged in to each node using the install and service ... > I support the Professional Association for SQL Server ... The login being used to install SQL Server is a local admin ...
    (microsoft.public.sqlserver.clustering)
  • SQL services failing on startup
    ... The services are set to autostart using a windows account. ... The account is restricted to logon only to computers ... for several months, the last two weekends, SQL Server has failed to startup ... The domain account was a member of the local admin group. ...
    (microsoft.public.sqlserver.server)