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.

 

Answer 1

 

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....

Answer 2

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

Answer 3

Hi...

 

How can I start a cmd_shell as an Administrator.

 

thanks

Answer 4

Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Answer 5

 

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 [e-mail]

 

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

Answer 6

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

 

Answer 7

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.

Answer 8

 

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...

Answer 9

It does NOT install on x64 version of Vista, I've just found out.  The download page says that Vista isn't supported, btw.

 

Answer 10

But SP2 version runs!  x64 version is 48mb.  Downloading now.

 

Answer 11

 

downloaded this SQLServer2005_SSMSEE_x64.msi  ran from the command line with admin privs and it worked for me too.  thanks!

Answer 12

running from commandline as administrator worked for me too..

thanks...

Answer 13

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.

Answer 14

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.

Answer 15

it works if installing sp2 version. thanks!!!

Answer 16

Was having the same issue with Windows 7 Ultimate Beta and this worked for installing SQLSERVER2005_SSMSEE_x64.msi.

Thanks!

Answer 17

Works for me! Great! 

Answer 18

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.

Answer 19

alexejk, you're such a life saver!

Answer 20

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.

Answer 21

thx The G Z !

Answer 22

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!!!

Answer 23

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.

Answer 24

Thanks for answer, this is working!

Answer 25

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...

Answer 26

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

Answer 27

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...

Answer 28

Worked for me as well. Thanks Chris

Answer 29

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

Answer 30

THANKS

Thanks for that, I now have the 64 bit msi installed on Windows 7 professional 64 bit

Answer 31

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!

Answer 32

Thanks, again.

 

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

Answer 33

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.

Answer 34

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!

Answer 35

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!

Answer 36

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.

Answer 37

Chris,

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

- Vinh

 

Answer 38

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

Answer 39

i squandered about the whole PM trying to install sql server. Microsoft product sometime just AMAZING.... He he.  

Answer 40

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

Answer 41

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

Answer 42

I have struggeled for some hours now and tried a bunch of tips - this really made it. THANKS!!!!!!!!!!!!

Answer 43

Thanks a lot mate, it helped me great. I will remember this method as a Win7 64 bit user, whenever things goes wrong.

Answer 44

thank you SO much! i searched so many answers and yours was so simple! and even better it WORKED!!!! THANK YOU!!!!!

Answer 45

this worked for me also, thank you

---

Austin

Answer 46

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.

Answer 47

Thank you ..............

 

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

 

Thank you again

Answer 48

Thank you very much! This works great!

Answer 49

Or install it as the local administrator.  Worked for me

Answer 50

Thank you very much

Answer 51

Thank you very much for the work around . Starting CMD shell  as administrator has worked. 

Answer 52

Thanks, it worked for me on Windows 7 (64 bit)

Answer 53

Thanks a lot. It works for me!

Answer 54

thanks for the workaround - it saved my client's "life".  Too bad Microsoft doesn't know or care - this cost me 3 hours!

Answer 55

thank you so much, It works for me

your Information was really helpfull

 

Answer 56

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

 

Answer 57

Microsoft is a joke.

Answer 58

Thank you so much. This works like a charm

Answer 59

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....

Answer 60

It work for me on WIndows 2008 R2.

Thanks in advance!

---

MCP Windows XP / MCP ISA 2004 - Não esqueca de avaliar a resposta!

Answer 61

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

Answer 62

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.

Answer 63

AFTER ENTERING FULL PATH ..WHAT WE HAVE TO DO?

Answer 64

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

Answer 65

Chris - thanx alot man, ur a lifesaver!!!!