Hello, I've got a question about the SQL server agent account. Currently I'm having an issue running a job as 'myself'. I need to run the job as domain\my account due to the fact that my account has security access to a folder on a different machine. The SQL agent is running as a different account. When I try and change the owner of the job to my account I get the following error: The job failed. Unable to determine if the owner (domain\user) of job waiver_export has server access (reason: Could not obtain information about Windows NT group/user 'domain\user', error code 0x5. [SQLSTATE 42000] (Error 15404)). Is there any other fix for this issue other than going into services for Sql Server Agent (MSSQLServer) and changing to run using my account? Thanks, Phil

Use Proxies (orCredentials) used to run a specific job step in the required security context. Check this one.http://bi-polar23.blogspot.com/2007/12/ssis-and-sql-server-agent.html

I just switched, on my dev server, the log on account to use my name instead of our system account and re-ran my job and it worked, finally. My question is how I create a proxy. The first step is to create a credential, no? Looking at the Credential creation screen in Management Studio. I have an Identity, password, and confirm password. The identity is supposed to be my domain\username? Ok after I create a credential I go to proxy, right click, new proxy and then it asks for a proxy name, credential name, and a checkbox of what subsystems to have active, right? Ok, so I did these steps and I named my proxy SSIS_proxy and I gave it access to all subsystems and assigned my domain\username as the credential. Then I went to the job and assigned the job owner to the proxy SSIS_proxy. When I click ok.. I get an error: TITLE: Microsoft SQL Server Management Studio------------------------------ Alter failed for Job 'waiver_export'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Job&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. UPDATE fails.The statement has been terminated. (Microsoft SQL Server, Error: 515) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476 ------------------------------BUTTONS: OK------------------------------ Please help, Phil

Proxy should be specified for Job step properties in "run as" combo box. Job owner will be your login or any validuser onyour sql server. When job runs it will use credentials of the specified proxy for given job step.

Ok, thanks for that. I tried it and I still got the same error: Let's take a step back to the credential. What's a good example of a credential? I'm just putting my domain\username in w/ my domain password. Is that ok? Then when I created the proxy I used that credential and gave it access to run all subsystems. Is this the way it's supposed to be created? I just need a proxy to be able to access a folder on another network computer. Thanks again, Phil

Not the job owner, the job step "Run As" just leave the job owner alone.

You are the man. It worked. Thanks, Phil

It is a little bit hard to find, but the best documentation how to setup SQL Server Job Agent proxy account can be found here: http://support.microsoft.com/kb/912911

It is a little bit hard to find, but the best documentation how to setup SQL Server Job Agent proxy account can be found here: http://support.microsoft.com/kb/912911

I'm having the same problem. Philippe, can you describe how you get a domain user account in the dropdown box? Drop down found in: Jobs Properties > Steps > Edit > General > Run as: It says "SQL Agent Service Account" now. But I would like a domain user accont instead. Does anyone know?

I'm having the same problem. Philippe, can you describe how you get a domain user account in the dropdown box? Drop down found in: Jobs Properties > Steps > Edit > General > Run as: It says "SQL Agent Service Account" now. But I would like a domain user accont instead. Does anyone know? Follow the link I have posted above and review how to setup and use proxy account.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/