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 |
|
SQLSoaker
Posting Yak Master
169 Posts |
 Posted - 2009-06-26 : 11:19:51
|
| Hello,I've made a report with a bunch of subscriptions. I am using the "Report Server File Share" option to automatically run these subscriptions on a schedule and save them to a network shared drive.I've made about 50 subscriptions running one minute after another scheduled at night.Most of the subscriptions ran just fine but some of them errored out: A logon error occurred when attempting to access the file share. The user account or password is not valid.But when I changed the scheduling and ran them using the SAME user name and password, it worked just fine.This proves that it cannot be a user account / password problem... Is this maybe due to running to many subscriptions one minute after another?Thanks in advance for your reply.Regards. |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2009-07-02 : 12:07:16
|
| Hello,This was due to permissions on the shared network drive. (Thought others might want to know) |
 |
|
|
|
|
|
Subscriptions