次の方法で共有

SQL 2008/2008 R2/2012/2014 setup disappears/fails when installing Setup Support files

  • [アーティクル]

I’m sure many of you would have seen this issue when running SQL 2008/2008 R2/2012/2014 setup on a new server. The setup will proceed to install Setup support files, the window will disappear but, strangely enough, the next window never shows up.

Here’s what you need to do:

  1. Click on start->run and type %temp% and press enter (basically, go to the temp folder)
  2. Here, look for SQLSetup.log and SQLSetup_1.log. Open the SQLSetup_1.log file. In there, check for the following messages:
    04/16/2012 17:16:47.950 Error: Failed to launch process
    04/16/2012 17:16:47.952 Error: Failed to launch local setup100.exe: 0x80070003

Typically, you get this error only in SQL 2008, SQL 2008 R2, SQL 2012 and SQL 2014. The steps are slightly different for all 4, and I’ve tried to outline them here.

Warning: These steps involve modification of the windows registry, a highly sensitive component of the Operating System. Before proceeding, please ensure you take a complete backup of the registry.

SQL Server 2008

1. Save the following in a text file, change the extension to .reg, double-click on the file, and on the prompt that appears, select yes to populate the registry:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server100Bootstrap]
"BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\100\\Setup Bootstrap\\"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap\Setup]
"PatchLevel"="10.0.1600.22"

2. Next, copy the following files and folders from the media to the specified destinations:

File/Folder in media Destination
X64/X86 (depending on what architecture you want to install) C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
Setup.exe C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
Setup.rll C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\Resources\1033

Next, re-run the setup, and it should proceed beyond the point of error this time.

SQL Server 2008 R2

1. Save the following in a text file, change the extension to .reg, double-click on the file, and on the prompt that appears, select yes to populate the registry:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap]
"BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\100\\Setup Bootstrap\\"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap\Setup]
"PatchLevel"="10.50.1600.00"

2. Next, copy the following files and folders from the media to the specified destinations:

File/Folder in media Destination
X64/X86 folder (depending on what architecture you want to install) C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2
Setup.exe C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2
Resources folder C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

Next, re-run the setup, and it should proceed beyond the point of error this time.

SQL Server 2012

1. Save the following in a text file, change the extension to .reg, double-click on the file, and on the prompt that appears, select yes to populate the registry:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap]
"BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\110\\Setup Bootstrap\\"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap\Setup]
"PatchLevel"="11.00.2100.60"

2. Next, copy the following files and folders from the media to the specified destinations:

File/Folder in media Destination
X64/X86 folder (depending on what architecture you want to install) C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012
Setup.exe C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012
Resources folder C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012

Next, re-run the setup, and it should proceed beyond the point of error this time.

SQL Server 2014

1. Save the following in a text file, change the extension to .reg, double-click on the file, and on the prompt that appears, select yes to populate the registry:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap]
"BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\120\\Setup Bootstrap\\"

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server120BootstrapSetup]
"PatchLevel"="12.00.2000.80"

2. Next, copy the following files and folders from the media to the specified destinations:

File/Folder in media Destination
X64/X86 folder (depending on what architecture you want to install) C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014
Setup.exe C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014
Resources folder C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014

Next, re-run the setup, and it should proceed beyond the point of error this time.

As always, comments/suggestions/feedback are welcome and solicited.

