Creating a repository from Control Center (Microsoft SQL Server)

Prerequisites

•	The runtime repository is configured in the Application Domain Editor. See Creating and configuring an application domain.

•	The the login details for the system administration user (sa) 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 application domain 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.