Views

How to configure SQL Native Client

The Wiki of Unify contains information on clients and devices, communications systems and unified communications. - Unify GmbH & Co. KG is a Trademark Licensee of Siemens AG.

Jump to: navigation, search


When DLS is used with a remote database the SQL Native Client is required to be installed. Therefore, if SQL Native Client does not exist in the system then it is required to be installed prior to the installation of the DLS.

The SQL native client that is installed prior to the SQL should match the version of the SQL to be installed.

There are two (2) DLS configurations where remote database is used :

  • Single-node with remote database
  • Multi-node with remote database

For multi-node configurations the SQL native client needs to be installed in every node. The installation of the Native Client must be executed separately. Native Client is required for both 32bit and 64bit operating systems. Furthermore, Native Client is also required if either the environment consists of domains or workgroups.

1. Start the setup program.

NativeClient.jpg

2. Follow the instructions in the particular screens and click Next. In the Feature Selection screen, select SQL Server Native Client SDK.

NativeClientSDK.jpg

3. Continue the installation until it is completed.

If problems with DLS new installations occur after DLS and MS SQL were uninstalled before over the same machine, please consider the following:

1. If MS SQL was uninstalled but DLS installer says MS SQL available:

a. In registry (regedit) remove HKLM\Software\Microsoft\Microsoft SQL Server (HKEY_LOCAL_MACHINE)


b. Delete complete folder \Microsoft SQL Server in \Program Files folder on local drive.


c. Reboot (important since some SQL processes could still be actively running)


2. If error during SQL installation occurs, check log file Detail_ComponentUpdate.txt (e.g.: ..\Microsoft SQL Server\100\Setup Bootstrap\Log\20110225_092344) for exception "MsiGetProductInfo failed to retrieve ProductVersion for package" where a GUID mentioned.

Remove registry entry according to the following:

Take the GUID 2243F21A-E132-44F7-BA13-024D0845C815 and used the first part of it 2243F21A, then reverse that to be A12F3422 and searched within the registry key HKCR\Installer\UpgradeCodes for matches (HKEY_CLASSES_ROOT)