StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I was running into the same issue. Here is how I fixed it.</p> <p><strong>Problem description</strong> When setting an SSRS report subscription to run at a given time, I would wait for the time to pass and then find that the "Last Run" timestamp did not change. My subscription appears not to have run.</p> <p><strong>Relevant troubleshooting info</strong></p> <ol> <li><p>SSRS report subscriptions are executed as SQL Jobs that the Report Server web UI creates for you behind the scenes.</p></li> <li><p>When looking at the job that was created for my report subscription, I saw that it always failed with the error:</p> <blockquote> <p>The job failed. Unable to determine if the owner (domain\userName) of job 0814588B-D590-4C45-A304-6086D5C1F559 has server access (reason: Could not obtain information about Windows NT group/user 'domain\userName', error code 0x5. [SQLSTATE 42000] (Error 15404)).</p> </blockquote></li> <li><p>In the Sql Server Configuration Manager I could see that the "SQL Server Reporting Services" service was configured to run using an AD user account.</p></li> <li><p>In the Sql Server Configuration Manager I could see that the "SQL Server" service was configured to run using a <em>local Windows account</em>.</p></li> <li><p>As @Remus Resanu pointed out, the SQL error 15404 refers to an exception when EXECUTE AS context cannot be impersonated.</p></li> </ol> <p><strong>Solution</strong> Bingo! #4 and #5 are the key to the problem. The SQL Server service (a local Windows user account) was trying to authenticate the user "domain\userName" in AD, which it could not do because it does not have the right/permission to access AD resources.</p> <p>I changed the SQL Server service to us an AD user account, restarted the SQL Server and SQL Server Agent services, re-ran the SQL job and, blamo, success!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload