Creating a node on the IBM Spectrum Protect server

After you install the IBM Spectrum Protect client and Data Protection for SQL Server, you must set up a node name and password and register your node with the IBM Spectrum Protect server. When a new node is registered, an administrative user ID must be created for the node. The IBM Spectrum Protect server administrator must specify the userid option with the register node command.

About this task

When you register your node, you create a file space on the IBM Spectrum Protect server where the backups of your data are stored. You must set up a client node and a Data Protection for SQL Server node. If you are protecting availability databases in an AlwaysOn Availability Group, you must also register the AlwaysOn node.

Follow these procedures if you installed the IBM Spectrum Protect administrative command-line client. If you did not install the administrative client, the nodes must be registered on the IBM Spectrum Protect server.

Procedure

Start an administrative client session by issuing the following command in a Command Prompt window:
```
C:\Program Files\Tivoli\TSM\baclient\dsmadmc
```
To register a client node, issue the following command:
```
reg node client_nodename password backdel=yes userid=client_nodename
```
Where client_nodename is the node name for the client and password is the password that you want to use for the client. The backdel=yes parameter indicates that you can delete backup objects in your file space on the server. The node name and administrative user ID must be the same.
For example:
```
reg node doomvm3 doomvm3passwd backdel=yes userid=doomvm3
```
To register a Data Protection for SQL Server node, issue the following command:
```
reg node sql_nodename password backdel=yes userid=sql_nodename
```
Where sql_nodename is the node name for the Data Protection for SQL Server node and password is the password that you want to use for the SQL node. The backdel=yes parameter indicates that you can delete backup objects in your file space on the server. The node name and administrative user ID must be the same.
For example:
```
reg node doomvm3_sql doomvm3sqlpasswd backdel=yes userid=doomvm3_sql
```
Tip: To easily identify the node as a node for Data Protection for SQL Server, add _sql to the end of the node name.
To register the AlwaysOn node, issue the following command:
```
reg node alwayson_nodename password backdel=yes userid=alwayson_nodename
```
Where alwayson_nodename is the name for the AlwaysOn node and password is the password that you want to use for the AlwaysOn node. The backdel=yes parameter indicates that you can delete backup objects in your file space on the server. The node name and administrative user ID must be the same.
For example:
```
reg node myalwaysonnode alwaysonpasswd backdel=yes userid=myalwaysonnode
```

What to do next

To use IBM Spectrum Protect server policy sets, the IBM Spectrum Protect must define the policy domains, policy sets, management classes, copy groups, and storage pools.

These definitions are necessary to meet your Data Protection for SQL Server backup and restore requirements. For VSS operations, IBM Spectrum Protect server authentication must be on.