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

Document ID : KB000053758
Last Modified Date : 14/02/2018
Show Technical Document Details

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%