Troubleshooting sql connectivity – HP 3PAR Recovery Manager Software User Manual

Page 25

Advertising
background image

4.

Click Connect. A window appears as follows:

If you are able to connect, the installation and configuration is complete.

If the connection cannot be made, you must check the SQL configuration. For more information,
see

“Troubleshooting SQL Connectivity” (page 25)

.

Troubleshooting SQL Connectivity

1.

Log onto the SQL production server as system administrator and check connectivity:

From the SQL production server, launch SQL Server Management Studio to make sure
the connection can be made locally.

From Management Studio, right-click SQL server

→Properties→Connections.

Make sure the Allow remote connections to this server box is selected.

Make sure the SQL server for that instance has a status of started.

For named instances, make sure the SQL server browser has a status of started.

Double-check the settings under Properties

→Security.

Double-check the settings under Properties

→Permissions.

2.

After you have checked the SQL configuration on the production server, log onto the backup
server and run the SQL connectivity test again.

NOTE:

Your backup server must pass this SQL connectivity test before you can use HP 3PAR

Recovery Manager Software for Microsoft SQL Server.

3.

Verify that the SQL Server Browser service is running. Start the service if it is not running.

Configuring the Host Computer and the HP 3PAR StoreServ Storage System

For information about configuring the HP 3PAR StoreServ Storage System to communicate with the
host computer, see the HP 3PAR StoreServ Storage Concepts Guide (OS 3.1.3) and the HP 3PAR
Command Line Interface Administrator’s Manual
.

NOTE:

The HP 3PAR StoreServ Storage System source volumes used by Recovery Manager must

be base volumes. Recovery Manager cannot use physical copies or virtual copies as source volumes.

Configuring the Host Computer and the HP 3PAR StoreServ Storage System

25

Advertising