Freigeben über

Reporting Services 2005 Deployment/Configuration

  • Artikel

Many resources are available about SQL Server 2005 Reporting Services deployment and configuration options. However, here is a list of resources that we refer to and thought will share with you. 

Planning for Scalability and Performance with Reporting Services

Whether to scale-out or scale-up depends on your performance and load requirements. Refer to the following whitepaper for performance optimization tips and a comprehensive discussion that will help you decide which configuration is best for your situation.

https://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx

Accounts in a Reporting Services Deployment

When installing Reporting Services, you will need to consider the accounts and connections that are used.  The following MSDN article provides an overview.

https://msdn2.microsoft.com/en-us/library/ms159846(SQL.90).aspx

Configuring Report Server Security

You must analyze security options for the Reporting Services installation depending (among other things) on whether you will be internet facing or intranet facing.  For an overview, I recommend reviewing the following:

https://msdn2.microsoft.com/en-us/library/ms157198(SQL.90).aspx

If you require an internet facing installation, please review some additional configuration requirements:

https://msdn2.microsoft.com/en-us/library/ms159272(SQL.90).aspx

Deploying Reporting Services and Windows SharePoint Services Side-by-Side

This type of deployment requires a special configuration.  For more information, follow the instructions in the MSDN article below:

https://msdn2.microsoft.com/en-us/library/ms159697(SQL.90).aspx

Reporting Services Configuration Tool

Reporting Services 2005 has made configuration much simpler through the use of the Reporting Services Configuration Utility.  I highly recommend becoming acquainted with the tool.  For more information, see the following:

https://msdn2.microsoft.com/en-us/library/ms156305.aspx

Comments

  • Anonymous
    January 06, 2011
    Its a one stop shop for sql 2005..where useful