search cancel

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

book

Article ID: 53758

calendar_today

Updated On:

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