Client Connections Using Vhost\Instance Instead of Vhost,Port

Summary

When client computers try to connect to a virtualized instance of Microsoft SQL Server from outside of the DxEnterprise cluster they can only connect using Vhost,Port instead of Vhost\Instance.

Information

This behavior is not specific to DxEnterprise, but to Microsoft SQL Server itself. Client connections outside of the DxEnterprise cluster will need to have an alias created in order to make connections to Vhost\Instance.

To create an alias on a client computer:

1. Open the Microsoft SQL Server Client Tools (Run > cliconfg.exe)

2. Enable the TCP/IP protocol

3. Select the Alias tab and click Add

4. Set the Server alias to Vhost\Instance (For example: "vsql1\inst1" where "vsql1" is the name of the Vhost and "inst1" is the name of the instance)

5. Under Network libraries select TCP/IP

6. Under Connection parameters set the Server name to the name of the Vhost

7. Deselect Dynamically determine port and set the Port number to the configured port of the virtualized instance

Now the client computer can connect to the virtual instance using a Vhost\Instance connection string.

Additional Information

• DxEnterprise Admin Guide
• Microsoft - Create or delete a server alias for use by a client