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 |
|
BobFoutFX4
Starting Member
9 Posts |
 Posted - 2008-04-02 : 14:00:33
|
| I checked both the MSSQLSERVER and SQLSERVERAGENT roles and both appear to be using my domain account to run the services. If this is indeed the case... why can't I access network drives (Even with the full UNC path) when I schedule the package as opposed to running it directly from Enterprise Manager.In other words, I can't access anything outside of my local C:\ Drive. I am just trying to schedule the package using my local sql server.What else could be the problem? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 14:27:53
|
| Looks like you don't have permission to access the UNC path. Check NT guys |
 |
|
|
BobFoutFX4
Starting Member
9 Posts |
Posted - 2008-04-02 : 15:15:23
|
quote:
Originally posted by sodeep
Looks like you don't have permission to access the UNC path. Check NT guys
Well, It appears to me that the agent is using my logon credentials so it should have my access when running the package, right?Who are the NT guys? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 21:46:25
|
| >> Who are the NT guys?Your windows admin if have any. By the way, who is job owner? |
|
|
|
BobFoutFX4
Starting Member
9 Posts |
Posted - 2008-04-03 : 07:49:02
|
quote:
Originally posted by rmiao
>> Who are the NT guys?Your windows admin if have any. By the way, who is job owner?
I own the job. My domain account... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 22:04:44
|
| Do you have sysadmin rights in sql server? |
|
|
|
|
|
|
Scheduled DTS Package Failure