SQL SRS Impersonation Error Storing File On Network Share
Posted on January 9th, 2008 in Tech Notes |
When using SRS, if you set a report to save to a file on a share on a remote machine, you may get logon related errors and impersonation errors. These are fixed by adding the user who the report is run under to the Allow Log On Locally policy. Remember to use Domain Controller Security Policy if the server is a Domain Controller.
I won’t even tell you how long it took to figure this out.
-Zachary M. Morvik

