|
Adding SQL Server Instances
To back up or restore a database, you must first add the SQL Server instance to SQL Decryptor. SQL Decryptor displays the list of SQL Server instances that have been added in the Registered SQL Servers pane.
You can add the SQL Server instances by specifying the name, When you have added a SQL Server instance, you can:
- edit the registration to change the authentication or connection properties
- delete an individual SQL Server instance registration, or an entire group
Adding SQL Server instances
- Click the tab for the location in which you want to register the SQL Server instance.
- On the File menu, click Add SQL Server.
- The Add SQL Server dialog box is displayed.
- Type or select the name of the SQL Server instance in the SQL Server box.
If you experience problems selecting a SQL Server instance that is not running on the LAN, for example if you are accessing the SQL Server instance via an internet connection, you may need to create a SQL Server alias using TCP/IP; refer to your SQL Server documentation for details. You can then type the SQL Server alias name in the SQL Server box to connect to the remote SQL Server. (Note that this SQL Server alias is not the same as the SQL Decryptor alias, entered below.)
- Select the authentication method, and for SQL Server authentication enter the User name and Password.
For Windows authentication, the credentials of the current user are used.
For SQL Server authentication, you can select the Remember Password check box. The password will be encrypted. If you do not select Remember Password, when you next start SQL Decryptor  will be displayed next to the SQL Server instance name to indicate that SQL Decryptor has not attempted to connect to the SQL Server instance; Right-click the name of the SQL Server instance in the Registered SQL Servers pane and click Edit to enter the authentication details.
- From the Group list, select the SQL Server group to which you want to add the SQL Server instance.
For more information about groups, see Managing SQL Server Groups.
- To set up a SQL Decryptor alias for the SQL Server instance, in Alias type the alias that you want to use.
The alias will be displayed throughout the SQL Decryptor graphical user interface.
- To change the connection properties from their default values, click Connection Properties and edit the values as required.
- Click Connect.
SQL Decryptor adds the SQL Server instance. This may take a few minutes. The SQL Server instance is displayed in the Registered SQL Servers pane.
If there was a problem with the authentication,  is displayed next to the SQL Server instance name. For example, this is displayed if you have entered the password incorrectly. Click the icon to correct the authentication details.
If there was a problem connecting to the SQL Server instance,  is displayed next to the SQL Server instance name. Click the icon to see further details of the problem.
Connection Properties
To change the connection properties:
- On the Add SQL Server dialog box, select the Connection Properties tab.
- Under Network, select the required network protocol from the Network protocol list.
- The available client protocols are those configured in Microsoft SQL Server using the Client Network Configuration in Computer Management.
- In Network packet size, type or select the size of the network packets to be sent.
- The default value is 4096 bytes.
- Under Connection, in Connection time-out type or select the number of seconds to wait for a connection to be established before timing out.
- The default setting is 15 seconds.
- In Execution time-out, type or select the number of seconds to wait before execution of a task is completed on the SQL Server.
- The default value is zero seconds (no time-out).
- To force the connection to be encrypted, select the Encrypt connection check box.
Editing a SQL Server instance registration
To change the SQL Server authentication or the connection properties:
- Right-click the name of the SQL Server instance in the Registered SQL Servers pane and click Edit.
- Edit the registration settings and connection properties as required.
- Click Connect.
Removing SQL Servers
To remove a SQL Server instance from the Registered SQL Servers pane, do one of the following:
- Right-click the name of SQL Server instance in the Registered SQL Servers pane, and click Delete.
- Click the name of SQL Server instance in the Registered SQL Servers pane, then in the Edit menu, click Delete.
To remove all SQL Server instances in a SQL Server group and delete the group, do one of the following:
- Right-click the name of the group in the Registered SQL Servers pane, click Delete, and then click Delete on the confirmation dialog box.
- Click the name of the group in the Registered SQL Servers pane, in the Edit menu, click Delete, and then click Delete on the confirmation dialog box.
|
