3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Chapter 5: Configuration and Operation 80

MxDB for SQL Server can virtualize MSDTC only when the Default

Coordinator for MSDTC is set to “Use local coordinator” on the nodes

configured for the Virtual SQL Server. If a Remote Host is specified as the

Default Coordinator, MxDB cannot virtualize MSDTC.

Enable/Disable a Virtual SQL Server

A Virtual SQL Server may be left in a disabled state after it is moved via a

“drag and drop” operation. Use the Enable feature to re-enable the

Virtual SQL Server. To do this, select the Virtual SQL Server on the

PolyServe Management Console, right-click, and select Enable on All

Servers.

You can also disable a Virtual SQL Server if necessary. select the Virtual

SQL Server on the PolyServe Management Console, right-click, and select

Disable on All Servers.

To enable or disable a Virtual SQL Server from the command line, use

these commands:

mx vsql enable <vsql>

mx vsql disable <vsql>

Delete a Virtual SQL Server

To remove a Virtual SQL Server, select it on the PolyServe Management

Console, right-click, and select Delete.

NOTE: If the Virtual SQL Server had been rehosted, the SQL instances

associated with the Virtual SQL Server will be unusable after the

Virtual SQL Server is deleted. This situation occurs because the

rehost operation changes the SQL registry settings. If you want to

continue to use the SQL instances, you will need to reinstall them.

To delete a Virtual SQL Server from the command line, use this

command:

mx vsql delete <vsql>