SQL Server 2005 Reporting Services

  • Does anyone know if SQL Server 2005 Reporting Services is cluster server aware? When you install this does it install it on the passive server as well, or do I need to install on both the active and passive server.

    Does the reporting database need to be backed up?

    Thanks SQL friends.

    Patti

  • it's not cluster aware

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thanks. Do you by any chance know if this type of database should be backed up? I think it should but I'm really not sure how the database is used.

  • yes you should backup the reportserver database as it holds the reportserver configuration\definitions

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • SSRS is not cluster aware. Further, you cannot install a SSRS instance with the same name as the SQL DB instance, it must have a different name.

    The /ACTION=InstallFailoverCluster process will allow you to select SSRS and install it with the same instance name as the db cluster, but the /ACTION=AddNode process will not install SSRS on the second node, and there is no SQL install option that will install the SSRS instance on the second node with the same name as the DB instance.

    I have found it is best when doing a cluster install to install SSRS separately to the DB cluster and have SSRS use its own instance name. This way I can give SSRS the same instance name on all nodes of the cluster.

    Finally, the SSRS install is in FilesOnly mode, so you have to manually create the SSRS databases and link the SSRS instances to them.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • I am planning to run control panel>add/remove programs>SQL Server 2005>Add Components>Database Engine. Then setup runs where I select Reporting Services and the instance. Is the reporting services database created during the installation or do I have to manually create the database?

  • as Ed already pointed out you have to create the reportserver databases manually in files only install mode

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Hey Perry, I am probably being a little thick, but when I choose the method of installation that I am planning is that a files only install? I have never installed Reporting Services so I am not familiar.

  • SSRS generall only installs and configures if it sees a local instance of SQL Server if i remember correctly, otherwise it installs files only mode. Check Books online for more info and how to install\configure

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 9 posts - 1 through 8 (of 8 total)

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