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.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.
Friday, January 21, 2011
Fix SQL-Server 2008 R2 "network error occurred" SQLNCLI file x64
I was just installing SQL-Server 2008R2 Management Studio (SSMS) Client Tools and SQLNCLI 10.5 on a Windows-7 Professional x64 (64-bit) machine when I ran into a very uninformative, or clearly misleading, error message during the install procedure that stated (something close to this):
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.