I can't find the RSReportServer.config file anywhere

  • I'm having problems find the above mentioned file. I can't find it on 2 installations of SSRS we have. I've searched the entire drive on both servers as the administrator and I have "Show hidden files and folders" radio button on. Do we not have SSRS installed correctly or did a service pack installation remove it?

  • This probably depends upon how you are logged onto the server,

    but even if you have Windows Explorer set to show hidden files and system files,

    you still might not see these config files on any search,


    you have, at least ONCE, navigated to those folders, in Windows Explorer.

    WHY I say that:

    I had tried repeatedly to find "RSReportserver.config", and had never seen it show up on *any* search -- not using Windows Explorer, nor SuperFinder XT, etc. --

    Then today, I used Windows Explorer to navigate, and even though I was logged on as a domain admin, as I double-clicked "Reporting Services", I got the familiar prompt:

    "You don't currently have permission to access this folder.

    Click Continue to permanently get access to this folder."

    I clicked Continue...

    ... and saw the "RSReportserver.config" file!...

    ... and after that, very interestingly, the "RSReportserver.config" file (and others in "*.config") STARTED SHOWING UP ON SEARCHES!


    In our case, it was in folder:

    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVERBO\Reporting Services\ReportServer

    But I've seen variations of that location, online (while wasting say too much time, on internet searches and windows explorer searches, trying to find it!)... ... variations like:

    <drive:>\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer

    or, in BOL (which did not match my reality):

    \Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer

  • Thanks, that helped a lot, didn't appear anywhere on searches but managed to find it on a different drive under the path you mentioned 🙂

  • I know this is an old thread but I have an explanation.

    The  configuration file is stored on the installation drive. (See here.)
    There is a registry key, which depends on instance name: (on my system for instance SQL2014_A)
        Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSRS12.SQL2014_A\Setup
        Value_Name: SQLPath.
    Sadly, sys.dm_server_registry does not show this key.

    Normally, I  would  encourage the use of xp_instance_regread tp get the  value, which does the translation from a standard name to an instance specific name (that Is needed by xp_regread).
    Unfortunately, I could not find the right key to get that to  work.

    This  gets  the SQL server installation directory (as opposed  to  the  ssRs  installation directory). You could cheat by using this to give you the drive:

      Declare @Result_Code       int;
      Declare @Value_String      sysname;
      Exec @Result_Code = master.dbo.xp_instance_regread
         @rootkey        =N'HKEY_LOCAL_MACHINE',
         @key           =N'SOFTWARE\Microsoft\MSSQLServer\Setup',
         @value_name     =N'SQLPath',
         @value          = @Value_String OUTPUT;
      Select '@Result_Code'      = @Result_Code,
             '@Value_String'     = @Value_String;

    To use the correct key (to  get the  ssRs  installation directory):

      Declare @Result_Code       int;
      Declare @Value_String      sysname;
      Exec @Result_Code = master.dbo.xp_regread
         @rootkey        =N'HKEY_LOCAL_MACHINE',
         @key           =N'SOFTWARE\Microsoft\Microsoft SQL Server\MSRS12.SQL2014_A\Setup',
         @value_name     =N'SQLPath',
         @value          = @Value_String OUTPUT;
      Select '@Result_Code'      = @Result_Code,
             '@Value_String'     = @Value_String;

    None of this is supported by Microsoft, so  use at your own risk.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply