Chris Rasmussen · Photographer · Infrastructure Guy · Code Dabbler · Traveller
Home » Databases » Error 29506 when installing SQL Server 2005 Management Studio Express on Vista

Error 29506 when installing SQL Server 2005 Management Studio Express on Vista

Posted by Chris on Jun 25th, 2008 in Databases, Software | 44 comments

If you need to install SQL Server 2005 Management Studio Express on Windows Vista you might receive an error like the screenshot below.

SSMSE installation error on Windows Vista

This is due to the new Vista feature called User Account Control or UAC. The fix is pretty simple and there are 2 different ways of implementing it.

1. Under ‘Accessories’ from ‘All Programs’, right-click the Command Prompt shortcut and select ‘Run as Administrator’. Accept the UAC warning when prompted.
2. From the command prompt change to the directory that holds the SSMSEE installation .MSI file.
3. Enter the command .\SQLServer2005_SSMSEE_x64.msi if you’re running Vista x64 (64-bit) or .\SQLServer2005_SSMSEE.msi if you’re running Vista x86 (32-bit)
4. Press enter and complete the installation as normal.

The second method is to disable UAC completely but I wouldn’t recommend it.

banner ad

44 Responses to “Error 29506 when installing SQL Server 2005 Management Studio Express on Vista”

  1. kevin says:
    July 7, 2008 at 03:30

    very good! it really help me .Thanks

    Reply
  2. Matt says:
    September 29, 2008 at 23:27

    Thanks for the tip, this works.

    Reply
  3. Lafitte says:
    October 27, 2008 at 11:06

    Tried it but it didn’t work, any other suggestions

    Reply
  4. Chris says:
    October 27, 2008 at 13:13

    Hi Lafitte,

    What problem are you experiencing when you try the steps above? If you give more detail I might be able to help …

    Thanks

    Reply
    • jonathan says:
      February 16, 2010 at 09:34

      i tried to install and i used both methods above but still nothing :/

      disabled UAC and still got the same error message :/

      im confused and i need SQL for a software project :/

      Reply
      • Chris says:
        February 16, 2010 at 09:43

        jonathan: You disabled UAC and got the same error? This is the only fix for this error that I’m aware of and it’s worked in 100% of cases for me. Is your system enforcing UAC via group policy perhaps?

        Reply
  5. Karthik says:
    October 28, 2008 at 12:20

    excellent tip. worked perfect. Thanks

    Reply
  6. Kevin says:
    November 2, 2008 at 08:16

    Thanks for the tip. Worked perfectly.

    Reply
  7. GioveFi says:
    November 8, 2008 at 01:26

    Very usefull,
    UAC is acronymous for “Use Another Computer” :-) )

    Reply
  8. mehmet says:
    November 20, 2008 at 01:19

    thanks a lot bro, it really works.

    Reply
  9. Happy Man says:
    February 16, 2009 at 01:40

    Thanks for this help, it’ s very usefull.

    Reply
  10. Prithviraj says:
    March 1, 2009 at 15:45

    Thanks buddy, it worked perfectly

    Reply
  11. Yann says:
    March 11, 2009 at 14:20

    Thank you very much.

    Reply
  12. Rob Teegarden says:
    April 7, 2009 at 09:27

    Great. Worked like a champ!

    Reply
  13. Rami Ash says:
    May 21, 2009 at 12:18

    Man,

    This is the best explain I have ever read, clean, clear and to the point.

    Thanx a lot!!

    Reply
  14. Victor says:
    June 6, 2009 at 00:55

    how do you change the directory in command prompt?

    Reply
  15. Chris says:
    June 6, 2009 at 09:39

    @Victor: I assume you’re not familiar with DOS commands? The one you need is “cd”. If the installer is in C:\Install you need to enter “c:”, press enter, then enter “cd \Install” and press enter – all commands should be entered without the quotes. I hope that’s what you mean?

    Reply
  16. Kicasd says:
    June 11, 2009 at 16:44

    thx man, this realy works.

    Reply
  17. oded magid says:
    July 17, 2009 at 05:39

    very nice! thank you :)

    Reply
  18. Ru63n says:
    July 20, 2009 at 07:13

    Excellent!

    Reply
  19. Ankur says:
    July 23, 2009 at 07:47

    Thanks a ton!! It worked…

    Reply
  20. Jan says:
    July 24, 2009 at 19:08

    Works like a charm with Windows 7 RC. Thank you!

    Reply
  21. Ejaz says:
    August 8, 2009 at 11:57

    After spending 2 days and dozens of alternatives this is the only one worked for me.

    Thank you very much.

    Reply
  22. DevNetFx says:
    August 17, 2009 at 21:51

    Thanks Guys. Wonder why can’t microsoft list these reasons. They are going from dumb to dumber.

    Reply
  23. AAjus says:
    September 16, 2009 at 00:12

    This solved my problem. Thanks

    Reply
  24. buunyamin says:
    October 14, 2009 at 00:02

    tesekurler kardes (thank you my friend)

    Reply
  25. VanHao_VietNam says:
    November 13, 2009 at 00:11

    Thank you verry much! I love you :D

    Reply
  26. Derek says:
    November 13, 2009 at 10:22

    Thank you very much!!

    Reply
  27. jyo says:
    November 16, 2009 at 15:01

    I Love you man.. it worked

    Reply
  28. javier says:
    December 14, 2009 at 13:46

    Excellent!!, thank you for resolve this issue

    Reply
  29. tentenct says:
    January 8, 2010 at 03:45

    good job thank you very much ^^

    Reply
  30. Adrian says:
    January 12, 2010 at 08:20

    Only way to fix error 29506 on Windows 7 that I have tried. Great post and thanks!!!

    Reply
    • Chris says:
      January 12, 2010 at 09:30

      Adrian: Thanks for the comment. You’re right too – this should also work on Windows 7 although I haven’t tried it myself. :)

      Reply
    • Magdalena says:
      January 25, 2010 at 10:01

      I have the same problem on win 7. Can anyone help me? I did not manage to solve this problem bye my self.

      My mail is megy1985@hotmail.com and hope that someone will read this and try with TeamViewer get in my computer and fix it. I am hopeless :o (

      Reply
      • Chris says:
        January 28, 2010 at 19:29

        Magdalena: There is a registry key for it that needs to be set to 2, from memory. I can’t remember the exact details but if you search for SQL Server integrated authentication on Google you’ll find it (the setting is the same for SQL Server Express and the full version of SQL Server).

        Reply
  31. Magdalena says:
    January 25, 2010 at 06:51

    I have the same problem on win 7. Can anyone help me? I did not manage to solve this problem bye my self.

    My mail is megy1985@hotmail.com and hope that someone will read this and try with TeamViewer get in my computer and fix it. I am hopeless :o (

    Reply
  32. Ash says:
    January 28, 2010 at 16:22

    Hi, I have windows 7 on my lptp and I was getting the same error 29506.
    I tried the way as mentioned and it works absolutely fine. Thankyou.

    But I have anathor problem now. I have installed SQL server 2008 and also the management studio for it. My problem is I cannot reconfigure the authentication for SQL Server 2008. I want to change it from default NT authenticatio to mixed mode so that I can login thru SQL user.

    I couldn’t find it on web. Can anyone please help me with it.

    thx

    Reply
  33. Zubair Masoodi says:
    February 1, 2010 at 02:57

    Excellent job, well done :-)

    Reply
  34. spugna says:
    February 6, 2010 at 12:02

    good fix. worked like a charm.

    Reply
  35. maddy says:
    February 17, 2010 at 02:34

    Thanks! worked for me too!

    Reply
  36. Will Marcouiller says:
    February 18, 2010 at 06:56

    Worked perfect under Windows 7!

    Reply
  37. Nguyen Nghiem says:
    February 27, 2010 at 14:09

    Thank you for your solution and guide. It’s really cool :)

    Reply
  38. Preetam Sahu says:
    March 8, 2010 at 20:23

    Yes This worked for me. Thanks a lot…

    Reply

Leave a Reply

Powered by Wordpress | Designed by Elegant Themes