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

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

121 Comments

  1. Oren December 31, 2011
  2. Khat Wai January 3, 2012
  3. Manesh Khaire February 10, 2012
  4. Sujoy March 23, 2012
  5. Asfand April 5, 2012
  6. timothy April 18, 2012
  7. Ankit April 19, 2012
  8. Brandon May 4, 2012
  9. Alesanro May 5, 2012
  10. Syed rafi May 16, 2012
  11. hemant_rao8767682431 June 19, 2012
  12. mohim June 30, 2012
  13. laura July 2, 2012
  14. Amey July 17, 2012
  15. Alan July 27, 2012
  16. yogesh August 4, 2012
  17. Sura August 16, 2012
  18. Abdo September 8, 2012
  19. Mujtaba September 9, 2012
  20. dwipa rachmawan September 26, 2012
  21. chanra sekhar October 2, 2012
  22. Rodney October 16, 2012
  23. EcObO October 23, 2012
  24. Tatiana November 1, 2012
  25. Irek_W November 5, 2012
  26. Shashi November 8, 2012
  27. Danielle November 11, 2012
  28. Thaer Hamayel November 22, 2012
  29. Ramón November 22, 2012
  30. daniel December 4, 2012
  31. Abdul Jabbar Patel December 17, 2012
  32. Raj January 4, 2013
  33. btaz125 January 15, 2013
  34. sabarish January 18, 2013
  35. mustafa January 19, 2013
  36. Sunil Desai January 22, 2013
  37. Ryan Boudreau January 25, 2013
  38. Fernando January 26, 2013
  39. Prafful Kambarkar February 1, 2013
  40. fisal February 2, 2013
  41. elyza February 18, 2013
  42. elyza February 18, 2013
  43. elyza February 18, 2013
  44. felix March 1, 2013
  45. Danie Ezhuva March 4, 2013
  46. Đỗ Văn Nghĩa April 18, 2013
  47. vasudevan May 7, 2013
  48. Robi May 30, 2013
  49. Fang July 4, 2013
  50. vishnu July 8, 2013
  51. subrat August 14, 2013
  52. Yaddi August 16, 2013
  53. Apurva August 27, 2013
  54. waheed October 2, 2013
  55. Thiago November 19, 2013
  56. rijesh December 5, 2013
  57. nitin December 31, 2013
  58. Kanchan Jadhav January 20, 2014
  59. Javier M February 4, 2014
  60. Ahmed Elsaka February 14, 2014
  61. Malika Niroshana February 18, 2014
  62. vutruongcong March 28, 2014
  63. khalid badalkar April 8, 2014
  64. Subhajit Seth May 19, 2014
  65. amitendra May 25, 2014
  66. Muhammad Aftab Javed May 29, 2014
  67. Kibiki June 16, 2014
  68. Ablafizi June 16, 2014
  69. Choi June 22, 2014
  70. Adrien July 21, 2014
  71. Gaurav May 10, 2015
  72. narendra May 28, 2015
  73. salim nicolas July 4, 2015
  74. Maldeniya Kusal August 7, 2015
  75. Ari August 25, 2015
  76. trungpq September 5, 2015
  77. Norm September 19, 2015
  78. latheesh November 2, 2015
  79. Gedas December 25, 2015
  80. Marius January 10, 2016
  81. Babithaputtuswamy January 10, 2016
  82. Eugene January 29, 2016
  83. linglom January 31, 2016
  84. Rakz February 22, 2016
  85. Ali February 27, 2016
  86. Sanjay Sharma March 9, 2016
  87. Maha Ali March 14, 2016
  88. Maha Ali March 14, 2016
  89. linglom March 14, 2016
  90. Maha Ali March 14, 2016
  91. Maha Ali March 14, 2016
  92. linglom March 15, 2016
  93. Maha Ali March 17, 2016
  94. Raju Kumar April 6, 2016
  95. maha ali April 9, 2016
  96. mame May 19, 2016
  97. Lini June 14, 2016
  98. Ankit June 22, 2016
  99. Jack July 5, 2016
  100. Rainer July 18, 2016
  101. sooraj July 28, 2016
  102. periyasamy August 11, 2016
  103. param January 3, 2017
  104. Muthuraj February 8, 2017
  105. Yofika Dwi March 7, 2017
  106. Mark September 28, 2017
  107. PB October 9, 2017
  108. Deepak November 15, 2017
  109. Sandip Nikam April 6, 2018
  110. Ankit Chakraborty August 17, 2018
  111. Erro Shi October 15, 2018
  112. Shivani Kanade February 7, 2019
  113. Sunflower May 27, 2019
  114. dharmaraju BK September 3, 2019
  115. AungTunLinn January 13, 2020
  116. Lungisa May 10, 2020
  117. Jimit June 15, 2020
  118. mamta June 24, 2020
  119. durga prasad September 11, 2020
  120. Nathan October 11, 2020
  121. sh January 1, 2021

Leave a Reply