Comments

  • Anonymous
    May 25, 2012
    Thanks, your post help me get a stubborn 2008 R2 install going.

  • Anonymous
    June 03, 2012
    Thanks so much for appreciating the effort, Radu....it's always good to know my blogs help....!!! :)

  • Anonymous
    July 03, 2012
    I had the same issue occur for me (SQL Server 2008 R2 on Windows Server 2003 R2). My fix was installing Windows PowerShell 2.0. Re-ran the install, and it worked with no issues.

  • Anonymous
    July 03, 2012
    Hi Hambino...thanks for showing interest in the blog. I've seen powershell installation create issues with SQL setup, but never seen it cause the SQL setup to disappear when installing setup support files. I think looking at the setup logs from  your failed attempt should be quite interesting. Please feel free to mail me on harshdeep.singh@microsoft.com if you would like to investigate this further with me. Thanks, Harsh

  • Anonymous
    July 11, 2012
    Great information!!!

  • Anonymous
    August 30, 2012
    Very useful blog

  • Anonymous
    August 30, 2012
    Thanks Ahmed....!!! :)

  • Anonymous
    October 29, 2012
    The comment has been removed

  • Anonymous
    October 29, 2012
    IS there actually a way to start from scratch (clean slate)  deleting all SQL Server files that may have been partially installed and all registry keys?

  • Anonymous
    November 12, 2012
    The comment has been removed

  • Anonymous
    November 12, 2012
    LOLz...you're welcome Pavol...!!!

  • Anonymous
    December 27, 2012
    Thanks HarshDeep, you've just saved me bigtime! :-D

  • Anonymous
    January 01, 2013
    You're very welcome, my friend...!!! Thanks so much for appreciating...!!!! :)

  • Anonymous
    January 11, 2013
    It's Brilliant .............me facing the same problem.. It helps a lot I have one more issue::---- i changed the sql server instance name from sql server management studio but not able to connect server with the new instance name it still connecting with old instance name

  • Anonymous
    January 15, 2013
    Hi Mangat, Thanks for appreciating the blog. You cannot change the SQL instance once it is installed. If you really want to change the instance name, you need to uninstall and reinstall it with the new instance name, and then attach all the user db's back in. You can, however, change the computer name, and that can be reflected in the connection string using sp_dropserver and sp_addserver. Hope this answers your question. Do let me know if you need anything else. Regards, Harsh

  • Anonymous
    January 19, 2013
    I didnt get it those steps abt registry settings please Explain those as i am facing the same prpoblem

  • Anonymous
    January 27, 2013
    Thanks very much for the detailed help on this Harshdeep. Much appreciated. However, one distinct thing I noticed from this was that the setup files need to be on the Windows Installation Drive (usually C). Actually I replicated this issue once again on a different system and then I just moved the setup files from D to C and installed again (without doing the registry tweaks) and it worked perfectly. Indeed quite strange!

  • Anonymous
    February 12, 2013
    Good stuff, thanks!

  • Anonymous
    February 21, 2013
    Thanks...It worked..

  • Anonymous
    February 22, 2013
    Thanks Biswanath and tmay245....!!!!

  • Anonymous
    February 26, 2013
    The comment has been removed

  • Anonymous
    February 26, 2013
    Hi Cesardgo, Thanks for showing interest in the blog. To determine the exact reason for failure, we'll need access to the Setup log files (found in the setup bootstraplog folder). Please email me if you'd like to investigate this further. Regards, Harsh

  • Anonymous
    March 06, 2013
    Hello HarshDeep, am having an issue when installing SQL 2012 STD on windows server 2012. the setup passes all prerequisites. the setup failed with "cannot retrieve data setuprll" event ID 50000. we thought that it was a corrupted media, even changing it + copy the setup files and run keep failing with the same error.   can you please assist the issue. its critical.

  • Anonymous
    March 06, 2013
    Hi DK, Thanks for showing interest in the blog. It seems that the issue you're facing is different from the one outlined in this blog. For immediate assistance, I would recommend you open a case with Microsoft Customer Support without further delay. Regards, Harsh

  • Anonymous
    March 21, 2013
    Thanks!

  • Anonymous
    April 03, 2013
    thanks!

  • Anonymous
    April 04, 2013
    You're welcome  Firat and Lucky...!!!

  • Anonymous
    April 08, 2013
    The comment has been removed

  • Anonymous
    April 08, 2013
    Harshdeep, I've made some progress and was able to remove SQL Server and I've gotten past the issue of installation exiting after the Setup Support Files step.  However, my install is now failing with a MOF Syntax Error.  Any ideas? Cheers, Joe

  • Anonymous
    April 09, 2013
    Hey Joe, Thanks so much for reaching out, and for putting up a detailed write up of your issue. Sorry i couldn't respond earlier (an email would have been better). Could you please paste the text of the MOF error message here? Alternatively, you can also email me so we can take this offline. Thanks, Harsh

  • Anonymous
    May 03, 2013
    The mentioned registry entries did not exist. So I moved on to copy the files to the spots indicated. Still have same failure.

  • Anonymous
    May 03, 2013
    From Log: 05/03/2013 12:40:56.837 Attempting to launch process C:InstallersSQL 2008 R2x64setup100.exe 05/03/2013 12:41:25.603 Process returned exit code: 0x84BC0057 05/03/2013 12:41:25.603 Workflow COMPONENTUPDATE returned exit code: 0x84BC0057 05/03/2013 12:41:25.603 Attempting to determine security.config file path 05/03/2013 12:41:25.603 Attempting to load .Net security policy file 05/03/2013 12:41:25.603 Attempting to remove .Net security code group node

  • Anonymous
    May 04, 2013
    Hi Russweb, Thanks for showing interest in the blog. I would like to point out 2 things here:

  1. The mentioned registry entries "should" exist. This is why I have requested to save the text in a .reg file and double click to merge those entries.
  2. The error code that this blog is for is 0x80070003, which is different from the one you're getting. So, even though I feel the steps outlined above are worth a shot, it's quite possible that you're facing a different issue altogether. Kindly email me the complete setup logs if you would like to take this further. Hope this helps. Thanks.

  • Anonymous
    May 13, 2013
    Спасибо дорогой! =) Дай Бог тебе здоровья!

  • Anonymous
    May 13, 2013
    Thank you Lexa. Glad to know it helped.

  • Anonymous
    June 12, 2013
    Hello HarshDeep, I received the below error lines in my sql server 2012 express install. Should I attemp the 2012 fix with my error messages? Error Lines: 06/12/2013 00:07:33.760 Error: Failed to launch process 06/12/2013 00:07:33.761 Error: Failed to launch local ScenarioEngine.exe: 0x80070003 Does merge to registry mean, save the lines in a .reg file, then double click? Thx William

  • Anonymous
    June 12, 2013
    Hi William, Thanks for showing interest in the blog. Yes, merging to registry means saving the contents in a .reg file and then double click to merge the entries into the registry on the server. However, in my case the error was for the setup100.exe "Failed to launch local setup100.exe: 0x80070003", but in your case, it's the ScenarioEngine.exe that seems to be failing, so i am not sure if the same fix will work. If you can afford taking a risk, go ahead, Otherwise, i would recommend that you open up a case with Microsoft CSS to troubleshoot this problem. Regards, Harsh

  • Anonymous
    June 12, 2013
    Harsh, Thanks for your reply. William

  • Anonymous
    June 17, 2013
    The comment has been removed

  • Anonymous
    July 05, 2013
    how t o uninstall sql server 2008 R2

  • Anonymous
    July 08, 2013
    The comment has been removed

  • Anonymous
    July 08, 2013
    Hi Karthick, I believe the question you have is a general one, and not exactly relevant to this blog post. I would request you to post your query on msdn forums to get the it answered by the community. Regards, Harsh

  • Anonymous
    July 08, 2013
    Thanks for appreciating Bustry1. Glad to know it helped.

  • Anonymous
    July 15, 2013
    This is Lee from Malaysia, thanks so much for the solution!

  • Anonymous
    July 16, 2013
    You're welcome Lee. Thanks so much for appreciating.

  • Anonymous
    July 20, 2013
    Thank you very much worked for me in emergence time

  • Anonymous
    July 23, 2013
    Thanks for appreciating Ranjith....you're most welcome...!!!

  • Anonymous
    August 01, 2013
    Hi, i am going to install sql 2008 r2 enterprise edition in my laptop i.e windows 7. before that i used sql server 2008 express edition. i just uninstalled express edition and trying to install sql 2008 r2 enterprise edition but when i start installation after giving product key and clicked on 'install' button it will disappears installation and end the installation. there is no error message i saw. i tried above steps for first time installation but all services not installed then i uninstalled  and for second time installation folder 'bootstrap' is not found in 'C:Program FilesMicrosoft SQL Server100'. please i need suggestions and guidance. thank u in advance....:

  • Anonymous
    August 29, 2013
    The comment has been removed

  • Anonymous
    September 09, 2013
    Thank you for putting it together, Harsha! It has helped many people. Great job!

  • Anonymous
    September 09, 2013
    haha... Thanks a lot Satish...!!!

  • Anonymous
    September 09, 2013
    Thanks Prashant...that means a lot, coming from the Setup guru himself...!!!

  • Anonymous
    September 13, 2013
    The comment has been removed

  • Anonymous
    September 13, 2013
    Hi Kanchan, Thanks for showing interest in the blog. I am not clear on what you mean when you say "unable to open SQL Server 2012". Are you trying to run SQL Server setup, or are you trying to log into the SQL 2012 instance from SQL Server Management studio? If it is the former, please check the setup to make sure its not corrupted (try downloading and installing SQL 2012 express, to make sure it's not something to do with the configuration on the server). Hope this helps.

  • Anonymous
    September 26, 2013
    I would like to inform you all that the stubborn installation has been completed successfully using edition upgrade approach. Initially, I installed MS SQL Server 2008 R2 Developers Edition(64-bit) on Windows Server 2008 R2 X64 server and later upgraded to Enterprise edition of SQL Server 2008 R2(64-bit), and it worked for me.

  • Anonymous
    September 26, 2013
    Hi Gobinda, Thanks for showing interest in the blog. I am happy to hear that the installation completed successfully. Can you please confirm if you were seeing the same symptoms as outlined in the blog above, and what exact steps you took to resolve the issue? Thanks in advance, Harsh

  • Anonymous
    October 14, 2013
    Big up ^^

  • Anonymous
    October 14, 2013
    Thanks for appreciating Med.

  • Anonymous
    October 24, 2013
    Thnx HarshDeep....article helped me lot....big thnx :)

  • Anonymous
    November 04, 2013
    Thanks for the tip.   Worked great!

  • Anonymous
    November 05, 2013
    good

  • Anonymous
    November 06, 2013
    Does this work if you have reg editor v6.1?

  • Anonymous
    November 07, 2013
    Man you SAVED my day! I was stuck with this and bumped into your post by accident, FABULOUS FANTASTIC!

  • Anonymous
    November 07, 2013
    Thanks for appreciating Nite0wls, I'm delighted to know my blog helped resolve your issue...!!!

  • Anonymous
    November 07, 2013
    Hi Saliu, Yes, it should still work. If it doesn't, try changing the Windows Registry Editor version and try again. Thanks, Harsh

  • Anonymous
    November 20, 2013
    Harsh - it seems i have gone past the issue but now I am getting rule "number of cluster nodes supported for edition" failed. This is standard edtion sql 2008 r2 with 2 node cluster. The registry entries you mentioned up, were already there so i did not do anything. Please advise.

  • Anonymous
    November 20, 2013
    Hi Saraf...thanks for showing interest in the blog. I believe you're now hitting an unrelated issue. One of the things I'd recommend is that you post your question on the forums so that it can be answered by our experts. It looks to be an environment specific issue. I'd strongly recommend opening a case with Microsoft CSS so that they can review the environment and determine the best corrective action. Regards, Harsh

  • Anonymous
    December 25, 2013
    thanks a lot Harshdeep. It works perfectly!!!

  • Anonymous
    December 26, 2013
    You're welcome Manish. Glad to know it helped.

  • Anonymous
    December 30, 2013
    i haven't found any error that you have mention but my problem is same. I opened setuplog file and found this ending msg: Setup closed with exit code: 0x80070003 can you please help? I am desperately searching all over the internet but i can't find the solution. Actually firstly i have installed it without any problem but after that i had uninstall sql from control pannel and after that  i just want to reinstall and got the same problem....setup window disappear

  • Anonymous
    December 30, 2013
    Hi Hari, Thanks for showing interest in the blog. Can you please confirm if you've followed the steps outlined in the blog specific to the version of SQL that you're trying to install?

  • Anonymous
    January 17, 2014
    Thanks, this worked

  • Anonymous
    January 29, 2014
    Hi to All, I have tried the procedure above but didn't worked for me. I have found a Microsoft tool that did all the work. support.microsoft.com/.../Program_Install_and_Uninstall Run it - choose the second option (manually to check what to fix) then choose uninstall and select the Microsoft SQL Server Database Engine..(or other thing starting with Microsoft SQL Server) Start the tool as many times as objects like Microsoft SQL Server are shown in the list Hope this helps to anyone

  • Anonymous
    January 31, 2014
    Hi HarshDeep...  your thread had been recommended to me by way of another blog thread. :-)  My question to you, regarding your steps above following the registry steps,  I use a .exe for installing SQLServer2008 R2 from microsoft.  How do i get to the individual program/folders, i.e. setup.exe, X64/X86 folder and the Resource folder if the install is a .exe?  Sorry if this question sounds a little simple, am I missing something in your steps?   Take Care and thank you for your help. Mark Saunders

  • Anonymous
    January 31, 2014
    Hi Mark, Thanks for reaching out. I believe the original setup media comes as an ISO file, which, when mounted, should show you all the folders mentioned above. In case you're trying to install the Express edition, which does come as an exe, you can use the /x switch from the command prompt to extract it. It should look like this: c:><SQLExpressExeName> /x Hope this helps.

  • Anonymous
    January 31, 2014
    Hi Goran, I believe that even though the symptoms you faced might have been similar, the issue was rather with some corrupted keys in the registry of the server you were working on. This blog talks about a scenario where the registry keys are not corrupted. Regards, Harsh

  • Anonymous
    February 06, 2014
    Excelente, gracias por el aporte, tenia rato sufriendo con la instalacion

  • Anonymous
    February 06, 2014
    Eres muy Bienvenido Bruno...!!! Gracias por apreciar...!!!

  • Anonymous
    February 11, 2014
    The comment has been removed

  • Anonymous
    February 16, 2014
    Excellent thats work fine... for me. Thank you

  • Anonymous
    February 18, 2014
    I followed your steps but no luck. I have sent you the logs on your email address mentioned in the above thread. just not sure if its the OS which is causing the issue. I am using win 8.1

  • Anonymous
    February 18, 2014
    Thanks a lot Ruben for appreciating.

  • Anonymous
    February 18, 2014
    Hi Abhijeet, Thanks for showing interest in the blog, and for reaching out. SQL Server setup can fail for a variety of reasons, and the issue you're facing seems to be different from the one outlined in this blog. If you have already tried the steps mentioned in this blog, please post your issue on msdn forums to get it answered by our community of experts. You can also open a support case with Microsoft CSS to have a support engineer troubleshoot the issue. P.S. SQL Server standard edition is supported on windows 8.1 (but not enterprise). Hope this helps. Regards, Harsh

  • Anonymous
    February 23, 2014
    My system is 2012 MSSQLSERVER developer with WIN8.1. After entering product key, install setup files screen showed up & then just disappeared. (running setup from DOS shows that it appears to just hang) Your instructions above for 2012 didn't work for me: I got "SQM Service: Sqm does not have active session." in Detail_ComponentUpdate.txt WIN8.1 may not support 2012-developer by support.microsoft.com/.../Program_Install_and_Uninstall as the "run now" button is blacked out; below that, "We're sorry, but your operating system is not supported by Microsoft Fix it at this time." HarshDeep, if possible, please leave your email so I can email you. Thanks, John

  • Anonymous
    February 25, 2014
    Thanks Harshdeep for your piece of information:  c:><SQLExpressExeName> /x  this did help. My Apologies for the delay in getting back to you with the THANK YOU.. :-) Take care

  • Anonymous
    February 25, 2014
    Hi JohnLee, you can email me on Harshdeep_singh@hotmail.com Thanks, Harsh

  • Anonymous
    February 25, 2014
    You're very welcome Mark, glad to know it helped..!!!

  • Anonymous
    February 25, 2014
    Thanks a lot for this!

  • Anonymous
    February 26, 2014
    You're very welcome Adrian...thanks for appreciating...!!!

  • Anonymous
    February 28, 2014
    Why can't Microsoft make things that actually work

  • Anonymous
    February 28, 2014
    I have a SQL Server 2012 installation and the registry key and fiiles were already there but still get this issue.

  • Anonymous
    March 03, 2014
    Hi Alex, Thanks for showing interest in the blog. So far as I know, there's not a single software in the world that works perfectly, in every environment and use case, 100% of the time. To be able to better assist you, I need to take a look at the logs. It would be great if you can paste the content from the SQLSetup.log and SQLSetup_1.log in the %temp% folder (as discussed in the initial portion of this blog. Thanks, Harsh

  • Anonymous
    March 04, 2014
    Thank you. You solved my problem with sql2008R2.

  • Anonymous
    March 05, 2014
    this explanation is too hard ... can you give an easy direction ???? please email  me the easier direction or post  another easy direction  here ............   ogonna.collins@hotmail.com

  • Anonymous
    March 15, 2014
    I have the same.problem as outlined above, but mine is slightly different as I don't see the the error msg. I could see the code though...

  • Anonymous
    March 16, 2014
    Thanks Surikov...glad to know it helped.

  • Anonymous
    March 16, 2014
    Hi Collins, Thanks for showing interest in the blog. I apologize if the instructions seem too hard, but this is the only way I know of solving this issue . Maybe you want to show this to one of your senior DBA's? Do feel free to reach me on Harshdeep_singh@hotmail.com Thanks.

  • Anonymous
    March 16, 2014
    Hi Adnan, Thanks for showing interest in the blog. If you look closely, the symptoms are that the setup disappears without an error message. However, you should still see the following messages in the SQLSetup or SQLSetup_1  log: 04/16/2012 17:16:47.950 Error: Failed to launch process 04/16/2012 17:16:47.952 Error: Failed to launch local setup100.exe: 0x80070003 Hope this helps.

  • Anonymous
    March 18, 2014
    Thanks a lot :)))) :D

  • Anonymous
    March 19, 2014
    You're welcome San...thanks for appreciating...!!!

  • Anonymous
    March 19, 2014
    Hi there,   I did try your way, but I can't merge the registry value and I got this error: This program is blocked by group policy, for more information contact Systems Administrator. Would you please advise? Thanks!

  • Anonymous
    March 19, 2014
    The comment has been removed

  • Anonymous
    March 19, 2014
    Hi Harsh, Thanks so much! It works!

  • Anonymous
    March 19, 2014
    You're welcome Patch...glad to know it worked...!!!

  • Anonymous
    March 25, 2014
    Awesome, it worked for me ;-). Many thanks. You saved my day.

  • Anonymous
    April 02, 2014
    Thanks It worked for me. Worked on this for many days but not able to solve the issue. Thanks following these steps solved my problem. thanks once again.

  • Anonymous
    April 04, 2014
    Thanks a lot Ayu and Praveen. Glad to know my blog helped.

  • Anonymous
    April 09, 2014
    You are just awesome. I was stuck for hours...

  • Anonymous
    April 13, 2014
    Thanks for appreciating Sukhi...happy to be of help...!!!

  • Anonymous
    April 14, 2014
    Thanks it worked for me as well!!

  • Anonymous
    April 17, 2014
    Can you please explain how to "Save the following in a .reg file and merge to populate the registry:" I don't understand what that means. What do I save it as? Thanks.

  • Anonymous
    April 19, 2014
    The comment has been removed

  • Anonymous
    May 15, 2014
    Thanks for posting this. I followed the instructions for SQL 2012 and I'm now being prompted with "Browse for Folder." I've tried pointing it at the folder setup.exe is in, but no joy.

  • Anonymous
    May 18, 2014
    The comment has been removed

  • Anonymous
    June 05, 2014
    For those who have difficulty installing Microsoft SQL Server 2014 just change the path 110 to 120 and the patchlevel to 12.0.2000.80

  • Anonymous
    June 05, 2014
    Great, I have been in deep... now sun is shining again. Thanks.

  • Anonymous
    June 05, 2014
    Thanks a lot, it did solve my problem Harshdeep

  • Anonymous
    June 06, 2014
    Thanks alachowski and Mohammed Hanif for your kind words..I am glad you found my blog useful.

  • Anonymous
    June 06, 2014
    Hi Sheoib, Thanks for the tip. However, I believe just those two steps are not sufficient. I have updated the blog to include the steps for SQL 2014 as well.

  • Anonymous
    June 25, 2014
    hi i tried your solution but ti doesnt work for me.. im running windows 7 pro x64 and trying to install sqlserver 2008 enterprise.. the setup still disappears, and one thing more, there is no resources folder on the destination drive.. i  tried also to delete the C:Program FilesMicrosoft SQL Server100 folder after trying ur solution but still no luck.. thanks.

  • Anonymous
    June 25, 2014
    The comment has been removed

  • Anonymous
    June 25, 2014
    Hi Harsh, Thankf for the blog -- I am facing this issue while installation of SQL 200r2 express advance edition os - 2k8 earlier - sql experess was installed now i have remvoed it... 06/26/2014 11:28:10.598 SQM: SqmWaitForUploadComplete() returns with failure 06/26/2014 11:28:10.630 Setup closed with exit code: 0x80070003 06/26/2014 11:28:10.645 any help

  • Anonymous
    July 07, 2014
    Harshdeep Paaji, Thanks man, that helped a ton. Just for the record, I needed to move EVERY file from the setup extraction [SQL Express 2012] to C:Program FilesMicrosoft SQL Server110Setup BootstrapSQLServer2012; not just the ones you mentioned. Otherwise I kept on receiving an error stating that the version was not compatible with the media. Thanks again! -Jaz

  • Anonymous
    July 12, 2014
    The comment has been removed

  • Anonymous
    July 19, 2014
    Hi, i am going to install sql 2008 r2 enterprise edition in my laptop i.e windows 7. before that i used sql server 2008 express edition. i just uninstalled express edition and trying to install sql 2008 r2 enterprise edition but when i start installation after giving product key and clicked on 'install' button it will disappears installation and end the installation. there is no error message i saw. i tried above steps for first time installation but all services not installed then i uninstalled  and for second time installation folder 'bootstrap' is not found in 'C:Program FilesMicrosoft SQL Server100'. please i need suggestions and guidance. thank u in advance....:

  • Anonymous
    July 21, 2014
    Thanks for sharing this Harsh Deep ..The blog helped me a lot.

  • Anonymous
    July 23, 2014
    I have the same problem. I changed bootstrap setup location, but have no effect. Then i have found solution. For successful instalation of SQL 2012 on 2012 servers check that you use the same: OS localization, format, interface language and the SQL intallation language/localization.

  • Anonymous
    August 01, 2014
    I also just had this problem, but I haven't seen my solution anywhere so I thought I would contribute.  I was installing SQL Server on Windows Server 2012 R2 evaluation edition in hyper v.  The Server Evaluation Edition lasts for 180 days but it still has to be activated.  If you don't activate it, after 10 days it will start restarting itself every hour (I believe this is what also happens after 180 days).  Activation happens automatically once you connect the machine to the internet. What I had done is allow this 10 day period to elapse, and I hadn't connected the machine to the internet.  I then tried installing SQL Server and got this error.  The key was activating windows server.  After I activated it, I was able to install SQL Server without any issues.   Note that the fix above also worked for me.  I was able to install SQL Server on Windows Server 2012 R2 that hadn't been activated and had gone over 10 days as well. Just something else to try anyway!

  • Anonymous
    August 13, 2014
    It worked like a charm. You are so amazing. Thank for your helpful post.

  • Anonymous
    August 18, 2014
    Hi Sachinsingh, 0x80070003 basically means windows error 3, which stands for "the system cannot find the file path specified". I would request you to verify that all the paths used in the installation exist (and the account running setup has full control on those paths) and then try again.

  • Anonymous
    August 18, 2014
    Hi Jaz..thanks for sharing your experience. This blog only covers the installation of full editions of SQL. The requirements and steps can be different for SQL Express. Thanks.

  • Anonymous
    August 18, 2014
    The comment has been removed

  • Anonymous
    August 18, 2014
    The comment has been removed

  • Anonymous
    August 18, 2014
    Thanks a lot Lavanya for appreciating...happy to know the blog helped.

  • Anonymous
    August 18, 2014
    hi Bazz, thanks for sharing that information. The solution that you mentioned is actually a known one, and Microsoft support has for several years recommended to keep the localization, language, etc. for SQL  the same as the OS. Thanks.

  • Anonymous
    August 18, 2014
    Hey Andy, thanks for sharing that very interesting experience of yours. I would say having a registered and activated copy of windows is pretty much a prerequisite for SQL Server installation, so in a way that behavior was expected. Thanks for the detailed write-up though.

  • Anonymous
    August 18, 2014
    Thanks a lot Nguyen for appreciating...happy to know my blog helped.

  • Anonymous
    August 21, 2014
    i have uninstalled sql server 2012 for some reason, again i tried to install sql server 2012 it is installed successfully, but unable to login, it is showing soem 40 error, before it was working fine. i want to install SSIS so in uninstalled. pls send me mail to 'mmanikandan681@gmail.com', i did not uninstalled properly

  • Anonymous
    August 27, 2014
    Dear Mr.Harshdeep sinur systemgh when i uninstalling sql server 2008 r2 setup file from control panel it shows error that it could not be uninstall some another file install in your syatem File Name - sql server rsfx error-26003 pleae help me very soon Regards, upendra sharma

  • Anonymous
    August 29, 2014
    Here what is media ..what it refers

  • Anonymous
    September 12, 2014
    Aoa, I have following Error during installation. TITLE: SQL Server 2008 R2 Setup

