I'm attempting to install SQL Server 2014 Express on a Windows Server 2012 R2 system. When I do the install, it fails (several times) with an "Error: 997. Overlapped I/O operation is in progress.". From searching the web, I can see many people have had this problem with this installer and other non-SQL server installers.

I've tried every solution I can find discussed, but none help with my problems The system is fully updated, with the exception of the KB2538243 (VC 2008 SP1 redist), which is probably failing for the same reason.

I've tried removing several updates mentioned in other articles (KB2918614). I've confirmed that I'm not using a temporary profile.

Does anyone have an idea of how I can solve this issue?

Thanks,

Zack

Partial detail from install log file:

Detailed results:

  Feature:                       Management Tools - Complete
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                Microsoft Visual Studio 2010 Redistributables
  Component error code:          997
  Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20150205_151618\VC10Redist_Cpu64_1.log
  Error description:             Error 997.Overlapped I/O operation is in progress.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=vc_red.msi%40ProcessComponents%40997

  Feature:                       Client Tools Connectivity
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                Microsoft Visual Studio 2010 Redistributables
  Component error code:          997
  Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20150205_151618\VC10Redist_Cpu64_1.log
  Error description:             Error 997.Overlapped I/O operation is in progress.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=vc_red.msi%40ProcessComponents%40997

Partial detail from component log file:

Hi zerhart2,

After uninstalling KB2918614, please make sure you have reboot your server. And please manually install the following Visual C++ 2010 Redistributable Package (choose the correct version), then check if you can install SQL Server successfully.

Microsoft Visual C++ 2010 Redistributable Package (x64)

Microsoft Visual C++ 2010 Redistributable Package (x86)

In addition, I recommend you check the following things.
 
 1. Run SQL Server setup file locally on your computer and make sure that you choose Run as administrator to run the setup.

 2. Disable any Anti-virus and reboot your computer.

 3. Check for any problems with disk drive where you are installing SQL Server files.


Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.

Hello,

As you can read on the following post this is a known issue.

http://blogs.msdn.com/b/vsnetsetup/archive/2014/10/27/error-997-overlapped-i-o-operation-is-in-progress-kb2918614-breaks-windows-installer-service.aspx

Please apply the following fix.

http://support.microsoft.com/kb/3000988  Please click on the Hotfix Download Available button.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Friday, February 06, 2015 4:07 PM

Lydia,

Thanks for your response. The server has been rebooted after uninstalling the KB2918614 update. I tried running the VC redist install you linked, but I get the same errors as mentioned in the original message. I did run them as administrator and don't have any antivirus software running. Windows doesn't indicate there are any problems with the drive.

Any other ideas?

Thanks!

The log files from this attempt are below:

Hello,

As you can read on the following post this is a known issue.

http://blogs.msdn.com/b/vsnetsetup/archive/2014/10/27/error-997-overlapped-i-o-operation-is-in-progress-kb2918614-breaks-windows-installer-service.aspx

Please apply the following fix.

http://support.microsoft.com/kb/3000988  Please click on the Hotfix Download Available button.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Friday, February 06, 2015 4:07 PM

Alberto,

Thanks for your help. Unfortunately, I've already tried that. I did try it again and I get an "This update is not applicable to your computer."

I tried to post the Windows Update log, but it was too large. I've posted some of it below.

Here is the WU log:

