• Adam Thurgar

Multiple instances of SSRS


I was asked the other day, is it possible to have multiple SSRS instances on the same server?

The answer is yes, you can install another instance of SQL Server and then install whatever components that you want on that instance and SSRS is one of those non-shared components.

This is useful if you want to host different content for specific sites. Each instance will have its own report server database, configuration files, and virtual directories.

See the following link.

https://technet.microsoft.com/en-us/library/ms403426(v=sql.90).aspx


38 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t