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