When trying to enter the location of the backups on the Contributor Admin Console in Datastore Options>Datastore Maintenance>Datastore Backup the user is unable to select the location when selecting the browse option. or Warning message when creating an application in Deployment Wizard or from Analyst or importing an application during an upgrade.
Unable to get list of drives
In planningerrorlog.csv, and on-screen when using Deployment Import:
Unable to connect to <databasename> using SQL Server Data Manipulation Objects (SQLDMO)~~~~Unable to create the object with ProgID 'SQLDMO.SQLServer'~~~~ActiveX component can't create object
SQL Server client tools are not installed, or insufficient permissions have been granted to Extended Stored Procedures in the 'Masters' database for the SQL server account in use, SQL SRVR 2005 backwards compatibility components not installed.
Diagnosing The Problem
See generated errors
Resolving The Problem
Install the SQL Server Client tools (if this has not already been done).
NB For SQL Server 2005 you need to have the full SQL Client installed (comes with SQL Express) as the Native Client does not install all of the required .dll files.
For SQL Server 2008 full client tools required.
Once the SQL Server Client tools are installed, ensure that the Contributor user account used to connect to SQL Server has EXEC permissions to the following Extended Stored Procedures in the Masters Database:
1. Open SQL Server Enterprise Manager.
2. Expand the Master database and select users.
3. Right-click the user that is used by Contributor to connect to the database, and select 'Properties'.
4. On the 'General' tab, select 'Permissions'.
5. Select the check box in the EXEC column for xp_availablemedia and xp_subdirs.
In SQL Server 2005, you will find these extended stored procedures in Databases\System Databases\master\Programmability\Extended Stored Procedures\System Extended Stored Procedures.
IBM Cognos Planning uses a DMO (Distributed Management Objects) method that calls xp_availablemedia to browse drives, and with SQL 2005, the user account needs to be a member of the SysAdmin role; or to have permissions to xp_availablemedia and xp_subdirs, to perform this action.
For 2008 from the EP 8.4.1 Install Guide (omitted from C10.1 Install Guide):
In addition to the client tools, you need to install the Microsoft® SQL Server 2005 Backward
Tip: On the Microsoft download Web site, search for SQL Server Feature Pack, and then sort by
Release Date to find the latest version.
You need to install the following Microsoft SQL Server 2005 Backward Compatibility Component:
● SQL Distributed Management Objects (SQL-DMO)
Internal Use Only
Total SRs: 55 References: 11-101584806 11-85128651 1185442 1185907 1202905 1204439 1207532 1215266 1218330 1218946 2303665 2306643 2335622 2337551 2338239 2360740 2372305 2374227 2374793 2388827 3196607 3247721 3265698 3268002 3278705 3310471 3311472 3311498 3319098 3319407 3330913 3363291 3375379 3375573 3384654 3405649 3412930 3413104 3413387 3419843 3425508 3429862 3431567 3436114 3436711 3438154 3439176 3441222 3449239 3452761 3455865 3458363 3463743 3465905 3466232
one of the causes as well is expiry of MS SQL client tools
15 June 2018