Installing Microsoft SQL Server Management Studio Express in Windows Vista or Seven: Error 29506
This is a problem about privileges. Probably the installer performs the latests tasks without using elevation.
Solution is very simple: run the installer from an elevated command prompt.
- Click Start.
- Type
cmdend press CTRL+SHIFT+ENTER and accept the elevation. - Execute the installer from there (just type path and filename).
This works on Windows Vista and, of course, on Windows 7.
If using a 64 bit version, please note you will have to use the 64 bit version of cmd.exe, which is located in c:\Windows\SysWoW64 instead on c:\Windows\System32, so just write c:\Windows\SysWoW64\cmd instead of just cmd (thanks to Pierre Boucher for this)
working! Very good and thanks a lot for tooltip !
Working very vell! Thx.
I did this and it worked, thanks so much i just installed vista a few hours ago and you saved my life, i was about going back to xp, but could you tell me this doesnt cause any problem creating dbs and developing an aplication from visual studio and windows vista?
Yes, it does not create any problem creating dbs and developing applications.
The only thing that is different from Windows XP is that if you want to put the mdf file inside a user directory (i.e. c:\users\username\documents) you will need to manually set the ACLs.
Thanks for this tip. This was helpful
Thanks! I must add that if you have a 64bit Vista like mine, you need to use the 64bit version of the cmd program. To do that, just write the full path to the application (ex: c:\windows\syswow64\cmd). The rest of the procedure is the same.
Hi I had no problem installing the x64 SQL with elivated 32bit cmd.exe.
But I had no idea that both 32bit and 64bit existed. Thanx for that info Pierre.
Thanks!
This helped me out
isn’t the 64bit cmd.exe confusingly in system32? I remember reading that recently
yeaaaaaaaa, i worked good
thanxxxxxxxxxxxxxxxxxxx
I have same message when I was trying to install Microsoft SQL Server Management Studio Express: Error 29506,
I love guys for that tip, by using “cmd“ it’s working now great thanks
Great tip, thanks!
ok well done!
It works, thank you very much….
It worked!!!
SUPER!!! Trick.
One other problem, when i type cmd.exe in vista, it opens, then disappers. But I managed to open up another prompt anyway
Great tip. Was a little confused about the ctl+shift+enter, but the realised that you open the command prompt with that key combo once its highlited. thanks again.
@Ryan: Nope. CTRL+SHIFT+ENTER launches the executable / file you typed with elevation.
The command prompt opens because you typed “cmd” (that stands for command prompt).
Worked for me. This type of permission issue should have been addressed by MS.
sort and sweet, excellent!
Worked like a charm! Thanks!
Thank you! Same problem persists in windows 7, and this trick works perfectly
i cant used it i dont know why
i dont know what to do
how do i write de path or de filename
what do i have to write… help me
im a disaster
thanks man.. this work for me in case of window 7 64 bit
For Windows 7 you have to use the 64 CMD 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.
Hello Chris..
There are lot of solutions published on many sites but none explained in detail for Windows 7, (like mention specific to use 64bit of cmd.exe) I was using the normal cmd but was erroring out. This worked for me. Thanks a lot.
Thanks Chris M
Yes this works awsome on 7 64 bit
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
(
Interestingly, the solution on this page didn’t work for me verbatim. Instead I had to browse to the folder containing the 64 bit version of cmd and then right click the executable and select Run as administrator. I accepted the elevation and then ran the msi for SQL Server Management Studio – This did the trick.
Thanks to all for posting the solution!
Whoops – Just noticed that Chris M also posted a similar solution.
Very helpful. Thanks!
Thanx a lot.
This method is not working on my pc.
Thank you so much! It worked after hours of stress.
M$ is one piece of shit…
this really helped me….Chris, thnx a lot for the information…
Wow. What a dog. I download it 4 times, tried elevated privledges in many ways and still could not get it to work (grrr!) – then I saw vishal’s post and tried that and it worked!
So in Win7 64 bit you NEED to find the ” C:\Windows\SysWOW64\cmd.exe” file and right-click and run as admin and THEN it’ll work. Interestingly if you do that you get a CMD box set to c:\Windows\Sys32 where as running it directly it comes up with c:\SysWOW64. Thanks guys!
Thanks you for installing MSQL server quide.
thnk you….really worked!!!
Thanks for the tip!
Two nitpicks with everyone claiming that the SysWoW64 version is necessary: 1) SysWoW64 is the “Windows 32-bit on Windows 64-bit” subsystem and this location contains Windows 32-bit on 64-bit helpers (see the Wikipedia article for references). 2) There is no functional difference between the cmd.exe contained in System32 versus the one in syswow64. They are identical (md5sum from a Cygwin shell), and here’s proof:
bshelton@/cygdrive/c/windows/syswow64$ md5sum cmd.exe
ad7b9c14083b52bc532fba5948342b98 *cmd.exe
bshelton@/cygdrive/c/windows/syswow64$ md5sum ../system32/cmd.exe
ad7b9c14083b52bc532fba5948342b98 *../system32/cmd.exe
Furthermore, Cygwin reports cmd.exe as a 32-bit binary:
bshelton@/cygdrive/c/windows/system32$ file cmd.exe
cmd.exe: PE32 executable (console) Intel 80386, for MS Windows
Compared to others which appear to be 64-bit:
bshelton@/cygdrive/c/windows$ file write.exe
write.exe: PE32+ executable (GUI) x86-64, for MS Windows
So to put this to rest: Regardless of which cmd.exe you’re running, you are running identical files, both of which appear to be built for the x86 architecture. If you’re having difficulty with one, it’s exceedingly likely that you haven’t properly elevated the command prompt’s permissions and has nothing to do with the target arch (in fact it can’t!).
As an addendum to my previous post: I was wrong about the bit-ness. It appears that Cygwin does not, in fact, report the correct information. I had an inkling of an idea that I may have been wrong (I was) and copying both files over to my file server, then compared them:
[sagittarius:~]$ md5sum *cmd.exe
5746bd7e255dd6a8afa06f7c42c1ba41 system32-cmd.exe
ad7b9c14083b52bc532fba5948342b98 syswow64-cmd.exe
However, I was still right about one thing: If you examine the output of Windows’ task manager, cmd.exe from System32 appears as a native app; running cmd.exe from SysWoW64 will flag it with the “*32″ suffix indicating that it’s running under 32-bit emulation.
My conclusion is different: It is feasible (although Windows isn’t really my native OS) that the reason some people had success with the SysWoW64 version because of some weirdness in the emulation layer that running a 32-bit version of cmd.exe would fix.
Please disregard my previous post, at least partially. Cygwin clearly didn’t report the correct information to me, and I didn’t bother to double check it.
Either way, Sid’s original post was spot on. So bear in mind: If you’re running cmd.exe from SysWoW64, you are running the *32-bit* version, NOT 64-bit as some other posters have indicated. The MD5 sum of the 32-bit version should be ad7b9c14083b52bc532fba5948342b98, which you can verify yourself.
sorry but this is not work in my system ,,, so plz any one can help me
Yes. This worked really well! Thanks for the tip. Right-clicking on the cmd executable and selecting Run as Administrator also works.