December 1, 2010 at 5:21 pm
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?
September 23, 2014 at 1:45 pm
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,
UNTIL
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
August 9, 2016 at 7:56 am
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 🙂
April 14, 2018 at 7:58 am
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