June 24, 2008 at 5:51 pm
I have a mandate to use a windows domain account against a server in another domain from ours. I don't have sysadmin on the remote domain server. That account is set up as trusted with our domain.It is also given "log on as batch permissions" in the IPsec rules, admin on the server and sysadmin in our sql server. I created a BI ssis package using "run as" remote domain\account to fire up visual studio.I can create my windows connection manager doing that just fine.I created a credential for that remote domain account on my server and a proxy using that credential.
When I run the package in visual studio, it runs fine. When I try to schedule it it gives the error below. I set up the schedule with the call to the package as a step, using runas the proxy account instead of the sql agent account.
Message
The job failed. Unable to determine if the owner (domain\account) of job QtrScheduleRun has server access (reason: Could not obtain information about Windows NT group/user 'domain\account', error code 0x5. [SQLSTATE 42000] (Error 15404)).
Can anyone help with this? I have been searching the web and have not found anything that works so far.
thanks in advance.
August 22, 2011 at 2:22 pm
When you go into the job properties screen of the SQL SERVER AGENT, change the group/owner of the job to one that exists. SQL Server can't see that group/owner id and so it wont run it.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply