none
Error installing SQL Server Management Studio Express on Windows Vista RC1

    Question

  • Hello NG,

    After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

    "Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

    Where can I find more infos about this error-code?

    Anybody knows this problem?

    Thank in advance for every help.

     

    Saturday, November 18, 2006 2:13 AM

Answers

  • Guys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

    For anyone else that needs it spelling out then this is exactly what to do...
    For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn't even know there was a separate version) and then run this as administrator. So I did the following…
    1. Right click on desktop and click NEW – SHORTCUT
    2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
    3. Right click on the new shortcut and Run AS ADMINISTRATOR
    4. Enter full path and file name:
    e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
    Where [YOUR NAME] is the windows user you are using.
    Sunday, December 13, 2009 12:32 AM
  •  

    You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

    Monday, November 20, 2006 3:29 AM

All replies

  •  

    You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

    Monday, November 20, 2006 3:29 AM
  • I´ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

    HTH
    Alexej Kucher



    • Proposed as answer by squebler Tuesday, August 25, 2009 6:05 AM
    Friday, December 08, 2006 9:47 AM
  • Hi...

     

    How can I start a cmd_shell as an Administrator.

     

    thanks

    Friday, July 13, 2007 2:02 AM
  • Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.
    Wednesday, July 25, 2007 10:17 AM
  •  

    hello!

     

    can you help me!

     am traing to install SQL server management but an error-code 29506 tells me that it cant install..

     

    i hope that you can help me!

     

    you seed that we can use an cmd-shell, if you can tell me how can i do that it while be very helpful.

     

     my e-mail is yeyo_all@hotmail.com

     

    sorry for my ingles i´m colombian.....

    Thursday, October 18, 2007 5:25 AM
  • Yes this does work - excuse me for being rude but this is a bug that should have been taken care of. I am logged in with a user that has admin rights... that should be enough. All other programs install fine. This needs to be fixed so you MS folks stop driving everyone crazy out here! Dennis from Camarillo CA

     

    Sunday, March 09, 2008 6:49 PM



  • Thank you for adequately describing my state of mind. I am going crazy. I'm in an endless loop of sql server express saying it won't work until the upgrade in done, so I do the 2 hour long frigging upgrade, then it says it can't install, so I reboot and it take forever aftert he bad install, and then it says I have an update again and won't let me use the sql server express as I have been using it.

    I have now missed my deadline today. I have spent the last 3 days fighting this frigging update. I've now tried twice to turn off updates. Thanks for ruining my weekend and my presentation Microsoft. I'm going crazy and I still in XP. It did this about a month ago as well. I'm getting really pissed off.
    Sunday, March 09, 2008 9:09 PM
  •  

    In plane English this means: in the startbar type cmd.exe.

    When you see it popping up in the list above, right-click it and click 'Run as Administrator'.

    Then type cd and the path of the folder where SQLServer2005_SSMSEE.msi is located.

    Then type SQLServer2005_SSMSEE.msi and press enter.

     

    Worked for me...

    • Proposed as answer by nilashis Saturday, March 28, 2009 12:03 AM
    Wednesday, October 08, 2008 2:41 PM
  • It does NOT install on x64 version of Vista, I've just found out.  The download page says that Vista isn't supported, btw.

     

    Tuesday, October 28, 2008 12:00 AM
  • But SP2 version runs!  x64 version is 48mb.  Downloading now.

     

    Tuesday, October 28, 2008 12:06 AM
  •  

    downloaded this SQLServer2005_SSMSEE_x64.msi  ran from the command line with admin privs and it worked for me too.  thanks!
    Tuesday, October 28, 2008 9:39 PM
  • running from commandline as administrator worked for me too..

    thanks...
    Sunday, April 12, 2009 7:47 PM
  • I got the same error when trying to install it on Windows 7 RC1.

    Starting a console as administrator and starting the installation from there worked fine.
    Tuesday, June 23, 2009 4:27 PM
  • I was trying to install management studio but kept getting the error code of 29506. This happened just before it finished installing.

    I just went back to microsoft and intalled sql server management studio "service pack 2" and it worked no problem.

    Hope this helps.
    Wednesday, June 24, 2009 4:43 PM
  • it works if installing sp2 version. thanks!!!
    Monday, July 20, 2009 4:50 AM
  • Was having the same issue with Windows 7 Ultimate Beta and this worked for installing SQLSERVER2005_SSMSEE_x64.msi.

    Thanks!

    Friday, July 31, 2009 4:40 AM
  • Works for me! Great! 
    Sunday, August 02, 2009 6:14 AM
  • Same error with Windows 7 -  

    Did the cmd as administrator and it worked as well.

    Quite frustrating considering that I'm already logged as the administrator on my machine.  Ridiculous.
    Wednesday, August 05, 2009 4:31 AM
  • alexejk, you're such a life saver!
    Tuesday, August 25, 2009 6:06 AM
  • Brilliant, just saved me lots of frustration.  It works perfectly on Win7. 

    As a side note: I found a quicker way than using right click and Run As... is to press Ctrl + Shift + Return when you have entered cmd in the startbar.  This will run the prompt with Admin rights.
    Wednesday, August 26, 2009 6:52 AM
  • thx The G Z !
    Friday, September 04, 2009 11:26 PM
  • I´ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

    HTH
    Alexej Kucher




    u made my day!!!
    Sunday, December 06, 2009 10:03 PM
  • Guys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

    For anyone else that needs it spelling out then this is exactly what to do...
    For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn't even know there was a separate version) and then run this as administrator. So I did the following…
    1. Right click on desktop and click NEW – SHORTCUT
    2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
    3. Right click on the new shortcut and Run AS ADMINISTRATOR
    4. Enter full path and file name:
    e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
    Where [YOUR NAME] is the windows user you are using.
    Sunday, December 13, 2009 12:32 AM
  • Thanks for answer, this is working!
    Sunday, December 20, 2009 11:21 AM
  • Guys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

    For anyone else that needs it spelling out then this is exactly what to do...
    For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn't even know there was a separate version) and then run this as administrator. So I did the following…
    1. Right click on desktop and click NEW – SHORTCUT
    2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
    3. Right click on the new shortcut and Run AS ADMINISTRATOR
    4. Enter full path and file name:
    e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
    Where [YOUR NAME] is the windows user you are using.

    Yes this is works, thanks...
    Sunday, January 10, 2010 6:35 AM
  • Hi Chris:

    This seemed to have worked (after hours that ran into days of trying to resolve the problem).
    However, after creating the cmd shortcut, here is what occured under two seperate scenarios:
    1: If I simply clicked on the shortcut, the following command line appears:  C:\Windows\SysWOW64>

    2: If I right clicked on it and "Ran As Administrator", the following command line appears: C:\Windows\system32>

    I ran the program as the administrator from the system32 line and it seemed to have loaded correctly.

    I'm just curious about how you and others view this somewhat confusing situation and whether or not I need to
    somehow load from the "WOW64" prompt line.

    My Operating System is Windows 7 Home Premium 64 bit

    Thank you.
    Joel
    Sunday, January 17, 2010 11:11 AM
  • Well, trying to install SQLServer2005_SSMSEE_x64.msi.
    O/S: WIN7 Pro 64 (fully updated to Jan 24th, 2009)

    Created shortcut to cmd64, ran as Administrator.
    browsed to SQLServer2005_SSMSEE_x64.msi

    Still get error 29506.

    I don't even really need this thing, I'm running down a rathole trying to move a db from C: to D:
    I keep getting:
    Unable to open the physical file "D:\Data\Databases\Blahblah\Blahblah.mdf". Operating system error 5: "5(error not found)".
    which is some kind of security permissions issue, but I granted the whole drive to everyone, all users just for fun and still no dice.
    You'd think that after so many windows versions, the error message might actually tell you something, rather than having to figure out what  Operating system error 5: "5(error not found)" really means. I need to build a database just to store error messages now...

    Wasn't Win7 supposed to be "easy and smart"?

    Next I'll be looking for my old version of DOS3.3, those were the days...

    Monday, January 25, 2010 4:31 AM
  • Worked for me as well. Thanks Chris
    Monday, February 15, 2010 9:57 PM
  • Guys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

    For anyone else that needs it spelling out then this is exactly what to do...
    For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn't even know there was a separate version) and then run this as administrator. So I did the following…
    1. Right click on desktop and click NEW – SHORTCUT
    2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
    3. Right click on the new shortcut and Run AS ADMINISTRATOR
    4. Enter full path and file name:
    e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
    Where [YOUR NAME] is the windows user you are using.
    Thanks for your solution. It works perfectly
    We can win the race
    • Proposed as answer by aadamich Saturday, February 20, 2010 8:39 AM
    Saturday, February 20, 2010 8:39 AM
  • THANKS

    Thanks for that, I now have the 64 bit msi installed on Windows 7 professional 64 bit
    Thursday, March 04, 2010 9:58 PM
  • I thought I tried everything, except that I'm on Hyper-V/Windows 7 x64/VS2010.

     

    I tried 4 different install/un-install sequences, before searching.  It works!

    Sunday, March 21, 2010 4:36 AM
  • Thanks, again.

     

    It worked for me too......  :)

    Wednesday, March 31, 2010 5:42 AM
  • Thanks so much Chris Mck!!

    Been trying to figure this out for a few months.  tried everything, but couldn't get it to work.  followed your steps and it finally works!  Only three weeks left in this class but it feels good just to get that monkey off my back and not have to work on my laptop anymore.

    Saturday, April 03, 2010 7:29 PM
  • I´ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

    HTH
    Alexej Kucher



    This worked for me on a 64bit Vista Home Premium so thanks a lot!
    Sunday, April 11, 2010 1:50 AM
  • I´ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

    HTH
    Alexej Kucher



    This worked for me on a 64bit Vista Home Premium so thanks a lot!
    Sunday, April 11, 2010 1:50 AM
  • Chris,

    Thanks for the simple detailed answer. Fixed a problem I have been working on for several hours. I wish you much happiness and prosperity.

    Thursday, April 15, 2010 4:44 AM
  • Chris,

    Thank you for your post about using the command prompt. It worked like a charm.

    - Vinh

     

    Tuesday, May 04, 2010 5:22 PM
  • Chris (and others who helped)

    You are such a lifesaver!!!  This might have taken me days to figure out, but your instructions were clear and well explained.  Wonderful!  Keep up the great work.

    With much appreciation for a job well-done

    CJ Rhoads

    Wednesday, June 09, 2010 11:57 PM
  • i squandered about the whole PM trying to install sql server. Microsoft product sometime just AMAZING.... He he.  
    Sunday, June 13, 2010 7:58 PM
  • Chris,

     

    Many thanks for putting this on the forum.   When I failed, I searched for the error and came straight to this page and your detailed instructions.

     

    Thanks

    clare

    Tuesday, July 20, 2010 4:19 AM
  • Guys I had a real hard time getting this to work as a newbie with 64 bit computing
    For Windows 7 64 bit you have to use the 64 bit CMD prompt
    2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
    This NOT a 64 Bit CMD in this directory.

    http://en.wikipedia.org/wiki/WoW64

    Wednesday, September 15, 2010 1:22 PM
  • I have struggeled for some hours now and tried a bunch of tips - this really made it. THANKS!!!!!!!!!!!!
    Thursday, September 23, 2010 5:35 PM
  • Thanks a lot mate, it helped me great. I will remember this method as a Win7 64 bit user, whenever things goes wrong.
    Wednesday, October 06, 2010 8:59 AM
  • thank you SO much! i searched so many answers and yours was so simple! and even better it WORKED!!!! THANK YOU!!!!!
    Sunday, October 10, 2010 9:10 AM
  • this worked for me also, thank you


    Austin
    Monday, October 11, 2010 11:32 AM
  • Thanks, this worked for me, except tor the right clicking on the desktop.  I had to go to the address and create a shortcut from there.  I have had other installs that failed because it said I didn't have administrato privilages (which I do), and this should eliminate those in the future.  Thanks again.
    Wednesday, October 13, 2010 3:06 PM
  • Thank you ..............

     

    I can able to instal it on my computer, as directed by you

     

    Thank you again

    Wednesday, November 10, 2010 9:27 AM
  • Thank you very much! This works great!
    Thursday, January 13, 2011 5:10 PM
  • Or install it as the local administrator.  Worked for me
    Monday, January 24, 2011 7:05 PM
  • Thank you very much
    Friday, January 28, 2011 3:41 PM
  • Thank you very much for the work around . Starting CMD shell  as administrator has worked. 
    Monday, February 28, 2011 3:14 PM
  • Thanks, it worked for me on Windows 7 (64 bit)
    Wednesday, March 09, 2011 6:57 AM
  • Thanks a lot. It works for me!
    Wednesday, March 09, 2011 1:48 PM
  • thanks for the workaround - it saved my client's "life".  Too bad Microsoft doesn't know or care - this cost me 3 hours!
    Tuesday, April 05, 2011 9:19 PM
  • thank you so much, It works for me

    your Information was really helpfull

     

    Sunday, April 24, 2011 1:32 AM
  • Thanks a lot! It works !!

    It can a little bit easier; open a command prompt as administrator and open the downloaded file in this dos window.

    - Window button

    - cmd

    - right click : "run as administrator"

    - go to the location of your file

    - enter the full file name and press enter

    - setup works perfect !

     

    again thanks a lot for the tip

     

    Tuesday, June 14, 2011 1:41 PM
  • Microsoft is a joke.
    Saturday, June 25, 2011 9:44 PM
  • Thank you so much. This works like a charm
    Friday, July 01, 2011 10:18 PM
  • Guys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

    For anyone else that needs it spelling out then this is exactly what to do...
    For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn't even know there was a separate version) and then run this as administrator. So I did the following…
    1. Right click on desktop and click NEW – SHORTCUT
    2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
    3. Right click on the new shortcut and Run AS ADMINISTRATOR
    4. Enter full path and file name:
    e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
    Where [YOUR NAME] is the windows user you are using.

    great it function very well. Tanks....
    Saturday, July 02, 2011 1:20 PM
  • It work for me on WIndows 2008 R2.

    Thanks in advance!


    MCP Windows XP / MCP ISA 2004 - Não esqueca de avaliar a resposta!
    Wednesday, July 13, 2011 5:56 PM
  • Guys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

    For anyone else that needs it spelling out then this is exactly what to do...
    For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn't even know there was a separate version) and then run this as administrator. So I did the following…
    1. Right click on desktop and click NEW – SHORTCUT
    2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
    3. Right click on the new shortcut and Run AS ADMINISTRATOR
    4. Enter full path and file name:
    e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
    Where [YOUR NAME] is the windows user you are using.
    Thanks a lot dude, I was struggling with installing all possible versions of Studio, SQL server just to be able to run SQL management studio and got the same error above. Thanks again for your solution
    Friday, January 20, 2012 11:36 PM
  • This is how it worked for me

    Had to move the file in drive C, after running cmd (command prompt) As Admin, I entered this text:

    msiexec.exe -i C:\the file name

    pressed enter.

    Hope it helped.
    • Proposed as answer by Tina86 Sunday, April 15, 2012 1:33 AM
    Sunday, April 15, 2012 1:32 AM
  • AFTER ENTERING FULL PATH ..WHAT WE HAVE TO DO?
    Wednesday, May 09, 2012 6:05 PM
  • Microsoft Windows [Version 6.1.7600]
    Copyright (c) 2009 Microsoft Corporation.  All rights reserved.


    C:\Windows\system32>C:\Users\Kamal\Downloads\SQLServer2005_SSMSEEmsi
    'C:\Users\Kamal\Downloads\SQLServer2005_SSMSEEmsi' is not recognized as an inter
    nal or external command,
    operable program or batch file.

    C:\Windows\system32>C:\Users\Kamal\Downloads\SQLServer2005_SSMSEEmsi

    got an error

    Wednesday, May 09, 2012 6:11 PM
  • Chris - thanx alot man, ur a lifesaver!!!!

    Thursday, May 17, 2012 5:50 PM
  • Thank you, this works and really saved me some time!
    Thursday, May 31, 2012 6:36 PM
  • Thanks Chris, it worked...
    Wednesday, August 22, 2012 2:51 AM
  • Excellent, it works for me, thank you
    Saturday, September 22, 2012 4:19 PM
  • Thanks man. Good job. It helped me
    Wednesday, November 07, 2012 2:36 PM
  • I agree this is a bug.  (NO! A feature!)  Typical MS horse dung.  The problem with Microslop is that it grew too fast.  It tried to the end all and be all in the microcomputing game.  I have been in this industry for over twenty seven years.  I actually wrote my first software on a Commodore vic20. Egads!
    Friday, November 09, 2012 4:54 AM
  • Thank you Chris! 3 years later....still works like a charm on Windows 8 64-bit!!!
    Friday, January 04, 2013 6:18 AM
  • worked for me as well! thanks guys!
    Wednesday, August 14, 2013 7:40 PM
  • Thanks Nilashis.... It worked for me as well...cheers............ :)

    -Lalith

    Sunday, October 06, 2013 11:19 AM
  • Working. thank you 
    Tuesday, December 16, 2014 6:24 PM