2015-02-06 11:24:25:793 5048 50 Misc ===========  Logging initialized (build: 7.9.9600.17489, tz: -0500)  ===========
2015-02-06 11:24:25:793 5048 50 Misc  = Process: C:\Windows\system32\wusa.exe
2015-02-06 11:24:25:793 5048 50 Misc  = Module: C:\Windows\System32\wuapi.dll
2015-02-06 11:24:25:793 5048 50 COMAPI -----------  COMAPI: IUpdateServiceManager::AddScanPackageService  -----------
2015-02-06 11:24:25:793 5048 50 COMAPI  - ServiceName = Windows Update Standalone Installer
2015-02-06 11:24:25:793 5048 50 COMAPI  - ScanFileLocation = C:\c5f288db3c43a7e4613232ca1a3c\wsusscan.cab
2015-02-06 11:24:25:808 920 111c Misc ===========  Logging initialized (build: 7.9.9600.17489, tz: -0500)  ===========
2015-02-06 11:24:25:808 920 111c Misc  = Process: C:\Windows\system32\svchost.exe
2015-02-06 11:24:25:808 920 111c Misc  = Module: c:\windows\system32\wuaueng.dll
2015-02-06 11:24:25:808 920 111c Service *************
2015-02-06 11:24:25:808 920 111c Service ** START **  Service: Service startup
2015-02-06 11:24:25:808 920 111c Service *********
2015-02-06 11:24:25:824 920 111c IdleTmr Non-AoAc machine.  Aoac operations will be ignored.
2015-02-06 11:24:25:824 920 111c Agent  * WU client version 7.9.9600.17489
2015-02-06 11:24:25:824 920 111c Agent WARNING: SleepStudyTracker: Machine is non-AOAC. Sleep study tracker disabled.
2015-02-06 11:24:25:824 920 111c Agent  * Base directory: C:\Windows\SoftwareDistribution
2015-02-06 11:24:25:824 920 111c Agent  * Access type: No proxy
2015-02-06 11:24:25:824 920 111c Service UpdateNetworkState Ipv6, cNetworkInterfaces = 12.
2015-02-06 11:24:25:824 920 111c Service UpdateNetworkState Ipv4, cNetworkInterfaces = 4.
2015-02-06 11:24:25:824 920 111c Agent  * Network state: Connected
2015-02-06 11:24:25:824 920 111c Service UpdateNetworkState Ipv6, cNetworkInterfaces = 12.
2015-02-06 11:24:25:824 920 111c Service UpdateNetworkState Ipv4, cNetworkInterfaces = 4.
2015-02-06 11:24:25:855 920 b64 Misc WARNING: Network Cost is assumed to be not supported as something failed with trying to get handles to wcmapi.dll
2015-02-06 11:24:25:855 920 111c Agent ***********  Agent: Initializing global settings cache  ***********
2015-02-06 11:24:25:887 920 111c Agent  * Endpoint Provider: 00000000-0000-0000-0000-000000000000
2015-02-06 11:24:25:887 920 111c Agent  * WSUS server: <NULL>
2015-02-06 11:24:25:887 920 111c Agent  * WSUS status server: <NULL>
2015-02-06 11:24:25:887 920 111c Agent  * Target group: (Unassigned Computers)
2015-02-06 11:24:25:887 920 111c Agent  * Windows Update access disabled: No
2015-02-06 11:24:25:902 920 b64 WuTask WuTaskManager delay initialize completed successfully..
2015-02-06 11:24:25:902 920 b64 AU    Timer: 31DA7559-FE27-4810-8FF6-987195B1FD98, Expires 2015-02-07 08:14:01, not idle-only, not network-only
2015-02-06 11:24:25:902 920 b64 AU    Timer: CF1ABEC6-7887-4964-BB93-B2E21B31CEC1, Expires 2015-02-06 19:30:54, not idle-only, not network-only
2015-02-06 11:24:25:902 920 b64 AU    Timer: 29A863E7-8609-4D1E-B7CD-5668F857F1DB, Expires 2015-02-06 19:30:54, not idle-only, not network-only
2015-02-06 11:24:25:902 920 b64 Report WARNING: CSerializationHelper:: InitSerialize failed : 0x80070002
2015-02-06 11:24:25:902 920 b64 Report CWERReporter::Init succeeded
2015-02-06 11:24:25:902 920 b64 Agent ***********  Agent: Initializing Windows Update Agent  ***********
2015-02-06 11:24:25:902 920 b64 DnldMgr Download manager restoring 0 downloads
2015-02-06 11:24:25:902 920 111c AU ###########  AU: Initializing Automatic Updates  ###########
2015-02-06 11:24:25:902 920 111c AU AIR Mode is disabled
2015-02-06 11:24:25:902 920 111c AU  # Approval type: Scheduled (User preference)
2015-02-06 11:24:25:902 920 111c AU  # Auto-install minor updates: Yes (User preference)
2015-02-06 11:24:25:902 920 111c AU  # Will interact with non-admins (Non-admins are elevated (User preference))
2015-02-06 11:24:25:902 920 111c Misc WARNING:     IsSessionRemote: WinStationQueryInformationW(WTSIsRemoteSession) failed for session 2, GetLastError=2250
2015-02-06 11:24:25:918 920 111c AU WARNING: Failed to get Wu Exemption info from NLM, assuming not exempt, error = 0x80240037
2015-02-06 11:24:25:918 920 111c AU WARNING: Failed to get Network Cost info from NLM, assuming network is NOT metered, error = 0x80240037
2015-02-06 11:24:25:918 920 111c AU AU finished delayed initialization
2015-02-06 11:24:25:933 920 111c AU WARNING: Failed to get Network Cost info from NLM, assuming network is NOT metered, error = 0x80240037
2015-02-06 11:24:25:933 920 111c AU WARNING: Failed to get Network Cost info from NLM, assuming network is NOT metered, error = 0x80240037
2015-02-06 11:24:25:933 920 b64 Misc Validating signature for C:\Windows\SoftwareDistribution\ScanFile\a487aa0f-3e53-4fee-a784-6171b00254e4\Source.cab with dwProvFlags 0x00000080:
2015-02-06 11:24:25:933 920 111c AU Adding timer: 
2015-02-06 11:24:25:933 920 111c AU    Timer: 31DA7559-FE27-4810-8FF6-987195B1FD98, Expires 2015-02-07 08:14:01, not idle-only, not network-only
2015-02-06 11:24:25:949 920 af0 DnldMgr Asking handlers to reconcile their sandboxes
2015-02-06 11:24:25:949 920 b64 Misc Microsoft signed: Yes
2015-02-06 11:24:26:154 920 b64 DtaStor Default service for AU is {7971F918-A847-4430-9279-4A52D1EFE18D}
2015-02-06 11:24:26:154 920 b64 IdleTmr Incremented idle timer priority operation counter to 1
2015-02-06 11:24:26:154 5048 50 COMAPI  - Added scan package service, ServiceID = {A487AA0F-3E53-4FEE-A784-6171B00254E4} Third party service
2015-02-06 11:24:26:154 5048 50 COMAPI -------------
2015-02-06 11:24:26:154 5048 50 COMAPI -- START --  COMAPI: Init Search [ClientId = wusa]
2015-02-06 11:24:26:154 5048 50 COMAPI ---------
2015-02-06 11:24:26:154 5048 50 COMAPI -------------
2015-02-06 11:24:26:154 5048 50 COMAPI -- START --  COMAPI: Search [ClientId = wusa]
2015-02-06 11:24:26:154 5048 50 COMAPI ---------
2015-02-06 11:24:26:169 920 b64 IdleTmr WU operation (CSearchCall::Init ID 1) started; operation # 17; does use network; is not at background priority
2015-02-06 11:24:26:169 920 b64 IdleTmr Incremented idle timer priority operation counter to 2
2015-02-06 11:24:26:341 920 b64 Report ***********  Report: Initializing static reporting data  ***********
2015-02-06 11:24:26:341 920 b64 Report  * OS Version = 6.3.9600.0.0.131344
2015-02-06 11:24:26:341 920 b64 Report  * OS Product Type = 0x00000021
2015-02-06 11:24:26:357 920 b64 Report  * Computer Brand = PowerSpec
2015-02-06 11:24:26:357 920 b64 Report  * Computer Model = S Series
2015-02-06 11:24:26:357 920 b64 Report  * Platform Role = 1
2015-02-06 11:24:26:357 920 b64 Report  * AlwaysOn/AlwaysConnected (AOAC) = 0
2015-02-06 11:24:26:357 920 b64 Report  * Bios Revision = 1.1a
2015-02-06 11:24:26:357 920 b64 Report  * Bios Name = 1.1a
2015-02-06 11:24:26:357 920 b64 Report  * Bios Release Date = 2013-08-20T00:00:00
2015-02-06 11:24:26:357 920 b64 Report  * Bios Sku Number = S Series
2015-02-06 11:24:26:357 920 b64 Report  * Bios Vendor = American Megatrends Inc.
2015-02-06 11:24:26:357 920 b64 Report  * Bios Family = Server
2015-02-06 11:24:26:357 920 b64 Report  * Bios Major Release = 4
2015-02-06 11:24:26:357 920 b64 Report  * Bios Minor Release = 6
2015-02-06 11:24:26:357 920 b64 Report  * Locale ID = 1033
2015-02-06 11:24:26:357 920 b64 Handler Calculating current update level for this session

