How to install SQL Native Client - Revision history

Konstantinos Kontogiannis at 13:06, 19 November 2014

2014-11-19T13:06:37Z

Konstantinos Kontogiannis at 13:02, 19 November 2014

2014-11-19T13:02:46Z

Konstantinos Kontogiannis at 13:02, 19 November 2014

2014-11-19T13:02:17Z

Konstantinos Kontogiannis: Created page with "
{{up}} How to collection and tutorials for OpenScape Deployment Service
When DLS is used with a remote database the SQL Native Client is ..."

2014-11-19T13:01:51Z

Created page with "<div class="breadcrumb"> {{up}} How to collection and tutorials for OpenScape Deployment Service </div> When DLS is used with a remote database the SQL Native Client is ..."

New page

<div class="breadcrumb">
{{up}} [[How to collection and tutorials for OpenScape Deployment Service]]
</div>

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.

'''Note: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.

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

3. Continue the installation until completion.

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

- If MS SQL was uninstalled but DLS installer says MS SQL available:

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

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

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

* 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

← Older revision		Revision as of 13:06, 19 November 2014
Line 35:		Line 35:

	* Remove registry entry according to the following:		* 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	+	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)

← Older revision		Revision as of 13:02, 19 November 2014
Line 27:		Line 27:

	* In registry (regedit) remove HKLM\Software\Microsoft\Microsoft SQL Server (HKEY_LOCAL_MACHINE)		* In registry (regedit) remove HKLM\Software\Microsoft\Microsoft SQL Server (HKEY_LOCAL_MACHINE)
−

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

@@ Line 26: / Line 26: @@
 - If MS SQL was uninstalled but DLS installer says MS SQL available:
- * In registry (regedit) remove HKLM\Software\Microsoft\Microsoft SQL Server (HKEY_LOCAL_MACHINE)
+* In registry (regedit) remove HKLM\Software\Microsoft\Microsoft SQL Server (HKEY_LOCAL_MACHINE)
- * Delete complete folder \Microsoft SQL Server in \Program Files folder on local drive.
+* Delete complete folder \Microsoft SQL Server in \Program Files folder on local drive.
- * Reboot (important since some SQL processes could still be actively running)
+* Reboot (important since some SQL processes could still be actively running)
- * 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.
+* 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:
+* 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

How to install SQL Native Client - Revision history

Konstantinos Kontogiannis at 13:06, 19 November 2014

Konstantinos Kontogiannis at 13:02, 19 November 2014

Konstantinos Kontogiannis at 13:02, 19 November 2014

Konstantinos Kontogiannis: Created page with " {{up}} How to collection and tutorials for OpenScape Deployment Service When DLS is used with a remote database the SQL Native Client is ..."

Konstantinos Kontogiannis: Created page with "
{{up}} How to collection and tutorials for OpenScape Deployment Service
When DLS is used with a remote database the SQL Native Client is ..."