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

14 Mar

Hello,

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

PROBLEM:

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.

SOLUTION:

The solution to the problem is to give the user account of the SQL Server Agent modify permissions to the directory:
<SQL SERVER DIRECTORY>\<MSSQL SID>\MSSQL\JOBS

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


Enjoy,
Roni Vered Adar.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: