4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

1. Plan the upgrade .................................................................................. 151

2. Test the upgrade ................................................................................... 152

3. Back up the current machine state ........................................................... 153

4. Notify users of upgrade start .................................................................. 153

5. Apply the upgrade ................................................................................ 153

6. Confirm the upgrade ............................................................................. 154

7. Notify users of upgrade completion ......................................................... 154

8. Back up the machine state ..................................................................... 154

Upgrade SQL instances .................................................................................... 154

Upgrade considerations ............................................................................. 154

Upgrade procedure .................................................................................. 155

Multiple instance upgrades ........................................................................ 155

General machine upgrades .............................................................................. 155

A Configure SQL Server Reporting Services ......................... 157

Configure Reporting Services ............................................................................ 157

Configure Report Server for SQL Server 2008 .............................................. 159

Configure Report Server for SQL Server 2005 .............................................. 161

Configure high availability support .................................................................... 163

B Hosting Configurations for MS DTC .................................. 171

Overview ....................................................................................................... 171

Set up local MS DTC-enabled Virtual SQL Servers ................................................ 172

Set up a remote node for hosting DTC ......................................................... 177

Set up local nodes to use Remote DTC ......................................................... 181

Summary ....................................................................................................... 183

References ...................................................................................................... 184

C Support and other resources ........................................... 187

HP technical support ........................................................................................ 187

Subscription service ......................................................................................... 187

HP websites .................................................................................................... 187

Index .............................................................................. 189