4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

Installations via a Microsoft Terminal Services client .............................................................. 113
Installer reports a failure .................................................................................................... 114
SQL Server 2005 core and components ....................................................................... 114
SQL Server 2005 service packs and hotfixes ................................................................. 114
Uninstall issues ................................................................................................................. 114
Connection issues ................................................................................................................... 114
DNS misconfiguration causes connection failure ................................................................... 114
References ................................................................................................................ 117
querySpn.vbs script .................................................................................................... 118
Connection error with Windows authentication .................................................................... 119
Windows authentication fails with SQL Server replication ...................................................... 119
Cannot authenticate on the local machine with a virtual host name ......................................... 120
Error when creating a Virtual SQL Server ................................................................................... 121
Failure to virtualize a SQL instance ............................................................................................ 121
Cannot access a Virtual SQL instance from the active node .......................................................... 121
SQL Server 2005 instance does not start ................................................................................... 122
Virtualized SSAS instance does not start and reports an invalid request address .............................. 122
Error when creating a distributor for replication .......................................................................... 122
11 Upgrade production SQL Servers ................................................... 129
General upgrade process ........................................................................................................ 129
1. Plan the upgrade .......................................................................................................... 129
2. Test the upgrade ........................................................................................................... 129
3. Back up the current machine state ................................................................................... 130
4. Notify users of upgrade start ......................................................................................... 131
5. Apply the upgrade ....................................................................................................... 131
6. Confirm the upgrade .................................................................................................... 131
7. Notify users of upgrade completion ................................................................................. 131
8. Back up the machine state ............................................................................................. 131
Upgrade SQL instances ........................................................................................................... 131
Upgrade considerations .................................................................................................... 131
Upgrade procedure .......................................................................................................... 132
Multiple instance upgrades ................................................................................................ 132
General machine upgrades ...................................................................................................... 132
A Configure SQL Server Reporting Services .......................................... 135
Configure Reporting Services .................................................................................................... 135
Configure Report Server for SQL Server 2008 ...................................................................... 136
Configure Report Server for SQL Server 2005 ...................................................................... 138
Configure high availability support ........................................................................................... 139
B Hosting Configurations for MS DTC .................................................. 145
Overview ............................................................................................................................... 145
Set up local MS DTC-enabled Virtual SQL Servers ....................................................................... 146
Set up a remote node for hosting DTC ................................................................................. 149
Set up local nodes to use Remote DTC ................................................................................. 151
Summary ............................................................................................................................... 153
References ............................................................................................................................. 153
C Support and other resources ........................................................... 155
HP technical support ............................................................................................................... 155
Subscription service ................................................................................................................ 155
HP websites ........................................................................................................................... 155
HP PolyServe Software for Microsoft SQL Server administration guide 7