March 27, 2018 at 11:24 pm
Hi there
I have created a database, and created a procedure that joins to an additional database to retrieve Location information. I have access the database through ssms without issue, and can execute the procedure. However, if I run the proc through SSRS, I get the below error:
I have made myself the owner of the database in question, to no avail.
The server principal "DOMAIN\user" is not able to access the database "Database" under the current security context.
----------------------------
Query execution failed for dataset 'GiftCardActivity_SummarisedByCashier'. (rsErrorExecutingCommand)
----------------------------
An error has occurred during report processing. (rsProcessingAborted)
March 28, 2018 at 7:31 am
The security context that SSRS runs under will usually (if not always) be the SSRS Service Account, so that account will need at least read access to that other database.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 28, 2018 at 7:44 am
It depends on who server principal "DOMAIN\user" is. Is this failure for the service account for SSRS? It could also be the data source for the report and how security is configured for the data source. I would lean towards the data source being the problem when the failure is with the query execution.
Sue
March 28, 2018 at 9:22 am
Sue_H - Wednesday, March 28, 2018 7:44 AMIt depends on who server principal "DOMAIN\user" is. Is this failure for the service account for SSRS? It could also be the data source for the report and how security is configured for the data source. I would lean towards the data source being the problem when the failure is with the query execution.
Sue
Yep, kinda forgot about that in my rush to answer... Kind of busy today...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 28, 2018 at 9:28 am
Hey Guys
Thank you for taking the time to respond. On your recommendation, I looked back at the data source configuration, and the option to 'impersonate user logging on' was selected. DOH! Wish I had thought of it sooner rather tahn waste 5hrs searching online for solutions. You live and learn.
Thanks again
March 28, 2018 at 9:30 am
bexstarr - Wednesday, March 28, 2018 9:28 AMHey GuysThank you for taking the time to respond. On your recommendation, I looked back at the data source configuration, and the option to 'impersonate user logging on' was selected. DOH! Wish I had thought of it sooner rather tahn waste 5hrs searching online for solutions. You live and learn.
Thanks again
Been there, done that. Glad we could help.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 28, 2018 at 11:13 am
Yeah...it's a weird one. It's one of those we always forget about when we get hit with it for some reason.
At least it's good now though.
Sue
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply