I was trying to get SQL Server Management Studio installed when I encountered the error 29506. Looking up on the internet revealed that it’s related to admin privilege. When I view the properties of the installer, under the compatibility tab, “Run as administrator” option is disabled.
So instead, from start menu, I ran command prompt in administrator mode. Changed directory to the folder where the installer was. Ran the installer from command line and it all worked 🙂
23 replies on “Fixing Error 29506 while Installing SQL Server Management Studio”
GREAT HELP !!!
BS the self installing extractor won’t run from a “Command Prompt”. If you download the file from MS web site it is a self extracting and installing file.
Ran the msi from a command promt as administrator – It worked! thanks a million 🙂
PERFECT !!!!!!
Thanks Man,
it really helped me,
but why i can run the installer using run as administrator? any one know?
Right click and select Run as
I am trying to run MSSQL server management studio 2005 express file as suggested above, but noyhing happening. tried to run the file in command prompt with administrator access, but no help. please help.
Gaurav
allright here is the answer
Burn the  program on CD.
Now lauch  Command prompt as Administrator.   ( Right click on command prompt to Run as Admin )
Then  in black screen ( for those computer challanged lol )   ,  Change directory  to Your  CD   drive  ( mine is  D: )   .     I am old school and know some Dos commands.   Yeah i am old  .
Now  from  D:  in command prompt in that black screen  type the name of file  with extension
SQL blah blah. Â MSI
This will lauch installer.
WORKS Â Â !!
(  you are welcome  )
It worked
after running the SQLServer2005_SSMSEE_x64 from the command prompt
what a KT to dumb s like me
thnks
how can i run it from CMD ?
[…] Fixing Error 29506 while Installing SQL Server Management … – Gaurav Sotani 12 January, 2014 at 1:22 PM. I am trying to run MSSQL server management studio 2005 express file as suggested above, but noyhing happening. …… […]
[…] Fixing Error 29506 while Installing SQL Server Management … – Mearl 19 June, 2012 at 2:18 AM. BS the self installing extractor won’t run from a “Command Prompt”. If you download the file from MS web site it is a self …… […]
[…] Fixing Error 29506 while Installing SQL Server Management … – Gaurav Sotani 12 January, 2014 at 1:22 PM. I am trying to run MSSQL server management studio 2005 express file as suggested above, but noyhing happening. …… […]
[…] Fixing Error 29506 while Installing SQL Server Management … – Gaurav Sotani 12 January, 2014 at 1:22 PM. I am trying to run MSSQL server management studio 2005 express file as suggested above, but noyhing happening. …… […]
[…] Fixing Error 29506 while Installing SQL Server Management … – Gaurav Sotani 12 January, 2014 at 1:22 PM. I am trying to run MSSQL server management studio 2005 express file as suggested above, but noyhing happening. …… […]
Thanks, worked great for me
Thanx a stack -worked great
it works! thanks!
Thank You…
Thanks
Thanks, Running as Administrator solve such a long time problem…
keep up the good work
Thanks Alot 🙂 It worked