Creating a repository from Control Center (Microsoft® SQL Server®)

Prerequisites

•	The connection settings to the enterprise repository are configured. See Configuring the connection settings for StreamServe Enterprise Repository.

•	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 Microsoft 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 site node 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.

After creating an enterprise repository, the management gateway automatically tries to connect to the new enterprise repository.