Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Jobs with different owner..

Author  Topic  pvsaro Starting Member 1 Post Posted - 2006-03-16 : 23:14:28 Hi All, I have an situation like below.. I have "Server A" in this lot of batch files and text files are sitting. From "Server A" it calls the "DB Server" from the batch files or BCP or ISQL. For this purpose i have a created a Domain Account. This domain account has SA Privilege in the database server because it requires a xp_cmdsheel. When the batch file triggerd from "Server A" it calls the job this is working fine. But the problem is the Job again writing some text files and reading some text files which is sitting in the "Server A" server. My "DB Server" running with different Domain Account which is does not have privielge in the "Server A" to write or read any files. The Problem is when the job started it is using the "DB Server" Service account and tries to access the text file which is sitting in the "Server A" and get failed. I don't want to grant privilege in the "Server A" for my "DB Server" Service Account. I think you all understand my problem. Please let me know how to resolve this issue. Regards, Saro