CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008
J3FFK
J3FFK

Reputation: 684

SQL Server ReportServer Service keeps asking for credentials in browser

Using MS SQL 2018R2 Report Server Service the following URL's keep prompting for credentials:

http://ServerName/Reports
http://ServerName/Reportserver

Even after multiple attempts to enter user and password it still keeps asking for credentials, showing no index page for the reports. I am sure the credentials are correct. Only by using the browser the problem appears. It is not browser specific however.

It used to function for years, but all of a sudden it stopped working. We have not made any changes to RS configuration whatsoever. The problem is it won't connect and display the Reports page. Connection to the datasource is configured within the reports, but that's not the problem, we cannott even get to select a report to use. Desired behavior is a user would enter credentials once and then the index page with reports will show.

ReportBuilder3.0 or BIDS can easily render reports with same credentials. Also, SQL server agent runs several jobs executing SSIS packages which trigger reportingservices and they still run fine. Because these run fine I am hesitant to change settings like Service Account.

ReportService is used as a intranet reporting solution within our own domain. Configured at port 80.

I have read the following posts, but keep struggling for solution:

Similar question 1

Old solution2

Similar question 2

Link 4

Other sources:

Report Service Authentication

Service Account settings

Upvotes: 2

Views: 6671

Answers (1)

Krunal Shah
Krunal Shah

Reputation: 864

1)Change the authentication mode in rsreportserver.config to Custom

<Authentication>
   <AuthenticationTypes>
     <Custom/>
    </AuthenticationTypes>
   <EnableAuthPersistence>true</EnableAuthPersistence>
  </Authentication>

2)Change the Authentication mode in web.config file in ReportServer to None. Also change the Impersonation to false.

<authentication mode="None" />
<identity impersonate="false"/>

3)Add Microsoft.Samples.ReportingServices.AnonymousSecurity.dll to bin folder in ReportServer.

4)Add Extensions in rsreportserver.config Add the additional extension in Security Tag

<Security>
    <Extension Name="None" Type="Microsoft.Samples.ReportingServices.AnonymousSecurity.Authorization, Microsoft.Samples.ReportingServices.AnonymousSecurity" />
</Security>

Add the additional extension in Authentication Tag

<Authentication>
    <Extension Name="None" Type="Microsoft.Samples.ReportingServices.AnonymousSecurity.AuthenticationExtension, Microsoft.Samples.ReportingServices.AnonymousSecurity" />
</Authentication>

5)Add the following codegroup to configure the code access security in rssrvpolicy.config

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Private_assembly"
Description="This code group grants custom code full trust. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.AnonymousSecurity.dll"
/>
</CodeGroup>

6)Restart the reporting services, Anonymous Access should work.

You can find all these config files at - C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer depending on the version you have installed for reporting services.

Upvotes: 3

Related Questions