October 28, 2024 at 12:47 pm
http://servername/reports/browse/
could not load folder contents
http://servername/reportserver
The server principal "NT SERVICE\SQLServerReportingServices" is not able to access the database "ReportServerTempDB" under the current security context.
How do I fix this ? Does this have anything to do with SPNs ?https://learn.microsoft.com/en-us/sql/reporting-services/report-server/register-a-service-principal-name-spn-for-a-report-server?view=sql-server-2017
October 29, 2024 at 11:28 am
"Not able to access the database..." It's a permissions issue. Your service account, or the account you're calling from, don't have access to the appropriate databases. That's it. Check your security.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply