Updating registration after server modification – HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses User Manual

Page 36

Advertising
background image

a.

Select the Register checkbox for the server instance.

b.

Click OK.

If the list does not display the SQL server to be registered, you must manually register the
instance. To manually register the instance:
1.

In the Server Name text box, enter the SQL server name and instance name. Use the
format SQLServerName\instanceName as follows:

To register the default instance, either enter the SQL server name only, or enter
the SQL server name and default, separated by a backslash.

For example, Aztec or Aztec\default.

To register a named instance, enter the SQL server and instance name, separated
by a backslash. Multiple server names can be added simultaneously by
seperating server names with a comma (,).

To register a named instance, enter the SQL server and instance name, separated
by a backslash.

For example: Aztec\Bld2.

Multiple server names can be added simultaneously by separating server name
or instance name with a comma (,).

NOTE:

Do not use the following characters when naming a server:

`~!@#$%^&* ( ) + = _ [ ] { } | \” ‘ ,< > / ?

Do not use the following characters when naming an instance: `~!@%^&* (
) + = [ ] { } | \” ‘ ,< > / ?

Do not use $ as the first character in an instance name and the names are limited
to 16 characters.

2.

Click Add. Recovery Manager adds the new SQL server and instance to the list and
automatically selects the Register checkbox for the entry.

3.

Click OK to start the registration.

NOTE:

Depending on the network traffic, it may take up to several minutes for the Recovery

Manager GUI to register a SQL server instance.

3.

Depending on the success of the registration, do one of the following:

If Recovery Manager displays Update Success in the entry's Status column, Recovery
Manager successfully registered the instance. Click OK. You can now use the Recovery
Manager GUI to manage the instance.

If Recovery Manager displays Update Failed in the entry's Status column, Recovery
Manager was not able to connect to the instance.
a.

To fix any connectivity issues, see

“Troubleshooting SQL Connectivity” (page 25)

.

The instance must pass the SQL connectivity test before the Recovery Manager GUI
can successfully register the instance.

b.

Repeat the registration steps for the SQL server until Recovery Manager successfully
registers the instance.

Updating Registration after Server Modification

If configuration of registered instance is modified (for example, a new database is created under
that instance), the instance must be rescanned to update the registration.

To rescan an instance:

36

Using the Recovery Manager GUI

Advertising
This manual is related to the following products: