You must pre-create the publishing tool database only if you are using a remote database or a local database on a computer running SQL Server 2005 64bit. If you are using a local database on a 32-bit edition of SQL Server 2005 database or a local SQL Server 2005 Express Edition, you do not need to perform this procedure.

The following procedure provides the steps necessary to create the database on a remote SQL Server 2005 computer and allows database access to the user installing the Custom Updates Publishing Tool.

To create and configure a remote Custom Updates Publishing Tool database

  1. Navigate to the <CD Location>\ITCU\PubTool 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 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 MS_Custom_Updates_Publishing_Tool_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 system running Microsoft SQL Server 2005.

  7. If the user installing the Custom Updates Publishing Tool is not an administrator on the SQL Server computer, open the Object Explorer, expand 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 MS_Custom_Updates_Publishing_Tool_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 MS_Custom_Updates_Publishing_Tool_User is selected, and then click OK.

During the Custom Updates Publishing Tool 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 the Custom Updates Publishing Tool.

See Also