What should you do?

You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) solution. The current reporting solution consists of a single computer that hosts both the Web server components and the database server components of SSRS. This computer is dedicated to the sales department. The company security policy requires a separate SSRS solution for the payroll department. There is no budget for any new hardware. You need to isolate the security models of each department without using separate Web servers or database servers. What should you do?

You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) solution. The current reporting solution consists of a single computer that hosts both the Web server components and the database server components of SSRS. This computer is dedicated to the sales department. The company security policy requires a separate SSRS solution for the payroll department. There is no budget for any new hardware. You need to isolate the security models of each department without using separate Web servers or database servers. What should you do?

A.
Create two sets of site-level roles for each department. Use the same database for both the departments.

B.
Create two sets of site-level roles for each department. Create a new data source to store the data of the payroll department.

C.
Install another instance of the Reporting Services Web service on the computer by using a different URL. Use the same database for both the departments.

D.
Install another instance of the Reporting Services Web service on the computer by using a different URL. Create a new set of databases to store the data of the payroll department.



Leave a Reply 0

Your email address will not be published. Required fields are marked *