How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

(1) Share

Report

Posted on by cbk7944

While attempting to install CRM 2016 I am getting an error trying to download the SQL Native Client. Following the advice on other threads I turned off IE Enhanced Security Configuration but that hasn't worked. Any help would be appreciated!

4353.error.jpg

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

saurabhtiwarii on at

Like (1)

Report
RE: How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

Hello,

This could be because of a pending server reboot activity, please try to reboot the server once and then initiate the installation again to see if you still observe this exception. If you do, please check the installation log files to understand what exactly could be going wrong here.

SystemDrive:\Users\User\AppData\Roaming\Microsoft\MSCRM\Logs\

docs.microsoft.com/.../troubleshooting-installation-and-upgrade

==============================================================================

Updating this thread today in 2021 since we would expect more hits on this page, considering the fact that the below link for SQL Native Client (SQLNCLI) is down, may be as a result of it's depreciation

Error Log ::

14:32:10| Info| Requesting download of SQL Native Client installer from go.microsoft.com/.../
14:32:10| Error| SQL Native Client did not download successfully. To try again, ensure your internet connection is working, then try again.
14:32:10| Error| hr=0xc0040202

http://go.microsoft.com/fwlink/?LinkId=178252&clcid=0x409 ---> https://download.microsoft.com/download/A/D/0/AD021EF1-9CBC-4D11-AB51-6A65019D4706/sqlncli.msi serves 404

The workaround would be to have this sqlncli file downloaded, stored and installed locally ::

1. Downlod the SQLNCLI file from here

https://www.microsoft.com/en-us/download/details.aspx?id=50402

2. Create these two highlighted directories within your CRM installation folder (Ideally, SQLNativeClient would be placed under Redist folder but ProcMon calls showed that SetupServer.exe expects it under SQLNativeClient in the root installation folder)

3. Place the downloaded Sqlncli file in the SQLNativeClient folder and rename the downloaded setup file to sqlncli_x64.msi

4. I will recommend copying this SQLNativeClient folder to the Redist folder as well and then re-do the installation which should work just fine.

SQL Native Client fatal error/exception on local installation ::

Now, there are chances that the installtion might still fail with a fatal error/exception, ensure that there are no pending server restart. If the RESTART doesn't help, uninstall existing SQL Native Client from program and features if there are any, redo the installation of SQL Native Client using the above dowloaded sqlnci file to finally retry the installation and it should succeed as ::

Happy troubleshooting and stay safe!

Please mark my comment as answered if this helps.

Thanks,

Saurabh

Was this reply helpful? Yes No
Suggested answer

cbk7944 10 on at

Like (0)

Report

RE: How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

Thank you! I checked that error log and found the URL that it was attempting to access to download SQL Native Client. I went ahead and downloaded and manually installed the SQL client and the error cleared up. Thanks again!

Was this reply helpful? Yes No
cbk7944 10 on at

Like (0)

Report

RE: How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

Maybe you can help me with one more thing. I'm at the last step before the install starts, but I'm getting this error: [DBNETLIB][ConnectionOpen (SECDoClientHandshake().]SSL Security Error. I verified that the user has admin permissions to the database and that TLS 1.0 is enabled on both my front end server and database but neither has worked.

Was this reply helpful? Yes No
Sanchit 55 on at

Like (0)

Report

RE: How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

Hi, I have followed all these steps and ran sqlncli_x64.msi manually.

I can see that the SQL Native Client is installed in the server.

Also, restarted server multiple times and tried running the msi and installed / uninstalled multiple times.

I created 2 folders Redist, SQLNativeClient as you suggested.

However I am facing same issue still.

As soon as I run MS CRM 2016 setup, in the 'Download and Install Required Components' popup, it shows SQL native client and upon click on install, its going to internet to find the msi.

--------------------------------------------------------------------------------

Fiddler response below :

HTTP/1.1 302 Moved Temporarily

Location: download.microsoft.com/.../sqlncli.msi

--------------------------------------------------------------------------------

CRM server setup log at ..\AppData\Roaming\Microsoft\MSCRM\Logs :

Download components now?, Question, Yes|No

18:07:17| Info| InputResult: Yes

18:07:17| Info| Initializing COM.

18:07:17| Info| Initialized COM.

18:07:17| Info| Requesting download of SQL Native Client installer from go.microsoft.com/.../

18:07:18| Error| SQL Native Client did not download successfully. To try again, ensure your internet connection is working, then try again.

18:07:18| Error| hr=0xc0040202

18:07:18| Info| Uninitializing COM.

18:07:18| Info| Uninitialized COM.

--------------------------------------------------------------------------------

If someone can help soon, will be great

Thanks in advance

Was this reply helpful? Yes No
Suggested answer

saurabhtiwarii on at

Like (0)

Report

RE: How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

Hey Sanchit - Where have you created these two new directories? Create it under the installation files folder. I will recommend downloading the installation files again from the below link. Extract the installation file to the C drive in a new folder like CRM 2016 or so and then create the above requested directories to put the SQL Native Client installer files for offline installation. Please make sure that the files and folders name are exactly as it has been noted up there

www.microsoft.com/.../details.aspx

Was this reply helpful? Yes No
Muhammad Muddassir 10 on at

Like (0)

Report

RE: How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

Hi saurabhtiwarii .

Thanks for the input. I would just like to add up few lines in your convention as some might get confused.

Please make sure that while renaming the SQLNCLI file from the download, just write sqlncli_x64, and nothing else. It will add the msi by default.

Thanks

Was this reply helpful? Yes No
Muhammad Muddassir 10 on at

Like (0)

Report

RE: How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

Hi

Please make sure that while renaming the SQLNCLI file from the download, just write sqlncli_x64, and nothing else. It will add the msi by default.

Thanks

Was this reply helpful? Yes No
MrIzaak 5 on at

Like (0)

Report

RE: How to fix "Download Failed" for SQL Native Client error during installation of CRM 2016 on-premise

Solution worked for me, but I needed to put the SQL Native Client folders under the "Server" folder of the installation media rather than in the root folder.

Was this reply helpful? Yes No