SQL Server 2014 Reporting Services issues

Posted on

Question :

I have set up SSRS on MS SQL 2014 Dev Edition using the ReportServer built in account as the Service Account.

My machine name is: POUYASAGER
My local login is pyous
I have given the ReportServer account full permissions to:

C:Program FilesMicrosoft SQL ServerMSRS12.MSSQLSERVERReporting Services

I have checked that SecureConnectionLevel is set to 0 in the rsreportserver.config file.

I set up ReportServer as the virtual directory so that the Report Server Web Service URLs would be: http://POUYASAGER:80/ReportServer

When I click on the link in the Reporting Services Configuration Manager which is the same as above, I get:

The permissions granted to user ‘POUYASAGERpyous’ are insufficient for performing this operation. (rsAccessDenied)

When I navigate to: http://127.0.0.1:80/ReportServer, an authentication pop-up asks for a username and password.

When I navigate to the reports manager using: http://pouyasager:80/Reports, I get:
Error
Unable to connect to the remote server

How can I get SSRS working properly?

EDIT: I added “localhost” to the host headers and still got the same error.
EDIT: Using Chrome with Admin permissions, I navigate to http://localhost:80/ReportServer with the same results.

Answer :

Adding the account you are logging in on your OS will allow for you to connect to SSRS. You are provided with a 403 error message directly related to an access denied. The type of access being denied here is at the database level, mainly for the Reportserver$ database. Your OS login is unable to personify NT SERVICE since it does not have a login on the server and guest account being probably disabled.

Additionally, verify the following:
‘C:WINDOWSMicrosoft.NETFrameworkV2.0.050727Temporary ASP.NET Files’. (or where ever your .NET framework is installed on your machine)

Right click on the “Temporary ASP.NET Files” and select properties->secutity.

See if the “NETWORK SERVICE” is already part of the “User/Group” section. If not add it by typing “Network Service”.
If it’s already there then grant the write permissions.

Leave a Reply

Your email address will not be published.