How to use the SQL Server 2005 CMS database for Business Objects XI.

Document ID : KB000054061
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

Example of setting up a SQL Server 2005 CMS database for Business Objects XI (BOXI).

This eliminates the need to use MySQL for this aspect, which is the default installation method.

Solution

  1. Log into SQL Server Management Studio as a user who is able to create databases and logins.

    In the following instructions, replace [db server] with the database server you are hosting the database on.

  2. In the tree in the left hand pane, expand [db server] -> Security. Right click on "Logins" and select "New Login...".

  3. In the "Login - New" window, enter a name for the login in "Login name:". In this example "cmslogin" is used. Select "SQL Server authentication" and fill in the "Password" and "Confirm Password" fields with a password. Uncheck "enforce Password policy". Select "OK".

  4. In the tree in the left hand pane, expand [db server] -> Databases and select "New Database..."

  5. In the "New Database" window, enter a name for the database in the "Database Name" field. This example uses "cmsdb." Select OK.

  6. Expand [db server] -> Databases -> "cmsdb" -> Security, right click on "Users" and select "New User..."

  7. In the "Database User - New" window, enter a user name in the "User name" field. I will use "cmsuser" in this example. In "Login name", select "cmslogin". In both "Owned Schemas" and "Role Members", check "db_accessadmin", "db_owner" and "db_securityadmin".

  8. In the tree in the left hand pane, expand [db server] -> Security -> Logins. Right click on "cmslogin" and select "Properties"

  9. In the "Login Properties - cmslogin" window, select "General" in the "Select a page" list. Set "Default database" to "cmsdb." Select "User Mapping" in the "Select a page" list. In the "Users mapped to this login" list, make sure "cmsdb" "cmsuser" is selected. No other users need to be mapped here. Check that "db_accessadmin," "db_owner" and "db_securityadmin" are checked in "Database role membership for: cmsdb." Select "OK".

  10. Exit Microsoft SQL Server Management Studio.

  11. On the Server where you plan to install Business Objects, go to Administrative Tools -> Data Sources (ODBC).

  12. In the "ODBC Data Source Administration" window, select the "System DSN" tab. Select the "Add..." button.

  13. In the "Create New Data Source" window, select "SQL Server" from the list and select the "Finish" button.

  14. In the "Create New Data Source to SQL Server" window, enter a name for the DSN in "Name:" field. In this example "cms" is used. Enter [db server] in the "Server:" field. Select "Next >".

  15. Select "With SQL Server authentication using a login ID and password entered by the user." Check "Connect to SQL Server to obtain default settings for the additional configuration options." Enter "cmslogin" and the login password in "Login ID:" and "Password:" respectively. This is the login created in step 3 above. Select "Next."

  16. Check "Change the default database to" and set the database to "cmsdb". This is the database created in step 5. Select "Next."

  17. Select Finish.

  18. In the "ODBC Microsoft SQL Server Setup" window, press "Test Data Source". If "TESTS COMPLETED SUCCESSFULLY!" appears then the procedure has been successful. Press "OK" three times to finish.