Creating a Collector archive from Control Center (Microsoft SQL Server)

Prerequisites

•	A configured Collector archive is available in the Repositories folder. See Adding and configuring a Collector archive.

•	The login details for the database administration user are available.

Note:

For Microsoft SQL Server 2008 R2, you cannot create the repository directly from Control Center if the password contains certain characters. For example: [] {}() , ; ? * ! @ For more information, see: http://msdn.microsoft.com/en-us/library/ms161962.aspx

•	If you use a named instance of SQL Server, the SQL Server Browser service must be started.

Post requisites

Do a sanity check to make sure the repository was created according to your configurations.

To create a repository from Control Center

1	Right-click the Repositories folder and select Create Database. The Create Database dialog box opens.

2	In the Operation area, select Create now.

3	Select the repository.

4	Click Start to run the scripts. The Connect dialog box opens.

5	Enter the user name and password for the database administration user.

6

Click OK.