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.
| Author |
Topic |
|
Salnick4
Starting Member
19 Posts |
 Posted - 2006-08-23 : 13:50:35
|
| I have a DTS job scheduled to execute daily...I tested the connection and did execute the package successfully...but when I came in the next morning, the job failed!I have a simple connection from the SQL Server table to an Access database table. The Access database resides on a shared server....so my connection path is something like S:/Access/MyDatabase.mdb.I think that I need to do something with the connection, but I am not sure....as I said the package will execute manually, but not when it is scheduled.I look forward to any response. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-23 : 13:57:24
|
| When a DTS package runs from a job, it runs in the context of the database server and not your client machine. It also runs under the SQL Server service account. So does the SQL Server service account on the database server have a mapped S drive?The way to test to make sure your package will work when scheduled is to log into the database server using the SQL Server service account. If it's the Local System Account, then that's the problem. If it isn't, then you execute the package manually from DTS designer and work from the error from there. The most important part of this test is that you log into the database server using the same account as the SQL Server service. If you don't know how to find out that info, let me know and I can walk you through that.Tara Kizer |
 |
|
|
Salnick4
Starting Member
19 Posts |
Posted - 2006-08-23 : 15:01:39
|
| Yes..that sounds logical.Any help in locating that SQL Server Account information would be great! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-23 : 15:04:31
|
| Open up Control Panel, open up Administrative Tools, open up the Services applet, navigate to your service. If this is SQL Server 2000 or earlier and is the default instance, then it will be named MSSQLSERVER. Find it, double click on it, then go to Log On tab. What does it say for the account?Tara Kizer |
|
|
|
Salnick4
Starting Member
19 Posts |
Posted - 2006-08-23 : 16:25:50
|
| I do not see it on the list of Services....neither the MSSQLSERVER or any SQL Server????? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-23 : 16:29:07
|
| You probably are looking on your client machine and not on the database server. This must be viewed on the actual SQL Server.Tara Kizer |
|
|
|
|
|
|
|
|
DTS Scheduled Job Not Working!