Impact of using a new or existing SQL Server instance

When you set up your installation of Centrify report services, you have the option of either using an existing SQL Server instance or installing a new instance. Centrify recommends that you use a new SQL Server instance, if possible.

If you choose to install a new instance from the Centrify Management Services installer program, the program installs an instance of SQL Server Express 2008 R2 with Advanced Services.

If you have an existing installation of SQL Server, you can create a new instance there first on your own, using your own installation media. When you install or configure Centrify report services, you then configure report services to use your existing instance that you created. That way your SQL Server instances use the same edition and version.

Tip:     Please see the information at the following link for details about installing multiple versions and instances of SQL Server:

https://msdn.microsoft.com/en-us/library/ms143694(v=sql.130).aspx

Here are some issues to be aware of if you’re going to use a new SQL Server instance:

  • With a new SQL Server instance, you can avoid any potential problematic issues with SSRS, particularly if you need to reinstall SSRS.
  • SSRS won’t slow down the regular database operations on other instances.
  • To prevent the SQL Server instance from consuming too much memory, it’s recommended to use the max server memory to control each SQL Server instance’s memory usage. The total allowance is not more than the total physical memory on the machine. If user is not running all of the instances, none of the running instances will be able to utilize the remaining free memory.

Here are some issues to be aware of if you’re going to use an existing SQL Server instance:

  • There can be issues with SSRS and existing instances. If you have to uninstall and reinstall SSRS, it leaves files behind with the existing instance.
  • Using an existing SQL server instance can use all the free memory with a larger limit of the max server memory setting.

If you choose to deploy report services using an existing instance of SQL Server, your database administrator may need to know what changes that report services needs to make to the database. (KB-8042)

The only modification that report services makes to an existing database instance is to add two Windows integrated logins, as follows:

Login

Granted database role for the Report Service database

<The specified service account>

SnapshotService

[NT Authority\Authenticated Users]

SnapshotViewer

Note:   If these logins already exist, report services does not re-create them.