[ Omitted data ]

http://support.microsoft.com/?kbid=3000850, timestamp 01d039c57a22c0be
2015-02-06 11:24:28:388 920 b64 Handler Done calculating current update level for this session
2015-02-06 11:24:28:982 920 b64 Agent *** START ***  Queueing Finding updates [CallerId = wusa  Id = 1]
2015-02-06 11:24:28:982 5048 50 COMAPI <<-- SUBMITTED -- COMAPI: Search [ClientId = wusa]
2015-02-06 11:24:28:982 920 11f4 Agent ***  END  ***  Queueing Finding updates [CallerId = wusa  Id = 1]
2015-02-06 11:24:28:982 920 11f4 Agent *************
2015-02-06 11:24:28:982 920 11f4 Agent ** START **  Agent: Finding updates [CallerId = wusa  Id = 1]
2015-02-06 11:24:28:982 920 11f4 Agent *********
2015-02-06 11:24:28:982 920 11f4 Agent  * Online = Yes; Ignore download priority = No
2015-02-06 11:24:28:982 920 11f4 Agent  * Criteria = "DeploymentAction='Installation'"
2015-02-06 11:24:28:982 920 11f4 Agent  * ServiceID = {A487AA0F-3E53-4FEE-A784-6171B00254E4} Third party service
2015-02-06 11:24:28:982 920 11f4 Agent  * Search Scope = {Machine}
2015-02-06 11:24:28:982 920 11f4 Agent  * Caller SID for Applicability: S-1-5-21-3157695610-3447843402-2534478823-500
2015-02-06 11:24:28:982 920 11f4 Agent  * RegisterService is set
2015-02-06 11:24:29:185 920 11f4 PT +++++++++++  PT: Synchronizing server updates  +++++++++++
2015-02-06 11:24:29:185 920 11f4 PT  + Offline serviceId = {A487AA0F-3E53-4FEE-A784-6171B00254E4}
2015-02-06 11:24:29:185 920 11f4 PT WARNING: Cached cookie has expired or new PID is available
2015-02-06 11:24:29:185 920 11f4 Agent Reading cached app categories using lifetime 604800 seconds
2015-02-06 11:24:29:185 920 11f4 Agent Read 0 cached app categories
2015-02-06 11:24:29:185 920 11f4 Agent SyncUpdates adding 0 visited app categories
2015-02-06 11:24:29:294 920 11f4 Agent Reading cached app categories using lifetime 604800 seconds
2015-02-06 11:24:29:294 920 11f4 Agent Read 0 cached app categories
2015-02-06 11:24:29:294 920 11f4 Agent SyncUpdates adding 0 visited app categories
2015-02-06 11:24:29:357 920 11f4 Agent Reading cached app categories using lifetime 604800 seconds
2015-02-06 11:24:29:357 920 11f4 Agent Read 0 cached app categories
2015-02-06 11:24:29:357 920 11f4 Agent SyncUpdates adding 0 visited app categories
2015-02-06 11:24:29:638 920 11f4 Agent Reading cached app categories using lifetime 604800 seconds
2015-02-06 11:24:29:638 920 11f4 Agent Read 0 cached app categories
2015-02-06 11:24:29:638 920 11f4 Agent SyncUpdates adding 0 visited app categories
2015-02-06 11:24:30:013 920 11f4 Agent Reading cached app categories using lifetime 604800 seconds
2015-02-06 11:24:30:013 920 11f4 Agent Read 0 cached app categories
2015-02-06 11:24:30:013 920 11f4 Agent SyncUpdates adding 0 visited app categories
2015-02-06 11:24:30:044 920 11f4 Agent Reading cached app categories using lifetime 604800 seconds
2015-02-06 11:24:30:044 920 11f4 Agent Read 0 cached app categories
2015-02-06 11:24:30:044 920 11f4 Agent SyncUpdates adding 0 visited app categories
2015-02-06 11:24:30:044 920 11f4 PT  + SyncUpdates round trips: 5
2015-02-06 11:24:30:076 920 11f4 PT +++++++++++  PT: Synchronizing extended update info  +++++++++++
2015-02-06 11:24:30:076 920 11f4 PT  + Offline serviceId = {A487AA0F-3E53-4FEE-A784-6171B00254E4}
2015-02-06 11:24:30:138 920 11f4 Agent  * Found 0 updates and 54 categories in search; evaluated appl. rules of 126 out of 284 deployed entities
2015-02-06 11:24:30:138 920 11f4 Agent *********
2015-02-06 11:24:30:138 920 11f4 Agent **  END  **  Agent: Finding updates [CallerId = wusa  Id = 1]
2015-02-06 11:24:30:138 920 11f4 Agent *************
2015-02-06 11:24:30:138 920 11f4 IdleTmr WU operation (CSearchCall::Init ID 1, operation # 17) stopped; does use network; is not at background priority
2015-02-06 11:24:30:138 920 11f4 IdleTmr Decremented idle timer priority operation counter to 1
2015-02-06 11:24:30:154 5048 1428 COMAPI >>--  RESUMED  -- COMAPI: Search [ClientId = wusa]
2015-02-06 11:24:30:154 5048 1428 COMAPI  - Updates found = 0
2015-02-06 11:24:30:154 5048 1428 COMAPI ---------
2015-02-06 11:24:30:154 5048 1428 COMAPI --  END  --  COMAPI: Search [ClientId = wusa]
2015-02-06 11:24:30:154 5048 1428 COMAPI -------------

Hi zerhart2,

Please perform the following steps to manually modify registry entries and check if you can overcome the 997 error.
1.Click Start, click Run, type regedit in the Open box, and then click OK.

2.Locate and then click the following subkey in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer

3.On the Edit menu, point to New, and then click DWORD Value.

4.Type SecureRepairPolicy for the name of the DWORD, and then press Enter.

5.Right-click SecureRepairPolicy, and then click Modify.

6.In the Value data box, type  2, and then click OK.

7.Locate and then click the following subkey in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer

8.On the Edit menu, point to New, and then click Key.

9.Type SecureRepairWhitelist for the name of the key, and then press Enter.

10.Double-click the SecureRepairWhitelist key to open it.

11.On the Edit menu, point to New, and then click String Value. Create String Values that contain the product codes (including braces {}) of the products that have to be added to the Safe Recipients list.

In addition, when installing SQL Server, please stop all services except essential Microsoft services in your system.

For more details, please review the following link.
http://support.microsoft.com/kb/2918614

There is also a similar thread for your reference.
http://www.symantec.com/connect/forums/sep-121-ru5-install-error-error-997-overlapped-io-operation-progress

Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.

Lydia,

Thanks for your help. I've tried this, but at this point have added 9 separate products added to the SecureRepairWhitelist, but it's still giving me the same error for each new MSI\product (of which there are quite a few). Do I just keep added more and more of these entries for each MSI? This can't be the right solution to my problem.

Hi,

Thanks for your response. There isn't much installed on the system. It did have VM Ware installed, so I removed it and rebooted, but the same issues occurred.

Thanks,

Zack

Hi zerhart2,

After manually modifying registry entries, you are not able to install SQL Server successfully, right?

If that is the case, personally, I recommend you submit a feedback about such issue to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback . Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.


Thanks,
Lydia

Lydia,

I can keep adding more and more entries to that SecureWhiteList, and I assume it will eventually install. Obviously, there is something causing the problem unrelated to the registry settings. I'd like to fix the root issue, so I don't have additional problems in the future.

Thanks,

Zack

• Proposed as answer by srinigv 10 hours 48 minutes ago
• Unproposed as answer by srinigv 10 hours 48 minutes ago

Hi Jack, I too having this issue with KB2918614 on win7-ent for sometime now. Found the problem to be with folder-permissions on C:\ProgramData\Microsoft\Crypto\RSA\S-1-5-18

only my useraccount had access to folder "S-1-5-18", No other permissions were present on this folder because of which MSI installer was failing to complete installation.

I renamed the folder as "JUNKS-1-5-18" and retried installation (explicitly downloaded packages from http://www.microsoft.com/en-in/download/details.aspx?id=26368) this time installation completed successfully. a new folder S-1-5-18 got autocreated with appropriate permissions.

To be on safer side take backup of old folder JUNKS-1-5-18, if things don't workout you can altleast revert back to old folder contents.

Thanks, srinigv

• Proposed as answer by srinigv 10 hours 5 minutes ago
• Unproposed as answer by srinigv 10 hours 5 minutes ago
• Proposed as answer by srinigv 10 hours 4 minutes ago