The following error has occurred: Could not write value  to key SOFTWARE.   Verify that you have sufficient access to that key, or contact your support personnel. For help, click: go.microsoft.com/fwlink

  • Anonymous
    September 12, 2014
    Hi mani...thanks for showing interest in the blog. It seems that the symptoms you're facing are different from the ones outlined in this blog. Please call into Microsoft CSS and get a support ticket opened. They should be able to help you out.

  • Anonymous
    September 12, 2014
    Hi Upendra...thanks for showing interest in the blog. It seems to me that you need to need what's known as a manual cleanup. Unfortunately, that is a very complex operation and shouldn't be performed without the live supervision of a sql server expert. I would request you to call into  Microsoft css and get a support ticket opened. They should be able to help you out.

  • Anonymous
    September 12, 2014
    Hi Adithya...media refers to the setup/sql server installation media. Thanks.

  • Anonymous
    September 12, 2014
    Hi Shafaqat...thanks for showing interest in the blog. Please make sure the account from which you're running setup is an administrator on the server where the installation is being performed. Hope this helps.

  • Anonymous
    September 12, 2014
    hi sir i used administrator account and have full rights but problem is still and please check your email account

  • Anonymous
    September 16, 2014
    HarshDeep_Singh  you there? i have a problem and i send email with complete info

  • Anonymous
    September 16, 2014
    I tried installing sqlserver 2008r2. How do i get this to work using your steps. How do i modify the registry step by step to achieve this

  • Anonymous
    September 16, 2014
    would you pls email me step by step on how to get my sqlserver2008r2 on windows 8.1@ozotieno@gmail.com

  • Anonymous
    September 27, 2014
    Hi Harsha Deep, I am installing cluster sql 2012 while installing on passive node, getting same issue , can you suggest me I ddnt not understand,  @registry key levels.

  • Anonymous
    October 10, 2014
    Hello i dont know what  does this mean by "Save the following in a .reg file and merge to populate the registry" all of those words, does it mean i need to save it in regedit(meaning "modify or adding to regedit" ?) and what does it mean by "merge to populate the registery"? and how to do it ? sorry if this's some kind of a trouble question, im really tired because of searching of how to fix the sql server 2008 r2 for 4 hrs, and now, i also got this error,,, OMG. x-x and its around 4 am now ... x-x

  • Anonymous
    October 16, 2014
    Thanks - very useful article!

  • Anonymous
    October 17, 2014
    Buenos tardes, Veo que esta solución ha trabajado en bastantes casos. Tengo una duda respecto a los archivos reg. donde lo debo guardar o ubicar... Muchas gracias

  • Anonymous
    October 17, 2014
    Hello, I´m sorry... i have the same problem but i dont undertand this step´ "1. Save the following in a .reg file and merge to populate the registry: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server100Bootstrap] "BootstrapDir"="C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap&quot; [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server100BootstrapSetup] "PatchLevel"="10.50.1600.00"" Can you explain me how to do that? Thank you!

  • Anonymous
    October 20, 2014
    Hi All, Thank you for the tremendous response and interest in this blog. Considering the number of comments about the steps to modify the registry, I've modified the blog to explain those steps in much better detail. I hope this helps. Regards, Harsh

  • Anonymous
    November 10, 2014
    Its Working Properly.. Nice Tip Thank You Bro...!

  • Anonymous
    November 14, 2014
    Hello, Thank you very much. Very usefull post

  • Anonymous
    November 17, 2014
    Thanks a lot Ajay and jcmanjar for your kind words. I am glad to know the blog helped.

  • Anonymous
    November 18, 2014
    Hi Harsh Deep, Thank you very much. Very useful post. Followed same steps given by you and it is working fine.

  • Anonymous
    November 18, 2014
    Hi , Getting error while creating a new database. Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (SqlMgmt) Please suggest me Thanks Madhu

  • Anonymous
    November 23, 2014
    Worked perfectly for a SQL Server 2008 R2 install. Thank you !!!!

  • Anonymous
    December 08, 2014
    Hi Madhu, Thanks for expressing interest in the blog. I am glad to know the install was successful. Unfortunately, I believe the database creation error is unrelated to the topic discussed in this blog post. I would suggest you post your question on msdn forums to get the fastest and most relevant resolution. Regards, Harsh

  • Anonymous
    December 08, 2014
    Thanks a lot Sivaji, I'm glad to know the solution worked for you. Cheers, Harsh

  • Anonymous
    December 09, 2014
    Thanks so much  ..

  • Anonymous
    December 11, 2014
    This really saved my day ..thank you so much!!

  • Anonymous
    December 22, 2014
    For those having license error (Error code 0x858C001B), you need to do the following as well.. Delete the following keys in regedit:

  1. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server
  2. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
  3. Go to HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionUninstall  and delete all the sub-keys referencing SQL Server.
  4. Go to HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServices and delete all the keys referencing SQL Server.
  5. Delete all the SQL Server folders in the computer
  6. lastly go to control panel and uninstall all SQL server installations if still there..
  7. Then run the registry file given by HarshDeep again.. Now run the setup again.. it should work.

  • Anonymous
    January 07, 2015
    That was really useful. Thank you very much

  • Anonymous
    January 08, 2015
    I did exactly like you said but it disappeared too

  • Anonymous
    January 14, 2015
    When I try to install SQL Server 2012 setup disappears/fails when installing Setup Support files I tried to manually delete SQL Developer and damaged the registry. The folders Bootstrap are not present [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server110Bootstrap] "BootstrapDir"="C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap&quot; [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server110BootstrapSetup] "PatchLevel"="11.00.2100.60" This file creates this error-The specified file is not a registry script. You can only import binary files IS there actually a way to start from scratch (clean slate) after  deleting all SQL Server files that may have been partially installed and all registry keys?

  • Anonymous
    January 14, 2015
    Hi All, thanks for your kind words. I am glad you found the blog useful.

  • Anonymous
    January 14, 2015
    The comment has been removed

  • Anonymous
    January 15, 2015
    Hi Harsh Depp, Thank you very much. Really helpfull post.

  • Anonymous
    January 28, 2015
    Great Content! Thanks for sharing. --Prashanth

  • Anonymous
    February 02, 2015
    thank you very much sir its working now

  • Anonymous
    February 04, 2015
    The comment has been removed

  • Anonymous
    February 04, 2015
    just re- run the install using admin permissiona nd got 0x84C40013

  • Anonymous
    February 09, 2015
    Install Microsoft FixIT and remove all SQL server entries and it works!

  • Anonymous
    February 28, 2015
    Thanks Harsh its working.. :)

  • Anonymous
    March 05, 2015
    sir ,i m installing sql server 2008 r2 .bt after installing setup support rule screen will diappear,so i did all steps that you mentioned above but still showing same error.what to do sir ????

  • Anonymous
    March 08, 2015
    The comment has been removed

  • Anonymous
    March 12, 2015
    Hi sir, I'm installing SQL server 2008 on my windows 7 laptop. I'm facing the problem setup will disappears while installing so, i did ur solution after that i will click the setup file it shows that ur operating system is of x86 architecture. The media is not supported for installing. Please give me a solution

  • Anonymous
    March 25, 2015
    Great thanks !"!!!

  • Anonymous
    March 29, 2015
    Thanks Dear... It worked.. and saved my time..

  • Anonymous
    April 07, 2015
    Thanks for sharing this!!! Just one thing. You need to copy also SQLSETUPBOOTSTRAPPER.dll with setup.exe. Without that you may get error about missing dll. Hope it helps.

  • Anonymous
    April 15, 2015
    I tried in Sql Server 2008 R2 but i didnt solved my problem

  • Anonymous
    April 20, 2015
    The comment has been removed

  • Anonymous
    April 20, 2015
    Hi All, Thank you so much for your kind words. I am glad to know the blog helped resolve your issue. Regards, Harsh

  • Anonymous
    April 23, 2015
    hi Harsh sir , harshavardhan Here so please help us , when Start  Set-up of SQL 2008 R2 support file has been completed after that Not geting Respon From Sql Setup  so What Should I do?

  • Anonymous
    May 03, 2015
    The comment has been removed

  • Anonymous
    May 11, 2015
    Thanks a bunch. It works for me on SQL 2014 TITLE: SQL Server Setup failure.  SQL Server Setup has encountered the following error:  The system cannot find the file specified.

  • Anonymous
    May 12, 2015
    Dear Mr. Hardeep, I'm installing SQL 2008 R2 but it comes out after support file installation. I have checked the log and found    " Setup closed with exit code: 0x84C40013" Please inform me what we have to do ??

  • Anonymous
    May 25, 2015
    I thought I had to reinstall everything again, but your post saved me a lot of struggle, thanks a lot In my case I also had to copy the PCUSOURCE and the 1033_ENU_LP folders Thanks

  • Anonymous
    June 04, 2015
    i made a bad mistake plz help asap....i forgot to backup the registry and now the setup is not running at all..how can i undo the changes in registry...

  • Anonymous
    June 12, 2015
    hi i am facing this problem while installing db2 client in windows server 2008. when i click setup file launch pad not appearing. kindly provide me solution

  • Anonymous
    June 24, 2015
    I am trying to install sql server 2008 r2 standard on Windows server 2008 r2 enterprises 64 bit edition. but setup hangs on installation like "Install_Sqlncli_cpu64_Action: InstallInitialize " or :Removelog/Logfiles. taking 2-3  hours on single instance. I have read many threads but unsuccess. Start Installation in morning but in evening around 7 pm i have to shut down my server but not install complete yet.Please help me . my id is : kumarvijen@yahoo.com

  • Anonymous
    June 25, 2015
    Good work. It solve my problem. Thanks

  • Anonymous
    July 20, 2015
    I got those files I have tried but still I stuck at the same place

  • Anonymous
    July 23, 2015
    hi, i'm installing SQL server 2008 R2. I unable to install. Every times after my installation on the Setup support files, it does not progress to next setup which is setup support rules. Please help and i can't find this path. Thanks Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server100Bootstrap] "BootstrapDir"="C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap&quot; [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server100BootstrapSetup] "PatchLevel"="10.50.1600.00"

  • Anonymous
    July 29, 2015
    Hi, this worked for me, I had an error which said that you are at same level as the installer media. sorry could not get the log file. Thanks for the tip. Anoop

  • Anonymous
    July 29, 2015
    The comment has been removed

  • Anonymous
    August 23, 2015
    I am trying to install SQL server 2012 on window 10...Using your method i get an error 0x858C001B. Kindly help me with this

  • Anonymous
    August 31, 2015
    HI I have encountered the same problem, may i know how this thing happened? due to???

  • Anonymous
    August 31, 2015
    TITLE: Microsoft SQL Server 2014 Setup

