Home
[Solved] Error 29506 when installing Microsoft SQL Server Manament Studio Express on Windows Vista or Windows 7

[Solved] Error 29506 when installing Microsoft SQL Server Manament Studio Express on Windows Vista or Windows 7

December 3, 2011 Administration 122 Comments

Note: This article is applied on installing Microsoft SQL Server Management Studio Express which is used for manage Microsoft SQL Server 2005 Express only.

When you are installing Microsoft SQL Server Management Studio Express on Windows Vista or Windows 7, you may receive this error message:

The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 29506.
Error 29506

This error message relates with permission issue (UAC) on Windows Vista and Windows 7. To solve this problem, you have to re-run the installer again using elevated command prompt by run the command prompt as administrator and execute the installer in there. If you are using 64-bit Windows, you should use the command prompt at C:\Windows\SysWOW64\cmd.exe instead. Otherwise, you can use the command prompt at C:\Windows\System32\cmd.exe. You will see the step-by-step guide to use elevated command prompt to execute the installer file on the section below.

The other solution, you can disable UAC on Windows but I don’t recommend it since it will lower your security system.

Step-by-step to fix error 29506

  1. Run elevated command prompt by right-click on Command Prompt in Start -> All Programs -> Accessories -> Command Prompt and select Run as administrator.
    Note: This step is for 32-bit Windows. If you are using 64-bit Windows, see the next step.
    Open Command Prompt as Administrator
  2. If you are using 64-bit Windows, you have to run the command prompt in C:\Windows\SysWOW64. Right-click on cmd.exe and select Run as administrator.
    Open Command Prompt as Administrator For 64-bit Windows
  3. On User Account Control, click Yes.
    User Account Control
  4. On Command Prompt (both 32-bit and 64-bit Windows), change path to directory where the installer file is and execute the file. By default, the file name for 32-bit version is SQLServer2005_SSMSEE.msi and 64-bit version is SQLServer2005_SSMSEE_x64.msi.
    Execute the installer file
  5. On Setup Wizard, follow the instruction as usual. There won’t be the error message this time.
    Microsoft SQL Server Management Studio Express Setup

Related Posts

