Databases are used to track files and folders that have been replicated, individual file versions, and snapshots. Connections to your Microsoft SQL Server databases are defined globally in Preferences in the Data Sources page. You can view, add, edit, and remove database connections. You cannot modify or delete a database connection when it applied to a job.
To create a new database connection:
1.Select Preferences from the Window menu.
2.Expand Cloud Sync in the navigation tree, and then select Database Connections.
The existing database connections are listed in the Database Connections table.
3.Click the Create button.
The Add Database Connection dialog appears.
4.Enter the required values.
5.Click Validate to test the connection, and then click OK in the confirmation message that appears.
6.Click OK to close the dialog.
The new database connection is listed in the Database Connections table.
Database Connection Name |
Enter a name for this database connection. |
Management Agent |
Select the Agent that will use this connection. |
DB Hostname |
Enter the name of the SQL Server hosting the database. If the database is installed on the Agent server itself, enter the name of the Agent server. |
Port |
Enter the port to be used to communicate with the specified SQL Server. If not defined, the connection defaults to port 1433. |
Instance Name |
Enter the database instance name to use on the specified SQL Server. If no named instances are installed on the specified SQL Server, leave this empty. |
Database Name |
Enter the name of the database that Cloud Sync will create. The default name is “peercloud” but it can be changed to a name that follows your company’s naming conventions. |
Authentication |
Select Integrated if the Agent service account is granted admin rights on the selected SQL instance. Otherwise, select Credentials to enter the user name and password of a database administrator. |
User Name |
Enter the user name of the database administrator account to be used by Cloud Sync. This can be a locally-defined account such as “sa” or a domain account. |
Password |
Enter the password of the database administrator account to be used by Cloud Sync. |