April 17, 2015 at 2:34 pm
Hi,
On my local machine I'l like to set up SSRS and do the Lynda videos before a job interview next week. I've installed the service as ReportServer$COMP.
I'm logged in as an administrator Windows 8.1
User 'TheForce\my_user' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
My user logs in through a windows account with an SQL Login that has sysadmin server roles and is mapped to each database as the dbo user.
What's odd is that the same 'TheForce\my_user' login is mapped as user 'TheForce\my_user' to the system databases but as dbo to the user databases. I can't change the user value to 'TheForce\my_user' for the ReportServer database. (Not that I think I should - I'm taking stabs at this.)
I know my way around a local environment to give total permissions for the purpose of going through the videos. But am stuck here.
SSIS is running and my windows using 'TheForce\my_user' is the administrator... what can be going wrong here?
John
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
SQL 2012 Standard VPS Windows 2012 Server Standard
April 17, 2015 at 7:09 pm
Most folks with this problem notice two things:
1) Run the browser or SQL Data Tools as administrator and permissions are not a problem.
2) Once Reporting Site Settings are accessed from a browser started as administrator, one can add the domain\user with failing permissions to solve the problem.
In my case, number 1 is true but number 2 is not.
I add 'myComp\myUser' giving them System Administrator roles from within SSRS Site settings but still have the same problem.
User 'myComp\myUser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed
Any ideas what I'm missing?
J
SQL 2012 Standard VPS Windows 2012 Server Standard
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply