Scheduling Task
-
i have created a console application in C#.Net. This exe calls a dts package on a sql server and that package in return generates a text file and some excel files as result. i have scheduled this through window scheduled tasks option to run daily with a domain account which is not included in the adminstrator group of the local machine. The problem is that the text file is generated but the excel files are not. But when i run the exe thru : right click> Run As> and then provide the same non admin credentials, all files including excel files are generated. Even when i log on to the system as this non admin account and run the exe directly, i get full results! Is there any privilege difference in executing a task thru the task scheculer? or am i missing something? I have also checked the event viewer and the following error was logged: "Access denied attempting to launch a DCOM Server. The server is: {00024500-0000-0000-C000-000000000046} The user is visiadmin/KARACHI, SID=S-1-5-21-854245398-2146720035-839522115-2639." visiadmin is the non admin account and KARACHI is the domain name. i have also followed the support on http://support.microsoft.com/default.aspx?scid=kb;en-us;290398 but still no results! I am using VS.Net 2003, O/S: Windows Server 2003, exe developed on C#.NET, MS Office 2003. Please help me! thanx in advance Regards ☺«««DTA»»»☺