sql-serverwindows-10sql-server-2014-express

Problems with installing Microsoft SQL Server 2014


I am getting following error while trying to install Microsoft SQL Server 2014. If anyone knows how is this fixed I'd be grateful for help.

Screenshot of the error

TITLE: Microsoft SQL Server 2014 Setup

Error reading from file C:\Users\aldin\Downloads\SQLEXPR_x64_ENU\x64\setup\sql_engine_core_shared_msi\PFiles32\SqlServr\120\DAC\bin\hcx5y0yq.dll. Verify that the file exists and that you can access it.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

Thanks in advance

I see that many of you put (-) on this question, I am currently learning about databases, tried installing sql server 3 times, 3rd time same error, restarted my laptop and did everything again, nothing changes.


Solution

  • The file really might not be there. Or it might be corrupt. The first thing to try is to get a new copy of the media. Unblock it after the download if required.

    https://www.microsoft.com/en-US/download/details.aspx?id=42299

    When you run it, it will want a location to extract the files. Put it in a location to which you have full access. The setup dialog will open automatically. If not, run the setup.exe in the top level of the folder you extracted. This might be all that you need.

    There is a "Tools" option for "Installed SQL Server features discovery report" that might be of use. If other editions of SQL 2014 are already present, they can be a problem...but not the problem you have yet. (I never install express because it can cause issues installing DEV or STD editions. It might become an upgrade instead of an install.)

    The SQL 2019 DEV edition is free and can be found at https://www.microsoft.com/en-us/sql-server/sql-server-downloads. The discovery report in 2019 will be more inclusive (all versions up to 2019).

    Check the "C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log" to see if there is more info in the log files. The Summary.txt file will be the short version for the last run of setup.exe. Sometimes there will be instructions on what to do (e.g., uninstall and retry).

    Also check the Event Logs for messages that might relate to the install.

    Sometimes a virus checker can quarantine valid files.

    If it really is permissions, then try taking ownership (recursively) of the install media.

    There are endless reasons for things to fail. I hope it's just bad media.