Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS using separate database and reporting server Expand / Collapse
Posted Friday, January 24, 2014 6:36 AM


Group: General Forum Members
Last Login: Friday, December 2, 2016 11:16 AM
Points: 432, Visits: 801
Hi folks,

We have in-house a BI Server with SSRS instances installed and each SSRS instance connects to a clustered database server where its own database is hosted. Although I can make successful connections directly from the Reporting Services Server to the database (and thus work normally) clients cannot connect from their workstations to the reporting server.

I have decided to use a domain-based account for the service account rather than the networkservice account because it falls in line with our security concept. The problem with this approach seems to be in the handling of the Kerberos token for the authentication method.

After some research I found that a .xml file called rsreportserver.config needed to be altered because I am using a domain-based account instead of a localnetwork account. The change that needed to be made in order to make this reporting server compatible with our requirements was the following:


In addition to altering this code our network admins had to register the SPN for the user that will authenticate. I am not sure if the admins have done this correctly but the concrete fact is that it still doesn't work.

Can anyone help with this problem or maybe even give me a hint on how the SPN shuld be entered in order for it to work?

Many thanks in advance,

Post #1534475
Posted Thursday, February 27, 2014 6:54 AM

Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, February 29, 2016 9:46 AM
Points: 555, Visits: 465

You might have a look at this.

Post #1545857
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse