How to run DsmMsSqlOpt.bat on Ms SQL 2005 when not using "default" instance and default MS Sql port 1433?

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA Server Automation

Issue/Introduction

Description:

How should the 'DsmMsSqlOpt.bat' script be executed on MDB server with MS SQL 2005. The "Implementation Guide" describe how to run it on a MDB server with MS SQL 2000, with the parameters "-maxfrag=30 -userindex", is this same for a version 2005?

Should there be any other parameters when not using the "default" instance and not using the "default" Ms Sql port? Cause we have a named instance and running are not running on standard port 1433.

Solution:

Run the script with the following parameter
\DsmMsSqlOpt.bat %hostname%\%instance%

Environment

Release:
Component: DTSVMG