Data Source=(local);Initial Catalog=AdventureWorks2008 in Visual C#

Encoding USS Code 128 in Visual C# Data Source=(local);Initial Catalog=AdventureWorks2008

2. 3.

4. 5. 6.

Keep the connection defaults as they are, and then click Apply to save the changes. Open a new Command Prompt window by clicking Start, selecting Run, and then typing cmD and clicking OK. Back up the current SSRS encryption key by running the following command:

7. 8.

When prompted, confirm that you want to back up the encryption key by typing y. Next, to generate a brand-new key and encrypt the existing SSRS content with the new key, run the following command-line statement:

When prompted, confirm that you want to grant the report server access to the newly generated key by typing y. This will enable the content to use the newly generated key instead of the old key. In the Report Manager browser, press F5 to refresh the window, and then confirm that you still have access to the content. Then click the Test Data Source link to open the Test Data Source Properties page. Back in the Command Prompt window, run the following statement to back up the new key:

12. 13.

When prompted, confirm that you want to back up the key. Next, you will restore the original encryption key to your SSRS instance. Run the following command:

The Report Manager browser should still have the Test Data Source Properties page open. If it is, press F5 to refresh the content; if it is not, browse to the Test Data Source that you created in step 3. At this point, you will receive the error The report server is unable to access encrypted data. Apply a back-up key or delete all encrypted content. This is because the existing content was encrypted with a new key, but the old key was restored. If you did not have the new encryption key, you would not be able to access the encrypted content, and it would have to be deleted. Restore the new encryption key to enable the existing content to be unencrypted by the SSRS instance, and then run the following command:

Navigate back to the Test Data Source Properties page in the Report Manager browser, or if you are already there, press F5 to refresh the content and confirm that the properties are viewable and modifiable.

1 . What are the three SSRS command-line utilities and their primary functions 2. If you want to disable one of the rendering options in the Save As drop-down list

to the Report Server database; RSKeyMgmt.exe performs encryption key operations and scale-out deployment setup; RS.exe runs Report Server Script files that can perform report deployment and management operations.

by modifying the RSReportServer.config file and locating the <Extension Name= RenderDevice /> tag for the specific device.

As you begin the process of setting up a SQL Server 2008 BI environment, you are planning out your hardware architecture. Your solution will consist of an SSRS installation that will access online analytical processing (OLAP) data in SSAS built from a SQL Server data mart. Your manager has approved two blade servers for SSRS so that the service can be configured for scale-out deployment that will help to balance the workload and will provide some load balancing. Additionally, your system administrator has set up Network Load Balancing (NLB) to distribute the report requests. How will you handle the following two setup requirements

Your SSRS implementation requires that you set up a scale-out deployment of SSRS on the two allocated servers. You have already installed the first SSRS instance on one of the servers that points to a Report Server database on your database server. You are now ready to install an instance of SSRS on the second computer. How do you use command-line utilities to install and configure this instance to be part of the SSRS scale-out deployment To prevent a single point of failure for SSRS, you also need to handle failures at the report server catalog database level. In the case of a server hardware failure, you do not want the SSRS implementation to also fail. Which is the best high-availability technology to use for this situation and why