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

I'm glad you were able to get it working. However, I'd be leery about
granting admin rights the proxy account since that allows non-sysadmins to
run processes with admin rights. Now that you got the service accounts
sorted out, I would expect your DTS package to run fine as long as the proxy
account has permissions on data and files accessed by the package.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Paul Coulson" <nospam@xxxxxxxxxx> wrote in message
news:eCdaOR4OGHA.812@xxxxxxxxxxxxxxxxxxxxxxx
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: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Does anyone know how to fix this??
    ... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)