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

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: