Microsoft SQL Server 2008 Setup: The following error has occurred: A network error occurred while attempting to read from the file: [install-device-name--and-root-of-path-here]\x64\setup\x64\sqlncli[1].msiSince I was installing from an ISO image that I had just used to successfully do a *test* install into a VMware ESXi VM (Windows 2008 Server R2) prior to the real install on a physical machine, I instantly thought: "what the heck? bad image suddenly?... unlikely... network issues?... unlikely, as I have not had any others." Something was off. I wondered if there was an issue with the installer not liking the fact I was trying to install from an ISO that I had "mounted" as a virtual CDROM via UltraISO for this. So, I used 7-ZIP to explode the ISO into an install directory on my same server, and tried to install directly from this completely unpacked set of files.
The error persisted! Still getting that "The following error has occurred: A network error occurred while attempting to read from the file... SQLNCLI...". Hmmm... odd. And, annoying, as OBVIOUSLY THIS IS/WAS NOT A NETWORKING ERROR as the message describes! (thank you Microsoft! NOT!).
The cause of the error...
I wondered what was different between my clean test-VM and my server that I was now attempting to install SQL-SERVER 2008 R2 Client Tools and SSMS onto. Both were 64-Bit OS's and same setup, etc., but one was a clean VM. This got me thinking...
I had PREVIOUSLY installed JUST the SQLNCLI (SQL-Server Native Client) for SQL 2008 R2 onto my physical system, in order to test application connectivity to a SQL2008R2 database. So, could that be it!? YES! After uninstalling any previously installed SQLNCLI applications, and re-running the SQL-Server installer, amazingly my "network errors" were gone and the installation was fixed!
Microsoft: GIVE MEANINGFUL ERROR MESSAGES! All the installer had to do was say that "previous installations of SQLNCLI / native client exist and must be removed before installing"... in fact, the PREREQUISITES-CHECK SHOULD HAVE TESTED FOR THIS if it can cause a total failure to install!
This may affect SQL-Server Express Edition installs as well. I was doing a SQL-Server 2008 Enterprise install, but I would bet the installer code is the same... whether standard edition, enterprise edition, express edition, or developer edition 2008 R2.
I do not know if this only affects x64 (64-bit) installs or x32 (32-bit) as well, but perhaps if you encounter a similar problem, this article may help. I was able to confirm the error occurs installing on Windows-7 Professsional 64-bit x64, so good luck and get past this quickly.
14 comments:
Thanks - same issue here. Your resolution worked for me. SQLNCLI was the give-away.
Ran into this problem today. Nearly identical situation. Thanks for the help.
Thanks, this fixed my issue.
Same error and same solution also for Win 2003 x32. ;)
Thank you!
L.
Thanks! That solved my problem.
Oh. And it's worth mentioning that you remove it using the add/remove programs feature in the control panel. And my machine is a 32 bit machine.
Thanks. I ran into the same issue with SQL Server Express 2008 R2 Advance on a 64 bit Win 7 Enterprise machine. The fix worked for me. Ditto for the stupid Microsoft error message.
Same for me. Installing 2008 R2 x64 express on a Win7 Ultimate x64 box. I got the native client from a GreatPlains 2010 install.
Thanks for posting this
thank you from Singapore
As above, I had the Native client installed due to a GP install. Then tried to install the Sql Server Manangement tools from a mounted ISO and came accorss this stupid error message.
Remove the client first solved my problem. Thanks.
Many thanks for this one. It solved the issue for me!
Thanks! I was getting the network error too, but I was working locally. This solved the problem.
Cool Story Bro!
Thanks, that helped!
Saved some hours for me
Benni
Post a Comment