BUTTONS: &Retry Cancel

  • Anonymous
    September 10, 2015
    how to find the error when " .exe" file runing,but not showing any thing and log files are not created while installing the sql

  • Anonymous
    September 17, 2015
    Try using Long Path Tool program this is very helpful!

  • Anonymous
    September 17, 2015
    Try using the Long Path Tool, this really helps!

  • Anonymous
    September 28, 2015
    Hi there, you didn't mention where to create the .reg file and what to name it? thanks,

  • Anonymous
    October 08, 2015
    Hi, I have done the  all 2 steps for  SQL Server 2008 R2 installation but still setup file disappearing after clicking  Run as administration option. I am not able to install SQL server 2008 r2 setup on Windows 7 ultimate edition. Setup file is not starting for installation. Please help me, I will be very thankful. mail id- gaurav.shri28@gmail.com

  • Anonymous
    November 30, 2015
    Thanks for your solution harsh..

  • Anonymous
    February 18, 2016
    please help,when i change the sqlsetup.reg then double click, it says that cannot import, due to specified file is not a registry script. this is the 1st step so what can i do? please help.

  • Anonymous
    March 27, 2016
    hey i have the same issue with sql server 2008 R2. I have followed your first step but i am confused about second step which file we have to copy on destination. what is that setup.exe and resource folder. in my pc i had only this much folders C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap and in setup bootstrap their is only folder named log. please guide me to solve this issue.

    • Anonymous
      April 05, 2016
      Hi Ashlesha, if you don't see the destination folders, then you need to create them. Thanks, Harsh

  • Anonymous
    March 27, 2016
    Hi,I have Windows 7 Ultimate Service Pack 1 OS installed on my computer. While installing SQL Server 2012/2014 in the starting or in the middle fails installation and shows Scenario Engine Has Stopped Working. I have tried too many times unfortunately closing or system will gets shutdown. Please help me on this.Thank You.