122 Comments

  1. Oren December 31, 2011

    Thank you for this tip, it worked like charm!

  2. Khat Wai January 3, 2012

    Thz for this solution.It’s powerfull.

  3. Manesh Khaire February 10, 2012

    Very very thanks for this. Its work for me after a lot of fighting to install the SQLServer2005_SSMSEE.msi.

  4. Sujoy March 23, 2012

    Thanks a ton for the post . It was helpful .solved

  5. Asfand April 5, 2012

    Excellent post. It worked for me 🙂

  6. timothy April 18, 2012

    lovely! worked a treat – cheers

  7. Ankit April 19, 2012

    Thnks alot . Sir

  8. Brandon May 4, 2012

    Thanks for tutorial, Lol, I couldn’t find any that were decent or that made any sense.

    Regards,

    Brandon.

  9. Alesanro May 5, 2012

    Thanks a lot. Came in handy.

  10. Syed rafi May 16, 2012

    Thans a lot…

  11. hemant_rao8767682431 June 19, 2012

    thnks a lot man..its wrking

  12. mohim June 30, 2012

    thanks alot alot alot

  13. laura July 2, 2012

    when i run it, it goes immediately to the end of the install, but does not give error, nor does it seem to install.. it is immediate. i was getting the error before. any idea why??? It seems when you run from the command prompt, the UI screens are not showing. i am on win7x64.. thanks

  14. Amey July 17, 2012

    Thanks..its working

  15. Alan July 27, 2012

    I followed the steps starting with step 2. I am running Windows7 Professional on a 64 bit operating system. I am getting the error message each time I try to run the installer. I was logged in as Administrator from the beginning.
    Thanks,
    Al

  16. yogesh August 4, 2012

    thanking you a lot

  17. Sura August 16, 2012

    Thanks a million. that was really helpful.

  18. Abdo September 8, 2012

    error againnnnnnnnnn

  19. Mujtaba September 9, 2012

    Thanks a lot!
    Was trying for 2 weeks!
    i am using win 7 on 64 bit and i used start menu search for opening cmd as administrator and it worked

  20. dwipa rachmawan September 26, 2012

    terima kasih (thank you).
    it works.

  21. chanra sekhar October 2, 2012

    hi this is chandra. i am using o.s. is windows 7 64 bit for installing Microsoft SQL Server Management Studio Express
    i tried what you mention in above and install successfully. But when i trying to run that time server name is not showing(empty) then i put my system name and system name\sql express BUT NOT CONNECTING. 2 time i uninstall and install but same problem is showing pl z tell me solution Thank you!

  22. Rodney October 16, 2012

    Thanks. This works perfectly.

  23. EcObO October 23, 2012

    Muy buen tip amigo, muchisimas gracias.

    Dios te bendiga

    EcObO

  24. Tatiana November 1, 2012

    Easy and fast!! THANKS

  25. Irek_W November 5, 2012

    Wielkie dzięki! Great thanks. Second week oneself I from this tired.

  26. Shashi November 8, 2012

    Thanks

  27. Danielle November 11, 2012

    No meu caso dá um erro diferente 29508…

  28. Thaer Hamayel November 22, 2012

    Many thanks

  29. Ramón November 22, 2012

    Thanks a lot. Your post saved me a lot of time.
    I hate when Microsoft products don’t work or even install under Microsoft OS.

  30. daniel December 4, 2012

    thanks a lot

  31. Abdul Jabbar Patel December 17, 2012

    Thanks its works fine… and solved my problem…
    Thanks again……………

  32. Raj January 4, 2013

    kadak solution
    scolar……!!!!!!!!

  33. btaz125 January 15, 2013

    Great! Thank you so much. Works fine

  34. sabarish January 18, 2013

    thank you so much!!!! its working 100%

  35. mustafa January 19, 2013

    thank youuuuuuuuuuuu!!!!

  36. Sunil Desai January 22, 2013

    Thanks a lot. It worked.

  37. Ryan Boudreau January 25, 2013

    Thanks! Saved a lot of frustration!

  38. Fernando January 26, 2013

    Excelent … well done !!!

  39. Prafful Kambarkar February 1, 2013

    You awesome big guy :)..Thanks..its work

  40. fisal February 2, 2013

    thanks it helped me so much

  41. elyza February 18, 2013

    hi I can’t install ms sqlserver 2005 express edition and it always end up with this error [“None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. to continue, click BACK and then select features to install. To exit SQL Server Setup, click Cancel”]
    but when I go back i can’t find the features that should be selected.

    can you please help me 🙁
    badly need for our thesis…

  42. elyza February 18, 2013

    by the way I am using windows 7 ultimate 32-bit operating system.

  43. elyza February 18, 2013

    hi I can’t install ms sqlserver 2005 express edition and it always end up with this error [“None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. to continue, click BACK and then select features to install. To exit SQL Server Setup, click Cancel”]
    but when I go back i can’t find the features that should be selected.

    can you please help me 🙁
    badly need for our thesis

    buy the way Iam using windows ultimate 32-bit operating system.

  44. felix March 1, 2013

    thanks a lot it has worked

  45. Danie Ezhuva March 4, 2013

    THANK YOU IT REALLY WORKS…

  46. Đỗ Văn Nghĩa April 18, 2013

    – it’s good fix, thank you.

  47. vasudevan May 7, 2013

    sir…
    sql server is opening and shortly closing immediately….
    I reinstall that too..but till I have the problem… can u help me…

  48. Robi May 30, 2013

    THANK YOUU!!!!!!!!!!!

  49. Fang July 4, 2013

    it’s good fix Great thx

  50. vishnu July 8, 2013

    Thank you sir…it’s very helpfull..

  51. subrat August 14, 2013

    thanks a ton bro!!

  52. Yaddi August 16, 2013

    You saved my live, thanks!!!!!!!!!

  53. Apurva August 27, 2013

    Thanks, it worked …

  54. waheed October 2, 2013

    Great, its working

  55. Thiago November 19, 2013

    você e zika cara VLLLLLW!

  56. rijesh December 5, 2013

    Thanks a lot!!!
    It worked…

  57. nitin December 31, 2013

    Thanks its works perfectly. I was just stuck at the problem. I am using win 7.
    Once again thanks.

  58. Kanchan Jadhav January 20, 2014

    Thanks a lot sir !!! It works….

  59. Javier M February 4, 2014

    Thanks a lot! Worked great on my W7 x64 PC.

  60. Ahmed Elsaka February 14, 2014

    Thanks a lot

  61. Malika Niroshana February 18, 2014

    Thank you !!!! its working 100% on my W7 x64 PC.

  62. vutruongcong March 28, 2014

    thx alot.
    Cam on nhieu

  63. khalid badalkar April 8, 2014

    Thanx for who ever post it its works me alot…….

  64. Subhajit Seth May 19, 2014

    thanks it work perfectly………

  65. amitendra May 25, 2014

    Great man,,, thanks

  66. Muhammad Aftab Javed May 29, 2014

    Thanks, it works!!!

  67. Kibiki June 16, 2014

    Thanks very much it worked fine…

  68. Ablafizi June 16, 2014

    I though it could be difficult, but not and it worked fine for me.. “thanks alot”

  69. Choi June 22, 2014

    Thanks a lot!
    It work thru the cmd.exe!

  70. Adrien July 21, 2014

    Work for me too !!

    Thank you very much !!!

  71. Gaurav May 10, 2015

    Worked like a charm..thanks man

  72. narendra May 28, 2015

    great deed!!

  73. salim nicolas July 4, 2015

    Thank you Bro ! …

  74. Maldeniya Kusal August 7, 2015

    Thankz a lot,,,,,,,,,,,,,,,,,,,,,i’m do it #%@*

  75. Ari August 25, 2015

    Worked for me in windows 8
    Thanks alot

  76. trungpq September 5, 2015

    Thanks

  77. Norm September 19, 2015

    worked like a charm. Thanks.

  78. latheesh November 2, 2015

    Thanks.its working

  79. Gedas December 25, 2015

    Thanks. Big LIKE

  80. Marius January 10, 2016

    After hour of pain i finally find the answer. You are great. 10x

  81. Babithaputtuswamy January 10, 2016

    Thanks a lot… it worked for windows vista 🙂

  82. Eugene January 29, 2016

    how come it mentioned “SQLSever2005_SSMSEE_x64.msi ” is not recognized as an internal or external command, operable programme . or batch file ?? does it works to windows10

  83. linglom January 31, 2016

    Hi Eugene,

    It’s working fine for me. I can install and open it on Windows 10. I suggest you try to re-download the file again.

  84. Rakz February 22, 2016

    Beautiful..!!
    got successfully installed. 🙂

  85. Ali February 27, 2016

    It worked thanks brother

  86. Sanjay Sharma March 9, 2016

    Very Nice Solution ….
    Thanks a lot, Problem Solved

  87. Maha Ali March 14, 2016

    please help me too to solve this issue

  88. Maha Ali March 14, 2016

    please help me too to solve this error 29506
    i am not able to execute through command prompt
    please write to me the steps how you solved it
    thanks in advance

  89. linglom March 14, 2016

    Is there any error message? Which step did you have trouble?

  90. Maha Ali March 14, 2016

    i am not able to write the path of SQL file in command prompt
    i opened cmd as administrator and then i opened SQL setup by writing start command in cmd

  91. Maha Ali March 14, 2016

    i followed above mentioned steps and opened cmd as administrator but i am not able to write the SQL setup file path in cmd so i opened it by writing start command and received the same error code 29506 again

  92. linglom March 15, 2016

    Did you mean that you can’t change path to folder where the setup file is? What’s the error?
    Can you try to move (or copy) the setup file to the path (c:\Windows\system32) so you don’t have to change path on cmd.exe?

  93. Maha Ali March 17, 2016

    Thanks a lot
    It solved now 🙂

  94. Raju Kumar April 6, 2016

    Very very thanks for this error solution. Its work for me after a lot of fighting to install the SQLServer2005_SSMSEE.msi.

  95. maha ali April 9, 2016

    Hello sir
    my SQL server 2005 express not connecting with database engine

  96. mame May 19, 2016

    really I would like say to you thank you!!!!!!!!!!!!

  97. Lini June 14, 2016

    Thanks a lot. It worked

  98. Ankit June 22, 2016

    Thanks a lot.. Its superb and directly to the point.

  99. Jack July 5, 2016

    Thank you very much.

  100. Rainer July 18, 2016

    Thank you so much! It’s still working! 🙂

  101. sooraj July 28, 2016

    Thanks alot..worked for me

  102. periyasamy August 11, 2016

    thanks its worked for me

  103. param January 3, 2017

    this post is most helpfull. ty

  104. Muthuraj February 8, 2017

    Thank you old sport….

  105. Yofika Dwi March 7, 2017

    big thanks. ferry ferry thanks

  106. Mark September 28, 2017

    thanks a lot!! works grt

  107. PB October 9, 2017

    Thanks a million… It worked….

  108. Deepak November 15, 2017

    thanks a lot…..its worked for me……

  109. Sandip Nikam April 6, 2018

    Thank you so much for the helped

  110. Ankit Chakraborty August 17, 2018

    Excellent !! It worked

  111. Erro Shi October 15, 2018

    step 1 : download revo uninstaller
    if need restart your pc,restart your pc
    step 2 : right click SQLServer2005_SSMSEE_x64.msi and instal with Revo Uninstaller.
    thanks

  112. Shivani Kanade February 7, 2019

    IT WORKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!11111

  113. Sunflower May 27, 2019

    Thanks a lot. Worked for me!!

  114. dharmaraju BK September 3, 2019

    Thanks a lot. It is working fine now.

  115. AungTunLinn January 13, 2020

    Thanks you so much.

  116. Lungisa May 10, 2020

    can you please make the commands in the cmd clear

  117. Jimit June 15, 2020

    thanx a lot … worked for me

  118. mamta June 24, 2020

    Thanks !!

  119. durga prasad September 11, 2020

    Its working dude, big thanks.

  120. Nathan October 11, 2020

    It worked. Thanks man!

  121. sh January 1, 2021

    Yes “Run As Administrator” solved this issue.
    For this msi, “Run As Administrator” is possible via command prompt, not right click menu on the msi file.

    Thanks.

  122. jagmet October 19, 2024

    thanks! It worked

Leave a Reply