Siusic Dot Com

I have several SQL server jobs that copy files around the network folders and all of them were failed one day. The error message showed in the job history was, “Unable to determine if the owner of job has server access (could not obtain information about windows NT group/user”. The job step that failed was to copy a file from a network share folder to the local drive.

The owner of the job was me at the time. So the first thing I thought was that my account was having issues accessing the network folder. I try open the share folder from my own development machine. It was fine. Then I terminal service to the SQL box and then open up the network share folder and it was fine too. So the message was some what misleading because it said, “unable to determine if the owner of job has server access”, and the job owner was me.

In fact my account belongs to the sysadmin role and because of that SQL server 2000 runs the job steps under the account used by the SQLAgent service. That was the behavior of SQL 2000. SQL 2005 let you specify a user to run each job step if you are sysadmin. So It could be a problem of the SQLAgent service account. I try terminal service to the SQL box using the sql agent service account and open the network folder. This time I couldn’t open it. Cause of the problem was found. After the access problem fixed by network admin all the job were running smooth again.

Related Posts:

Trouble Shooting SQL Server Connection Problems, Tricks and Solutions

SQL Server Backup Device Error or Device off-line

List All Permissions a User Has in SQL Server Database and Error 4064

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

The Best Way to Backup SQL Server