September 13, 2004 at 4:46 pm
I have a DTS that works when I run it but when I schedule it the job fails. I am sure this is a permissions issue but am not sure what to set to make it work.
Basically the dts calls a asp page that checks to see if records are within 7 days and or are late.
I know the code works but I want to run this at 1 am every night but it does not work in a schedule. I am the owner of the job, I have admin rights to SQL server and modify rights to where the ASP page is called from.
Thanks in advance.
September 14, 2004 at 3:05 am
The error message in job history would be useful. What is it?
September 14, 2004 at 3:20 am
try this...
- The connection to sql server is correct in DTS package, Try
using sql server Auth. with 'sa' user.
may be it helps...
Naveen
September 14, 2004 at 4:22 am
Can you run other DTS jobs on this server? If not have you had a look at what user SQL Agent is running on the server?
September 14, 2004 at 8:43 am
As suggested above, take a look at the error message from the job history -- better yet, turn on logging in the job for a better, more meaningful message. In the job step, open the 'Advanced' tab and enter a path and filename for the 'Output File'. After the job fails, navigate to this log file to see what the message is. More than likely, it is a permissions issue with the SQL Agent account.
September 14, 2004 at 8:45 am
Hi, check that the log-in used by the SQL Server Agent has the permissions sufficient for each aspect of the package. We generally use a specifically set-up domain log-in that can then access network shares and other domain resources.
this log-in is the same as that used for SQL Server services and is part of the sysadmin group.
September 14, 2004 at 4:06 pm
Thanks for all of your suggestions. The last comment was correct, I needed to use a domain admin account that is used for starting sql services.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply