10
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!
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
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
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
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
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.
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!
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (