SQLServerCentral.com / Reporting Services / Reporting Services 2008/R2 Administration / SSRS using separate database and reporting server / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 12:38:17 GMT20RE: SSRS using separate database and reporting serverhttp://www.sqlservercentral.com/Forums/Topic1534475-1632-1.aspxKev,You might have a look at this.[url=http://msdn.microsoft.com/en-us/library/ms677949(v=vs.85).aspx]SPN on MSDN[/url]Thu, 27 Feb 2014 06:54:49 GMTTee TimeSSRS using separate database and reporting serverhttp://www.sqlservercentral.com/Forums/Topic1534475-1632-1.aspxHi 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:[code="xml"]&lt;AuthenticationTypes&gt; [b]&lt;RSWindowsKerberos/&gt;[/b] &lt;RSWindowsBasic/&gt; &lt;RSWindowsNTLM/&gt; &lt;RSWindowsNegotiate/&gt; &lt;/AuthenticationTypes&gt;[/code]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,KevFri, 24 Jan 2014 06:36:24 GMTkevaburg