Support for multiple Database Server Instances is now implemented in RDBMS ZenPack. DBSrvInst class defined basic database server instance and can be used by another ZenPacks (MsSQLMon_ODBC for now).
MsSQLMon_ODBC ZenPack was tested against MS SQL 2005 and MS SQL 2005 64-bit. I think it will work with MS SQL 2008 too, but not with MS SQL 2000.
Both ZenPacks are BETA quality, so don't use it in production environment
- if you are using old version of RDBMS ZenPack remove all database components from all servers and remove RDBMS and MsSQLMon_ODBC ZenPacks.
- Install RDBMS ZenPack
- Install MsSQLMon_ODBC ZenPack
- set zMsSqlSrvInstances zProperty (space separated list of instances names)
- add community.odbc.MsSqlDatabaseMap to Modeler Plugins list
- remodel your server