IBM Support

Error: Unable to get list of drives with SQL Server 2012

Troubleshooting


Problem

Error: Unable to get list of drives with SQL Server 2012 When trying to enter the location of the backups on Contributor Admin Console in Datastore Options>Datastore Maintenance>Datastore Backup. User is unable to select the location with browse option.

Symptom

"Unable to get list of drives" and after backward compatibility installed "Subscript out of range"

Environment

SQL Server 2012 Full client, SQLDMO, Microsoft SQL Server 2005 and 2008
backward compatibility are installed

Resolving The Problem

Contributor Datastore server connection check Trusted Connection instead of login with an account

[{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21986012