I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions denied:
The permissions granted to user 'DESKTOP\Eyston' are insufficient for performing this operation. (rsAccessDenied)
The problem is that the machine is a Windows 7 Pro instance not on a domain so I have no idea what account I can connect to in order to setup the initial permissions for the server. The account 'DESKTOP\Eyston' belongs to the administrator group and was the user I was logged in to install.
Is there a way to add 'DESKTOP\Eyston' the 'System Administrator' role that Reporting Services requires to connect so I can administer the Report Server?