search cancel

Unable to check MS SQL Server version error using DsmMsSqlOpt.bat

book

Article ID: 216503

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

While running DsmMsSqlOpt.bat script locally on the DM server (which also has the MDB installed locally), it fails with error "Unable to check MS SQL Server version":

Environment

Client Automation - All versions

Resolution

The script can be executed running different flags, as per:

Microsoft SQL Server MDB Maintenance

One of them is used to define the server where the MDB is located. On this case, since it's installed locally, the flag 'local' can be added to run it successfully:

Attachments