Go Back

SQL Server on a Windows cluster and SQL Connection

Article Number: 0654
First Published:
Modified:
Recent Activity:
Views: 21
OS: Windows
Product: SQL Connection

Neither SQL Connection nor SQL OpenNet have features that use Windows clustering (MCSC), but customers have been successfully connecting to SQL Server databases on Windows clusters. To do this, run SQL OpenNet on a single node of the cluster and do one of the following:

  1. Use the "Enable shared memory protocol" option for SQL Server, and specify "Network=dbmslpcn" in the connect string. (Note that this requires the VTX12_SQLNATIVE driver.)
  2. Specify the server machine\'s IP address or name as the server in the database_info portion of the connect string and (for SQL OpenNet connections) as the host name in the network string (opennet_info).


For information on connect string arguments, see "Building Connect Strings" in the Synergy/DE documentation.


Again, this doesn\'t provide failover support. For failover support, use SQL Server client rather than SQL OpenNet, and for SQL Server versions 2003 and above, use the VTX12_SQLNATIVE driver. Otherwise use VTX12_ODBC.

Note that tests indicate that SQL OpenNet provides better performance than connections that use the SQL Server client.

 



THE INFORMATION PROVIDED TO YOU IN THIS SERVICE IS FOR YOUR USE ONLY. THE INFORMATION MAY HAVE BEEN DEVELOPED INTERNALLY BY SYNERGEX OR BY EXTERNAL SOURCES. SYNERGEX MAKES NO WARRANTIES, EXPRESS OR IMPLIED, REGARDING THIS INFORMATION, INCLUDING THE WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SYNERGEX BE LIABLE FOR ANY DAMAGES OR LOSSES INCURRED BY YOU IN USING OR RELYING ON THIS INFORMATION, INCLUDING WITHOUT LIMITATION GENERAL DAMAGES, DIRECT, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES, OR LOSS OF PROFITS, EVEN IF SYNERGEX HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
Please log in to comment on this article.