How to access network file using SQL Server 2000
-
Hi Everyone, I have a file named as "File1.txt" from "MachineA" that is under shared folder only. But my SQL SERVER 2000 is in "Machine B". I am doing sending from SQL Server 2k using Jmail. I want to access the network file "File1.txt" from "MachineA". If, I give machine name or ip. it doesn't take. simply it skips the attachment file and it sending only mail. If i stored the "File1.txt" in "MachineB" then its sending correct. Please give me some idea.....
Thanks & Regards Kumaran
-
Hi Everyone, I have a file named as "File1.txt" from "MachineA" that is under shared folder only. But my SQL SERVER 2000 is in "Machine B". I am doing sending from SQL Server 2k using Jmail. I want to access the network file "File1.txt" from "MachineA". If, I give machine name or ip. it doesn't take. simply it skips the attachment file and it sending only mail. If i stored the "File1.txt" in "MachineB" then its sending correct. Please give me some idea.....
Thanks & Regards Kumaran
Remember that your JMail job is running as the user that runs the SQLAgent service. I'd check to make sure this user can access the UNC you are referring to. Try logging into the console as your SQLAgent service account and running the job interactively. Hope it hlps.
/* Ghazi Hadi Al Wadi, PMP, ASQ SSGB, DBA */