Installing SQL 2005 x64 on a Windows 2008 R2 x64

These are the steps I followed to get SQL 2005 x64 installed on our Windows 2008 R2 x64 server

SQL Server base install

1. Click Run Program for the "Program Compatibility Assistant" warning for SQL Server 2005.

2. Select the options you require  to install in the Feature Selection box (I installed Database Services, Reporting Services, Integration Services, Client Components and Documentation)

3.  In this case I left it as a default instance.

4. When customising the accounts the services run under, I always make sure that the agent runs under a different user. Therefore, I clicked on the "Customize for each service account". I also made sure that SQL Server, Agent, Reporting Services and the SQL Browser will auto start on boot. 

4a.  Note that I always run Reporting Services under "Local System"

5.  I then enabled Mix Mode authentication

6.  I chose my collation, for my servers I always want them in SQL_Latin_General_CP1_CI_AS (i.e. Dictionary Order, Case-insensitive for use with 1252 Character Set)

7.  Then I follow wizard through to completion and install SQL Server base install.

SQL Server Initial configuration

1.  Load up the Surface Area configuration Wizard, and then choose  MSSQLSERVER -> Database Engine -> Remote connections. I want it on "Using both TCP/IP and named pipes"

SQL Server SP3

1. First I needed to stop all the SQL Server services, this includes "SQLServer", "Agent", "Browser", "FullText", etc.

2. Also stop the Windows Management Instrumentation service 

3. Close any management consoles you have open (event viewer, computer management, services, etc)

4. Install the Service pack. I would not patch Reporting Services under x64, but that didn't seem to affect anything. 

4a. I used SQL authentication to apply the upgrade scripts (sa account)

Reporting Services config

1. Load up the Reporting Services Configuration Manager 

1. Start the Reporting services service

2.  Create a new Virtual Directory for the report server. Click the New Button.

3. Create the Report Manager Virtual Directory. Click the New Button.

4. The Windows Service Identity, was set to Network Service.

5. The Web service identity, I set to a new application pool called Report Server (also running under network service)

6. In the database set up, I clicked the connect and then the New button to create the new Reporting Services databases, and then apply.

7.  Finally I backed up my Encryption key to a safe location.