Support Portal

Welcome, Guest Login

Support Center

Client Connections Using VHost\Instance Instead of VHost,Port

Last Updated: Jul 17, 2017 04:04PM PDT

Applies to...

  • DxEnterprise 15.0
  • DxEnterprise 15.5
  • DxEnterprise 16.0
  • DxEnterprise 17.0
  • DxConsole
  • Microsoft SQL Server

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.

References

DxEnterprise Administration Guide - Configure SQL Server Clients - Page 40

http://blogs.technet.com/b/meamcs/archive/2013/01/22/creating-a-sql-server-alias-using-the-sql-server-client-network-utility.aspx

Contact Us

support.desk@dh2i.com
http://assets1.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete