- Remove From My Forums
-
General discussion
-
hi. a blind it developer, and needed to install sql server 2014 developer 64 bit, and did uinstall sql server express. a it student and needed to import data into a table, but said I needed the pro, enterprise or developer version to save the table, when
I then had a look at the table with my screen reader jaws in sql management studio, was empty. now I cannot install sql server 2014 developer and downloaded it fronm the dream spark site as a member and doing vertificat eiv programming from
http://www.upskilled.edu.au, and will paste the set up screen below. can any one help me, how to get this to work, any tools, work arounds, just frustrated, also my database project, lost it, and now could not attatch
or even create a new database in the express version. do not want to have to reinstall windows 81. as only got 30 gb, then if I run out, means my relatives, will have slow internet access. please help, what to do. just frustrated, this problem been happening
since Thursday, and I disabled my anti virus, avg free 2015, and then removed it, it would not roll back several windows system restore points and tried several different datates, no good. any help. frustrated. marvin. ps: my lectuer not into work until Monday,
and cannot do my assignment as stuck. help, and in Australia. SQL Server 2014 Setup
Rule Status
Setup administrator Passed
Setup account privileges Passed
Restart computer Passed
Windows Management Instrumentation (WMI) service Passed
Consistency validation for SQL Server registry keys Passed
Long path names to files on SQL Server installation media Failed
SQL Server Setup Product Incompatibility Passed
.NET 2.0 and .NET 3.5 Service Pack 1 update for Windows 2008 … Passed
Edition WOW64 platform Passed
http://startrekcafe.stevesdomain.net http://groups.yahoo.com/groups/JawsOz
-
December 13, 2013 at 10:17 am
#285954
I’m getting a rule check fail «Long path names to files on SQL Server Installation media failed» when installing SQL 2012 Standard edition from a network share. What is the work around for this?
Thanks
-
Steve Jones — SSC Editor
SSC Guru
Points: 730281
My understanding is that this is a check to be sure all files/paths are < 256 characters. Do you have long paths for the installation folder?
-
Lowell
SSC Guru
Points: 323494
cathy.baker (12/13/2013)
I’m getting a rule check fail «Long path names to files on SQL Server Installation media failed» when installing SQL 2012 Standard edition from a network share. What is the work around for this?
Thanks
i believe you can simply map a drive to the share,and install form that, instead of from the share with the long file name;;
here’s gui instructions:
http://windows.microsoft.com/en-us/windows/create-shortcut-map-network-drive#1TC=windows-7
from a command line, it’s pretty simple:
net use m: \servernamesharenamesubsharesubshare2
Lowell
—help us help you! If you post a question, make sure you include a CREATE TABLE… statement and INSERT INTO… statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
-
cathy.baker
Hall of Fame
Points: 3412
-
cathy.baker
Hall of Fame
Points: 3412
I renamed the folder that was WAY long to something shorter and simpler then mapped the drive. That fixed the problem.
-
Jeff Moden
SSC Guru
Points: 1002102
cathy.baker (12/13/2013)
I renamed the folder that was WAY long to something shorter and simpler then mapped the drive. That fixed the problem.
Thanks for the feedback, Cathy.
—Jeff Moden
RBAR is pronounced «ree-bar» and is a «Modenism» for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW… think, instead, of what you want to do to a COLUMN.Dear Lord… I’m a production DBA. Please grant me patience because, if you grant me strength, I’m gonna need bail money to go with it.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
adamenko1984
Valued Member
Points: 67
Long Path Tool could be the answer to your problem. I too faced a similar predicament some time back. Long Path Tool came in very handy at that time.
-
virenderverma
SSC Journeyman
Points: 75
On my case my sql server path was very long
D:Softwareen_sql_server_2008_r2_enterprise_x86_x64_ia6t4_dvd_520517en_sql_server_2008_r2_enterprise_x86_x64_ia64_dvd_520517setup.exe
I just renamed that to
D:Softwaresql serversql serversetup.exe
then work fine for me
😀
-
bitf11m050
Valued Member
Points: 67
Thanks dude, solved my problem the same way:-)
-
March 24, 2017 at 2:02 am
This was removed by the editor as SPAM
-
March 24, 2017 at 2:03 am
This was removed by the editor as SPAM
-
March 24, 2017 at 2:03 am
This was removed by the editor as SPAM
-
March 24, 2017 at 2:03 am
This was removed by the editor as SPAM
-
March 24, 2017 at 2:03 am
This was removed by the editor as SPAM
-
March 24, 2017 at 2:04 am
This was removed by the editor as SPAM
Viewing 15 posts — 1 through 15 (of 17 total)
I just needed to do a fresh installation of Microsoft System Center 2012 Data Protection Manager SP1 on a fresh Windows Server 2012. I went throug all steps of the installation wizard, installed all prerequisites and started the installation. But then I got this error:

The Data Protection Manager installation did not complete successfully. For details, click the Error tab.

The SQL Server installation failed. All changes made by the SQL Server installation to the system were rolled back. Manually install SQL Server. For instructions, see “Manually Installing Prerequisite Software” in the System Center 2012 Service Pack 1 DPM Deployment Guide.
ID: 4309. Details: Unknown error (0x84be0009)
All you can find on Technet or elsewhere is:
Manually install SQL Server 2008. For instructions, see “Manually Installing Prerequisite Software” in the DPM 2010 Deployment Guide.
That was not as helpful as it should have been.
So I tried to manually install SQL Server. I went to the SQLSVR2008R2SP2 folder on the DPM installation media and ran setup. I chose to install a single instance SQL Server and this is what I got:

Long path names to files on SQL Server installation media: Failed

Rule “Long path names to files on SQL Server installation media” failed.
SQL Server installation media on a network share or in a custom folder can cause installation failure if the total length of the path exceeds 260 characters. To correct this issue, utilize Net Use functionality or shorten the path name to the SQL Server setup.exe file.
Hence I copied the whole Data Protection Manager installation media from a network share to my local hard drive and ran DPM setup again. This time it worked like a charm:

At the start of the year, I wrote about the SQL Server upgrade advisor. I was setting up my home test environment recently and this prompted me to write a couple of posts on SQL Server installation and cover some of the nice features which I believe are quite important.
As you begin the SQL Server 2012 installation, SQL Server goes through a series of checks to ensure that environment configurations that could result in a failed installation are identified in advance and the user is given a chance to rectify them. In this set of checks, I noticed that the media also checks for long path names to the files:
What this check does is to simply check if all files on the installer can be accessed by a path that is less than or equal to the 256-character normal limit on path names. Most product installers do not perform this check and the installation ultimately fails when one has an unusually long file path (such that the number of characters is greater than 256 characters).
In my humble opinion, this is a great example of a check that all product installers must adopt to avoid installation failures for a reason as simple as a long path.
Until we meet next time,
Be courteous. Drive responsibly.
-
rev23dev
- Posts: 131
- Joined: Tue May 12, 2009 2:42 pm
SQL setup.exe path too long
My product has been installing SQL Express with InstallAware for about 5 years now. Today I saw an error that I’ve never seen before. I’ve recently switched from IA15 to X2, and a custom SQL Server 2014 Express runtime to the one included with X2.
SQL Server installation media on a network share or in a custom folder can cause installation failure if the total length of the path exceeds 260 characters. To correct this issue, utilize Net Use functionality or shorten the path name to the SQL Server setup.exe file.
It seems the temp path being created for the setup is too long.
The PC in question looks to be Windows 7 x86
-
FrancescoT
- Site Admin
- Posts: 5324
- Joined: Sun Aug 22, 2010 4:28 am
Re: SQL setup.exe path too long
Postby FrancescoT » Fri Mar 06, 2015 2:38 pm
Dear rev23dev,
thanks for reporting it … but I really don’t know if we can include a similar fix, which it appears to be caused by a limitation of the MS SQL installer itself.
Anyway, thanks once again for reporting it!
Regards
-
MartinIW
- Posts: 69
- Joined: Thu Feb 10, 2011 8:35 am
- Location: Germany
Re: SQL setup.exe path too long
Postby MartinIW » Wed Jan 13, 2016 2:48 am
Hello,
we are hitting the same problem. We delivered SQL Server Express 2008 R2 for several years now.
Now we switched to InstallAware X3 and decided to deliver SQL Server Express 2014 instead of the 2008R2.
On two mashines we got the same error when installing the SQL Server (Windows 8.1 and 10 (both x64)).
It seams like it doesnt matter if we run it from network path or from desktop.
How may we shorten the path used here or can do something else to provide getting this error?
Thanks in advance,
Martin
-
FrancescoT
- Site Admin
- Posts: 5324
- Joined: Sun Aug 22, 2010 4:28 am
Re: SQL setup.exe path too long
Postby FrancescoT » Wed Jan 13, 2016 11:26 am
Dear Martin,
I have just completed to run some tests and I don’t see any problem with installing the «SQL Server Express 2014 RTMs» on Win 8.1 / 10 (both x64).
Regards
-
MartinIW
- Posts: 69
- Joined: Thu Feb 10, 2011 8:35 am
- Location: Germany
Re: SQL setup.exe path too long
Postby MartinIW » Thu Jan 14, 2016 1:49 am
Hmm,
«runs on my mashine» was not what i expected to hear…
We have the Problem on two of our testing virtual mashines now and we are afraid that many users out there will get the error too.
So again my question: How can we get rid of this?
Greetings,
Martin
-
FrancescoT
- Site Admin
- Posts: 5324
- Joined: Sun Aug 22, 2010 4:28 am
Re: SQL setup.exe path too long
Postby FrancescoT » Thu Jan 14, 2016 12:18 pm
Dear Martin,
I should first understand what really happens, otherwise it’s difficult to suggest you a workaround or a possible solution.
Can you give me some more details about the Virtual Systems you used to replicate the issue?
Regards
-
MartinIW
- Posts: 69
- Joined: Thu Feb 10, 2011 8:35 am
- Location: Germany
Re: SQL setup.exe path too long
Postby MartinIW » Fri Jan 15, 2016 4:01 am
Hi Francesco,
we have the error now on 3 VMs. We host them via Microsoft Hyper-V:
Windows 8 Pro:
— Intel(R)Core(TM) i7 CPU 960 @3.20GHz 3.20GHz (virtual quadcore)
— 3 GB RAM
— x64 processor
— 50GB HDD
Windows 8.1 Pro:
— Intel(R)Core(TM) i7 CPU 960 @3.20GHz 3.20GHz (virtual quadcore)
— 3 GB RAM
— x64 processor
— 50GB HDD
Windows 10 Enterprise:
— Intel(R) Xeon(R) CPU E5-2640 v2 @ 2.00GHz 2.00GHz
— 3 GB RAM
— x64 processor
— 50GB HDD
If you want to know more about the Host-System we use I will have to ask our Administrator to give me the information.
Is there something more you need to know?
-
MartinIW
- Posts: 69
- Joined: Thu Feb 10, 2011 8:35 am
- Location: Germany
Re: SQL setup.exe path too long
Postby MartinIW » Mon Feb 22, 2016 8:58 am
Thanks for the help Francesco.
There was something wrong with my commandline parameters, it had nothing to do with InstallAware ![]()
*closed*
-
rev23dev
- Posts: 131
- Joined: Tue May 12, 2009 2:42 pm
Re: SQL setup.exe path too long
Postby rev23dev » Mon May 08, 2017 5:54 pm
Hmm… ran into this again today with X6
It’s telling me SQL Server installation media on a network share or in a custom folder can cause installation failure if the total length of the path exceeds 260 characters. To correct this issue, utilize Net Use functionality or shorten the path name to the SQL Server setup.exe file
The path it went to was:
C:UsersCounterAppDataLocal{1B8A640C-2546-4DFD-A192-1FEFC6825891}Microsoft SQL Server Express 2014 SP2 (x64)mFileBagIDE.dllDD914CECx64setup
Not 260 (I guess some of the files it extracts might be?). Kind of goes back to what I was saying in a previous post about these web media names being excessively long ![]()
-
rev23dev
- Posts: 131
- Joined: Tue May 12, 2009 2:42 pm
Re: SQL setup.exe path too long
Postby rev23dev » Fri Aug 11, 2017 1:49 pm
How is no one else running into this?
I just saw it again today on Windows 10
-
FrancescoT
- Site Admin
- Posts: 5324
- Joined: Sun Aug 22, 2010 4:28 am
Re: SQL setup.exe path too long
Postby FrancescoT » Mon Aug 14, 2017 9:54 am
Dear Rev23dev,
honestly, I don’t see any problem when installing «SQL Server Express 2014 SP2 (x64)» RTMs on Win 10 x64.
Regards
-
rev23dev
- Posts: 131
- Joined: Tue May 12, 2009 2:42 pm
Re: SQL setup.exe path too long
Postby rev23dev » Mon Aug 14, 2017 5:59 pm
If you sign in with a Windows account your user profile directory is limited to 5 characters. So C:usersxxxxxAppData… so maybe this one, since it’s a local account with a longer user name is causing the issues?
I think these paths and .7zip filenames should be shortened though.
For example, if I set my webmediablock url to use sql2014sp2x64.zip, IA should use this filename when generating that .7zip file (currently it uses the full name of the web media block), additionally, that would shorten this temp path.
-
FrancescoT
- Site Admin
- Posts: 5324
- Joined: Sun Aug 22, 2010 4:28 am
Re: SQL setup.exe path too long
Postby FrancescoT » Tue Aug 15, 2017 5:24 am
Dear Rev23dev,
for test purpose, you may try to copy the extracted SQL setup files to a different directory and then to run the <sql-setup> from there.
For example, in the «setupsql2014sp2_x64» script the variable «MSSQL2014_FILEBAG_X64» holds the path the extracted SQL setup files. You may modify this script and you could use the «Copy/Move Local Files» command to copy these files on a different directory (eg. c:test) of the target machine target. Finally, you should also update accordingly the path used to run the <sql-setup> («Run Program» Command).
The «Copy/Move Local Files» is a Windows Installer command (PURPLE COMMAND) and to execute it immediately, you need to temporarily switch native engine ON.
Set Variable NATIVE_ENGINE to TRUE
Copy Local Files to
Set Variable NATIVE_ENGINE to FALSE
Regards
Return to “Technical Support”
Who is online
Users browsing this forum: No registered users and 29 guests
DAKTRONICS DOES NOT PROMISE THAT THE CONTENT
PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT
YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED
ON AN «AS-IS» AND «AS-AVAILABLE» BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE
IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES,
EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT,
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY
AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD
PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT,
REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS
AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL
RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE
REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING
THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE
PARTIES.
The above disclaimer applies to any property damage, equipment
failure, liability, infringement, or personal injury claim arising out of or in
any way related to your use or application of the content, whether such claim is
for breach of contract, tort, negligence or any other cause of action.
Cookbook version
[Version of the cookbook where you are encountering the issue]
5.5.0
Chef-client version
[Version of chef-client in your environment]
chef-client 14.12.9-1-x64.msi installed in vm template.
chef-server 14.11.21 with manage
Platform Details
[Operating system distribution and release version. Cloud provider if running in the cloud]
-Windows 2016 DataCenter
-vSphere 6.7.0.30000 machine template.
-vRA 7.5.0 (Build: 10053500)
-Chef Server plug-in for vRealize Orchestrator 1.0.0 — chef/vmware collaboration.
-Default workflow that came with the Chef server plugin — «CHEFWindows Node ManagementVMToolsWindows VMTools Chef-client first run Validatorless workflow»
-SQL Server enterprise core 2016
Scenario:
[What you are trying to achieve and you can’t?]
Execute vRA request which provisions a VM and then calls the vRO chef plugin workflow to add the provisioned VM to Chef server as a client and node (which occurs successfully) and then execute a runlist containing this cookbook to install sql server 2016 enterprise core.
Insallation fails with the following errors:
1.SQL core installer complains about WMI service cannot be started. There are COM+ registry errors in the windows event viewer at the exact time or just seconds before associated with my local administrator AD domain account not having permissions to the runtimebroker com+ application. The event viewer also shows that the SQL Server ScenarioEngine.exe registry keys in use leaked, which results in windows closing the handle before SQL Server ScenarioEngine.exe is done using it for the install.
-
«SQL Server Setup was not able to access domain ‘WinNT://XXXX’ to validate user account ‘XXXXX’. The SQL Server service account login or password is not valid.” However, the service account password is correct and validated using run as powershell credentials test running notepad or some other app as that user. SQL installer is trying to connect to AD via the runtimebroker COM+ app to validate the service account the SQL configuration.ini unattend file is setting on the windows sql services, but cannot access runtimebroker due to the registry unloading the key necessary as indicated in the error above. It seems to pretty consistently alternate between these 2 errors. I can run it and get WMI error, then run again and get user account access error, then run again and get WMI, then run again and get user account access error.
-
I occasionally will get «could not read key from registry» without getting either of the first 2 errors.
IF I login to the VM prior to the server.rb recipe running as the local admin AD domain user account chef is running the cookbook under, the sql installer completes successfully without errors.
IF set the security policy «do not forcefully unload registry when user logs off» in the registry of the template, or via a reg key resource before the package resource in the server.rb recipe, the installation completes successfully without errors.
Steps to Reproduce:
[If you are filing an issue what are the things we need to do in order to repro your problem? How are you using this cookbook or any resources it includes?]
I am only using the server.rb and configure.rb recipes from the sql_server cookbook. I have commented out options that we don’t need in the server.rb recipe, and had to change the OPTIONS string to the following for it to work:
«/Q /ACTION=#{node[‘cs_sql_server’][‘setup_action’]} #{passwords_options} /ConfigurationFile=#{config_file_path} /IAcceptSQLServerLicenseTerms=#{node[‘cs_sql_server’][‘accept_eula’]}»
I added 2 custom recipes, one to run first which bootstraps the vm with custom applications, then server.rb followed by configure.rb, followed by custom recipe to execute my custom apps.
ALL recipes run successfully and complete without issue when executed via chef-solo command logged into the vm as admin.
- I have a windows template in vSphere that contains the chef-client installed.
- vRA blueprint clones the template and powers on, joins domain, adds local users specified to admins, updates vmtools.
- vRA executes the vRO Chef Server plug-in for vRealize Orchestrator’s default worklfow named «CHEFWindows Node ManagementPowerShellWindows PS Chef-client first run Validatorless workflow» and passes required parameters.
- The workflow successfully executes my custom recipe first and then server.rb
- Server.rb completes with errors.
- Login and review SQL installation logs to find the errors listed above.
IF I login to the VM prior to the server.rb recipe running as the local admin AD domain user account chef is running the cookbook under, the sql installer completes successfully without errors.
IF set the security policy «do not forcefully unload registry when user logs off» in the registry of the template, or via a reg key resource before the package resource in the server.rb recipe, the installation completes successfully without errors.
Expected Result:
[What are you expecting to happen as the consequence of above reproduction steps?]
I expect the sql installer to error with the errors indicated.
Actual Result:
[What actually happens after the reproduction steps? Include the error output or a link to a gist if possible.]
DCOM errors at the time of the sql install error in the logs:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{D63B10C5-BB46-4990-A94F-E40B9D520160}
and APPID
{9CA88EE3-ACB7-47C8-AFC4-AB702511C276}
to the user DOMAINUSER SID (S-1-5-21-221447426-1814128558-2251880862-1653) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.
Registry key leaked event viewer errors:
`Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards. No user action is required.
DETAIL —
11 user registry handles leaked from RegistryUserS-1-5-21-221447426-1814128558-2251880862-1653:
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWARE
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREMicrosoftWindowsCurrentVersionExplorer
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREMicrosoftWindowsCurrentVersionInternet Settings
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREPolicies
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREPoliciesMicrosoftWindowsCurrentVersionInternet Settings
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREMicrosoftInternet ExplorerMain
Process 2836 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Coresetup.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREMicrosoftWindows NTCurrentVersion
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653Control PanelInternational
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREMicrosoftInternet ExplorerSecurity
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREMicrosoftWindowsCurrentVersionInternet SettingsZoneMap
1 user registry handles leaked from RegistryUserS-1-5-21-221447426-1814128558-2251880862-1653_Classes:
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653_Classes
1 user registry handles leaked from RegistryUserS-1-5-21-221447426-1814128558-2251880862-1653:
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653SOFTWAREMicrosoftWindows NTCurrentVersion
2 user registry handles leaked from RegistryUserS-1-5-21-221447426-1814128558-2251880862-1653_Classes:
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653_Classes
Process 1672 (DeviceHarddiskVolume40.InstallSQL Server 2016 Enterprise Corex64ScenarioEngine.exe) has opened key REGISTRYUSERS-1-5-21-221447426-1814128558-2251880862-1653_Classes
`
SQL install log errors:
`C:Program FilesMicrosoft SQL Server130Setup BootstrapLog20190509_104359Detail.txt
(01) 2019-05-09 10:44:04 Slp: Running Action: ValidateSettingsAgainstScenario
(01) 2019-05-09 10:44:04 Slp: Scenario: Install
(01) 2019-05-09 10:44:04 Slp: Completed Action: ValidateSettingsAgainstScenario, returned True
(01) 2019-05-09 10:44:04 Slp: ———————————————————————-
(01) 2019-05-09 10:44:04 Slp: Running Action: FinalCalculateSettings
(06) 2019-05-09 10:44:04 Slp: The directory monitor thread is interrupted due to the following exception while monitoring the notifications for directory ‘C:Program Files (x86)’
(06) 2019-05-09 10:44:04 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(06) 2019-05-09 10:44:04 Slp: Inner exceptions are being indented
(06) 2019-05-09 10:44:04 Slp:
(06) 2019-05-09 10:44:04 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.MonitorThreadInterruptedException
(06) 2019-05-09 10:44:04 Slp: Message:
(06) 2019-05-09 10:44:04 Slp: The directory monitor thread is interrupted. Message: ‘The directory monitor thread is interrupted due to a StopMonitor call.’
(06) 2019-05-09 10:44:04 Slp: HResult : 0x86a40016
(06) 2019-05-09 10:44:04 Slp: FacilityCode : 1700 (6a4)
(06) 2019-05-09 10:44:04 Slp: ErrorCode : 22 (0016)
(06) 2019-05-09 10:44:04 Slp: Data:
(06) 2019-05-09 10:44:04 Slp: ErrorMessage = The directory monitor thread is interrupted due to a StopMonitor call.
(06) 2019-05-09 10:44:04 Slp: WatsonData = Microsoft.SqlServer.Configuration.Sco.MonitorThreadInterruptedException@22
(06) 2019-05-09 10:44:04 Slp: Stack:
(06) 2019-05-09 10:44:04 Slp: at Microsoft.SqlServer.Configuration.Sco.DirectoryMonitor.Monitor()
……..
(01) 2019-05-09 10:44:04 Slp: Initializing rule : Windows Management Instrumentation (WMI) service
(01) 2019-05-09 10:44:04 Slp: Rule is will be executed : True
(01) 2019-05-09 10:44:04 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.WmiServiceInfo
(01) 2019-05-09 10:44:05 Slp: Cluster Service is not running : Exception is as follows System.Runtime.InteropServices.COMException (0x80040150): Could not read key from registry
at System.Management.ThreadDispatch.Start()
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.SqlServer.Configuration.SetupExtension.WmiServiceInfo.Microsoft.SqlServer.Configuration.RulesEngineExtension.IRuleInitialize.Init(String ruleId)
at Microsoft.SqlServer.Configuration.RulesEngineExtension.RulesEngine.Execute(Boolean stopOnFailure)
(01) 2019-05-09 10:44:05 Slp: Rule initialization failed — hence the rule result is assigned as Failed
(01) 2019-05-09 10:44:05 Slp: Initializing rule : Consistency validation for SQL Server registry keys
(01) 2019-05-09 10:44:05 Slp: Rule is will be executed : True
(01) 2019-05-09 10:44:05 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.AclPermissionsFacet
(01) 2019-05-09 10:44:05 Slp: Launching external tool: e:0.installsql server 2016 enterprise corex64FixSqlRegistryKey_x64.exe
(01) 2019-05-09 10:44:05 Slp: ————————————————————
(08) 2019-05-09 10:44:05 Slp: HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL Server — Set SE_DACL_AUTO_INHERITED.
(08) 2019-05-09 10:44:05 Slp: HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL Server130 — Set SE_DACL_AUTO_INHERITED.
(01) 2019-05-09 10:44:05 Slp: ————————————————————
(01) 2019-05-09 10:44:05 Slp: e:0.installsql server 2016 enterprise corex64FixSqlRegistryKey_x64.exe exit code: 0
(01) 2019-05-09 10:44:05 Slp: Launching external tool: e:0.installsql server 2016 enterprise corex64FixSqlRegistryKey_x86.exe
(01) 2019-05-09 10:44:05 Slp: ————————————————————
(09) 2019-05-09 10:44:05 Slp: HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL Server — OK.
(09) 2019-05-09 10:44:05 Slp: HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL Server130 — OK.
(01) 2019-05-09 10:44:05 Slp: ————————————————————
(01) 2019-05-09 10:44:05 Slp: e:0.installsql server 2016 enterprise corex64FixSqlRegistryKey_x86.exe exit code: 0
(01) 2019-05-09 10:44:05 Slp: Rule ‘AclPermissionsFacet’ detection result: AreSqlAclPermissionsCanonical= True
(01) 2019-05-09 10:44:05 Slp: Evaluating rule : AclPermissionsFacet
(01) 2019-05-09 10:44:05 Slp: Rule running on machine: HOSTNAME
(01) 2019-05-09 10:44:05 Slp: Rule evaluation done : Succeeded
(01) 2019-05-09 10:44:05 Slp: Rule evaluation message: SQL Server registry keys are consistent and can support SQL Server installation or upgrade.
(01) 2019-05-09 10:44:05 Slp: Initializing rule : Long path names to files on SQL Server installation media
(01) 2019-05-09 10:44:05 Slp: Rule is will be executed : True
(01) 2019-05-09 10:44:05 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.MediaPathLenghtFacet
(01) 2019-05-09 10:44:05 Slp: Rule ‘MediaPathLength’ INSTALLMEDIAPATH length is 56
(01) 2019-05-09 10:44:05 Slp: Evaluating rule : MediaPathLength
(01) 2019-05-09 10:44:05 Slp: Rule running on machine: HOSTNAME
(01) 2019-05-09 10:44:05 Slp: Rule evaluation done : Succeeded
(01) 2019-05-09 10:44:05 Slp: Rule evaluation message: The SQL Server installation media is not too long.
(01) 2019-05-09 10:44:05 Slp: Initializing rule : SQL Server Setup Product Incompatibility
(01) 2019-05-09 10:44:05 Slp: Rule is will be executed : True
(01) 2019-05-09 10:44:05 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.SetupCompatibilityCheck
(01) 2019-05-09 10:44:05 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2019-05-09 10:44:05 Slp: Sco: Attempting to open registry subkey SOFTWAREMicrosoftMicrosoft SQL Server130BootstrapIncompatibilities
(01) 2019-05-09 10:44:05 Slp: Searching for reg path SOFTWAREMicrosoftMicrosoft SQL Server130BootstrapIncompatibilities. Open subkey result is False
(01) 2019-05-09 10:44:05 Slp: Regkey not present. No incompatibilities
(01) 2019-05-09 10:44:05 Slp: Incompatibility detected = False
(01) 2019-05-09 10:44:05 Slp: Evaluating rule : SetupCompatibilityCheck
(01) 2019-05-09 10:44:05 Slp: Rule running on machine: HOSTNAME
(01) 2019-05-09 10:44:05 Slp: Rule evaluation done : Succeeded
(01) 2019-05-09 10:44:05 Slp: Rule evaluation message: Setup has not detected any incompatibilities.
(01) 2019-05-09 10:44:05 Slp: Initializing rule : .NET 2.0 and .NET 3.5 Service Pack 1 update for Windows 2008 R2 and Windows 7 (KB958488)
(01) 2019-05-09 10:44:05 Slp: Rule is will be executed : True
(01) 2019-05-09 10:44:05 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.NoRebootPackageFacet
(01) 2019-05-09 10:44:05 Slp: Evaluating rule : NoRebootPackage
(01) 2019-05-09 10:44:05 Slp: Rule running on machine: HOSTNAME
(01) 2019-05-09 10:44:05 Slp: Rule evaluation done : Succeeded
(01) 2019-05-09 10:44:05 Slp: Rule evaluation message: This computer has the required update package.
(01) 2019-05-09 10:44:05 Slp: Initializing rule : Edition WOW64 platform
(01) 2019-05-09 10:44:05 Slp: Rule is will be executed : True
(01) 2019-05-09 10:44:05 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.FacetWOW64PlatformCheck
(01) 2019-05-09 10:44:05 Slp: Current machineArchitecture = x64
(01) 2019-05-09 10:44:05 Slp: Setup package is 64 bit, Marking check for WOW Supported32bitSetup as passed
(01) 2019-05-09 10:44:05 Slp: Current machineArchitecture is 64bit
(01) 2019-05-09 10:44:05 Slp: Rule ‘FacetWOW64PlatformCheck’ results: Supported32bitSetup=True
(01) 2019-05-09 10:44:05 Slp: Evaluating rule : FacetWOW64PlatformCheck
(01) 2019-05-09 10:44:05 Slp: Rule running on machine: HOSTNAME
(01) 2019-05-09 10:44:05 Slp: Rule evaluation done : Succeeded
(01) 2019-05-09 10:44:05 Slp: Rule evaluation message: SQL Server Setup is supported on this operating system platform.
(01) 2019-05-09 10:44:05 Slp: Saved to directory…….C:Program FilesMicrosoft SQL Server130Setup BootstrapLog20190509_104359SystemConfigurationCheck_Report.htm
(01) 2019-05-09 10:44:05 Slp: Sco: Attempting to create directory C:Program FilesMicrosoft SQL Server130Setup BootstrapLog20190509_104359resources
(01) 2019-05-09 10:44:05 Slp: Sco: Attempting to create directory C:Program FilesMicrosoft SQL Server130Setup BootstrapLog20190509_104359resources, security descriptor
(01) 2019-05-09 10:44:05 Slp: Sco: Directory ‘C:Program FilesMicrosoft SQL Server130Setup BootstrapLog20190509_104359resources’ already exists, skipping creation, moving to set security descriptor.
(01) 2019-05-09 10:44:05 Slp: Sco: Attempting to set security descriptor for directory C:Program FilesMicrosoft SQL Server130Setup BootstrapLog20190509_104359resources, security descriptor
(01) 2019-05-09 10:44:05 Slp: Sco: SDDL is NULL/empty and overwriteSecurityDescriptor is false, so nothing to do, return.
(01) 2019-05-09 10:44:05 Slp: Rules evaluation report is available now at C:Program FilesMicrosoft SQL Server130Setup BootstrapLog20190509_104359SystemConfigurationCheck_Report.htm
(01) 2019-05-09 10:44:05 Slp: Error: Action «Microsoft.SqlServer.Configuration.RulesEngineExtension.RunRulesAction» threw an exception during execution.
(01) 2019-05-09 10:44:05 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The Windows Management Instrumentation (WMI) service cannot be started. To continue with the installation, you must troubleshoot and repair your Windows Management Instrumentation (WMI) service. —> Microsoft.SqlServer.Configuration.RulesEngineExtension.RulesEngineRuleFailureException: The Windows Management Instrumentation (WMI) service cannot be started. To continue with the installation, you must troubleshoot and repair your Windows Management Instrumentation (WMI) service.
(01) 2019-05-09 10:44:05 Slp: at Microsoft.SqlServer.Configuration.RulesEngineExtension.RunRulesAction.ExecuteAction(String actionId)
`