1. Summary
This article details the steps I took to configure Microsoft SQL Server 2008 SP2 Enterprise Edition, Analysis Services, and Reporting Services were installed on a Windows 2008 R2 SP1 VM, with 8 CPU's, and 32GB Ram, for use by the Symantec Management Platform (SMP). This server is dedicated to SMP so we have no worries about other applications on this SQL server. These steps worked flawlessly for me, but should be reviewed with your Database Administrator(s) first to ensure they will work for your environment. Some steps may be modified based on your requirements, so please keep that in mind when reading through this article. The perquisites for this article (installation) were covered in https://www-secure.symantec.com/connect/articles/how-install-microsoft-sql-2008
2. Configure MSSRS and MSSAS
2.1. Click on Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools | Reporting Services Configuration Manager.
2.2. Click Connect to login to the default instance (or the instance that you created for your SMP).
2.3. Verify the service is started.
2.4. Click on Service Account in the left column and ensure it is set to ‘Use another Account’ . Set it to the AppId and password. If not, change it, and then click Apply. Verify in the Results section at the bottom part of the screen that it worked and there are no errors.
2.5. Click on Web Service URL in the left column and ensure the Virtual Directory is set to the default of ReportServer. There should be no need to change anything. Click Apply and verify there are no errors in the Results section at the bottom of the screen.(URL will be http://<yourSQLserverName>:80/Report Server)
2.6. Click on Database in the left column, and then click Change Database.
2.7. Select Create a new report server database then click Next.
2.8. Don’t change anything, and then click Test Connection. If it works, click OK.
2.9. Leave the defaults and then click Next.
2.10.Change the Authentication Type to Windows Credentials and enter the AppId and password, then click Next.
2.11.Click Next.
2.12.Verify there are no errors and click Finish.
2.13.Click on the Report Manager URL in the left column and verify the default virtual directory is set. Click Apply and then verify there are no errors in the Results window. Then click Exit.
2.14.Reboot the SQL server.
2.15. Verify you can still login to the SQL server and point a browser to the Reporting URL set above (http://<yourSQLserverName>:80/Report Server if you followed these steps)
Note: The above steps for configuring MSSRS and MSSAS were found here: http://www.symantec.com/connect/videos/configure-sql-reporting-services-2008-ssrs-it-analytics-ita-smp-71 but were modified based on testing and validation in our environment.