Tag Archives: SQL Agent

Running a SSIS package via SQL Agent job with a Proxy User

23 Sep

I recently needed to create a SQL Agent job that runs a SSIS package on SQL Server 2012.

I followed the steps that are detailed in the below link, to be able to run a SSIS Package from SQL Server Agent Using a Proxy Account:

However, once I finished the steps and tried running the job, it kept failing with the error:

Unable to start execution of step 1 (reason: Error authenticating proxy *****\******, system error: Logon failure: unknown user name or bad password.).  The step failed.

I was sure that password of the Proxy Account was correct, and I was quite puzzled with the issue.
I even tried changing the Proxy Account to another sysadmin account but no change.


Check the SQL Server Agent service account in SQL Server Configuration Manager. Make sure the service account is configured with the format of DomainName\UserName and not in the format of UserName@DomainName.com.

Once I change the Service account configuration, the job ran with no issues.


Errors in SQLAGENT.OUT log – Unable to open or read TSX cache file

14 Mar


I’ve recently implemented a MSX/TSX jobs environment in my organization.

I’ll blog about it at a different time.

Source: Microsoft.com

Source: Microsoft.com


Everything seams to work fine with no issues, except for a strange error message in the SQLAGENT.OUT log:

[419] Unable to open or read TSX cache file ‘E:\MSSQL10.DB\MSSQL\JOBS\TSXCACHE.BIN’ (win32 error code: 2)

Despite the error above, there’s no issues with the implementation – all jobs are working as expectantly.


The solution to the problem is to give the user account of the SQL Server Agent modify permissions to the directory:

After giving the permissions, you’ll see immediately that a new file called TSXCACHE.BIN will be created in the directory.

Roni Vered Adar.