Thinking this was likely the issue, I de-installed it and ran 2019 setup again. I went to Control Panel and looked in Apps and Features, and found Microsoft SQL Server 2012 Native Client. (01) 14:30:23 Slp: Error: Action "Install_sqlncli_Cpu64_Action" failed during execution. (01) 14:30:23 Slp: at .Action.Execute(String actionId, TextWriter errorStream) (01) 14:30:23 Slp: at .(WorkflowObject workflowObject, HandleInternalException exceptionHandler) (01) 14:30:23 Slp: at .(WorkflowObject metaDb, TextWriter loggingStream) (01) 14:30:23 Slp: at .(WorkflowObject metabase, TextWriter statusStream) (01) 14:30:23 Slp: at .(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream) (01) 14:30:23 Slp: at .(ActionWorker workerDelegate) (01) 14:30:23 Slp: ExecuteActionWithRetryHelper.Failed actionToExecute is 'Install_sqlncli_Cpu64_Action', stack trace at ._Displa圜lass2_0.b_0() (01) 14:30:23 Slp: No retry-able MSI return code detected. (01) 14:30:23 Slp: InstallPackage: MsiInstallProduct returned the result code 1602. (01) 14:30:23 Slp: Sco: Attempting to close SC Manager (01) 14:30:23 Slp: Sco: Attempting to close service handle for service msiserver (01) 14:30:23 Slp: Invoking QueryServiceStatus Win32 API (01) 14:30:23 Slp: Sco: Attempting to open service handle for service msiserver (01) 14:30:23 Slp: Sco: Attempting to open SC Manager (01) 14:30:23 Slp: Sco: Waiting for service 'msiserver' to accept the stop request. (01) 14:30:23 Slp: Checkpoint: PREINSTALL_SQLNCLI_CPU64_ACTION (01) 14:30:23 Slp: Sco: Attempting to get registry value InstallDir (01) 14:30:23 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\14.0 (01) 14:30:23 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\RefCount\SNAC11 (01) 14:30:23 Slp: Sco: Attempting to open registry subkey (01) 14:30:23 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 14:30:23 Slp: SetFeaturePropsModifyInstallAction for sqlncli_Cpu64 (01) 14:30:23 Slp: Running Action: Install_sqlncli_Cpu64_Action So I dug in to the Detail.txt file in C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20191123_142713 and eventually found the first thing that failed: Next step for SNAC_SDK: Use the following information to resolve the error, and then try the setup process again. Next step for Replication: Use the following information to resolve the error, and then try the setup process again. Next step for SQLEngine: Use the following information to resolve the error, and then try the setup process again. Next step for AdvancedAnalytics: Use the following information to resolve the error, and then try the setup process again. Next step for sql_inst_mr: Use the following information to resolve the error, and then try the setup process again. Next step for sql_inst_mpy: Use the following information to resolve the error, and then try the setup process again. Next step for sql_inst_java: Use the following information to resolve the error, and then try the setup process again. Troubleshooting information for those features: Setup completed with required actions for features. The setup summary had this really unhelpful summary: I thought maybe it was some dependency issue, so did it all again, hit go and watched. I came back half an hour later to see that all install steps had failed. Thinking this would be a smooth process, I kicked off the install wizard, went through it, hit go, and walked away. On the new laptop I have SQL Server 2017, and now that SQL Server 2019 RTM has shipped, and I’ve finished teaching for the year, I set out to install 2019 side-by-side with 2017 so I can move my teaching environment to 2019 and work on demos of the new features pertinent to what I teach. I have a brand new Windows 10 laptop that I use solely for teaching, as the HDMI and SVGA connectors on my main laptop somehow have bad connections to the motherboard after a few years of traveling around the world. This time the Curious Case is about something that happened to me: a failing SQL Server 2019 install. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) (The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |