SharePoint: Install Report Service Add-in on SQL Server

* Install SharePointRS.msi from \\hqd1\Software\SharePoint 2007 Installation\ReposerServiceAddIn
*Click Start => Programs => Microsoft SQL Server 2005 => Configuration Tools.
*Click Reporting Services Configuration. The Report Server Installation Instance Selection dialog box appears so that you can select the report server instance you want to configure.
*In Machine Name, specify the name of the computer on which the report server instance is installed. The name of the local computer is specified by default, but you can also type the name of a remote SQL Server instance.
* In Instance Name, choose the SQL Server 2005 Reporting Services instance that you want to configure. Only SQL Server 2005 report server instances appear in the list. You cannot configure earlier versions of Reporting Services.
* Click Connect.
* Click Database Setup to open the Database Setup page.
* Enter the name of the SQL Server Database Engine you want to use.
* Click Connect.
* Click New.
* In the SQL Server Connection dialog box, enter a name for the new database.
* Select the Create the report server database in SharePoint integrated mode check box.
* Click OK.
* On the Database Setup page, specify the credentials that are used to connect to the report server database.
* Choose Service credentials to use the Windows service account and Web service account to connect through integrated security.

Choose Windows credentials to specify a domain user account. A domain user account must be specified as \.

Choose SQL Server credentials to specify a SQL Server login.

Click Apply.

Restart the Report Server Windows service.