The System Center Updates Publisher database must be created before installing Updates Publisher if a remote database or a local database on a computer running SQL Server 2005 64-bit is used. When using a local database on a 32-bit edition of SQL Server 2005 or a local SQL Server 2005 Express Edition, this procedure is not required. The following procedure provides the steps necessary to create the database on a remote computer running SQL Server 2005 and allows database access to the user installing the Updates Publisher.

To create and configure a remote Updates Publisher database

  1. Navigate to the <CD Location>\SCUP folder.

  2. Copy the CreatePubToolDb.sql script to a folder on the SQL Server 2005 computer.

  3. Open the Microsoft SQL Server Management Studio console on the SQL Server computer by using an account that has permissions to create a new database.

  4. On the File menu, click Open, click File, browse to the saved SQL script, and then click Open.

  5. On the Query menu, click Execute to create the mscuptdb database and the System_Center_Updates_Publisher_User database role.

  6. When the script completes, refresh the System Databases node and verify that the new database displays.

    Important
    Modification of the script is not supported. The database must be created on a computer running Microsoft SQL Server 2005.

  7. If the user installing the Updates Publisher is not an administrator on the SQL Server computer, open Object Explorer, expand the Security node, and then click Logins.

    If the user account is listed under the Logins node:

    1. Right-click the user, and then click Properties.

    2. In the Select a page section, click User Mapping.

    3. In the Users mapped to this login section, ensure that mscuptdb is selected.

    4. In the Database role membership for: mscuptdb section, ensure that System_Center_Updates_Publisher_User is selected, and then click OK.

    If the user account is not listed under the Logins node:

    1. Right-click the Logins node, and then click New Login.

    2. Enter the name of the user, or click Search to browse for the user.

    3. Click User Mapping from the Select a page section.

    4. In the Users mapped to this login section, ensure that mscuptdb is selected.

    5. In the Database role membership for: mscuptdb section, ensure that System_Center_Updates_Publisher_User is selected, and then click OK.

During the Updates Publisher Setup, the connection to the SQL Server 2005 computer is verified. If the proper permissions for the user account have been configured and the mscuptdb database is present, Setup continues. Otherwise, the Unable to verify the database connection with the provided information error message displays. For more information about how to troubleshoot common issues, see Troubleshooting Updates Publisher.

See Also