June 23, 2015 at 12:21 pm
Hello,
I am playing around in a test environment with SQL Server 2014. I have a question about the default location of the report server databases when you have multiple report server instances installed on one server.
To hopefully simplify me trying to explain things, I did a very simple install of SQL Server 2014 with the database and Reporting Services in Native Mode (install only) features selected. Accepting the default locations, I ended up with the following locations as you would expect:
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER
C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER
Running the Reporting Services Configuration Manager, I created the Report Server database. After creating the Report Server database, the related files will be located below in the SQL folder as I would expect.
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA
Next I installed another instance, which I called Test, of SQL Server 2014 like I did above. I now have the following folder structure the Test instance as I expect.
C:\Program Files\Microsoft SQL Server\MSSQL12.TEST
C:\Program Files\Microsoft SQL Server\MSRS12.TEST
Running the Reporting Services Configuration Manager, I select the Test instance and create the Report Server Test instance database.
My first thought would be that the Test instance Report Server database would be in the following location:
C:\Program Files\Microsoft SQL Server\MSSQL12.TEST\MSSQL\DATA
Instead this database is located with the default instance Report Server database:
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA
What I do not understand is why. I have searched online but am not finding anything that would explain things.
Thanks.
June 23, 2015 at 2:21 pm
On your Test SSRS instance what database instance did you specify in Reporting Services Configuration Manager? It sounds like you specified the default db instance instead of the Test db instance.
Joie Andrew
"Since 1982"
June 23, 2015 at 2:52 pm
Joie Andrew (6/23/2015)
On your Test SSRS instance what database instance did you specify in Reporting Services Configuration Manager? It sounds like you specified the default db instance instead of the Test db instance.
The Test instance was selected.
I just figured it out though. Naturally it was staring me in the face. When I went to create a new report server database, I totally brain farted on the Server Name field. For some reason it didn't click to '\' and type in the instance name.
Thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply