SQL Server Management, error 29506

Question

I tried to install this evening SQL Server Management Express on my Windows Vista 32 bit Home Premium Edition + Sql server 2005 express.

The problem is that at the end of the installation this error comes out:

"Si è verificato un errore imprevisto durante l'installazione di questo pacchetto. Probabile problema con questo pacchetto. Il codice errore è: 29506"

What could I do?

 

Thanks Luke

Answer 1

  OK, I solved the problem seeing another topic of this forum.

I've just entred in cmd.exe as Administrator, then I run from there the MSI package and everything now is fine.

Thanks anyway and sorry if I didn't read it before....

Luke

Answer 2

SOLVED

FINALLY

SOLVED

You need to do a little bit of every thing.

first, yes, download the ssmsee from microsoft, make sure of the size 39.418 mb, theres a version of 40 .146 mb .

second. go to the mssql file and reset the file permision and put mssql, mssqlx and data to full control on ALL users.

 

third; Do not run the installer from your own drive, if you run it (i dont know yet why) from your local drive it wont work, run the installer froma usb or cd.

 

finally it work, it run and you can work whith sql express or nor mal sql on a vista machine.

Answer 3

the data files already had the administrator group set to full access when I encountered the problem

running the installer from commandline as administrator solved the problem for me, thanks Luke, this was the only solution I found via live search

Answer 4

Thanks Luke, I got the same error with the x64 version and with your solution it installed without any problem!

 

Answer 5

 

I read the solution here but I don understan How tu run CMD.exe like adminsitrator and how to run installer from cmd shell.

 

So I put the SQLServer2005_SSMSEE.msi on C:\

 

so here his step by step instructions and works find for me:

 

1.-first find cmd shell icon on START>ALL PROGRAMS>ACCESORIES (Optional you can search CMD on your vista and you fin the icon)

 

2.- Right click on it and select RUN AS ADMINISTRATOR

 

3.-Go to C:\ (you can type cd \ (enter) your prompt look like this C:\>)

 

4.-type "SQLServer2005_SSMSEE.msi" (Enter) and the installer runs like if you have made doble click on it)

 

Thats all.

 

I try to install for a couple days and this is the only way I hope this could help some body.

 

(sorry for spell error Im from Mexico and I try my best)

 

REGARDS

[e-mail]

Answer 6

georgegar: Thanks! It works great! I was loking for any resolution for an hour.

Answer 7

i tried run command prompt as an administrator, and it worked perfectly.
thx for the tricks.

Regards,
Hafiz Arraja

Answer 8

 

Thanks,verygood!!!!

Answer 9

 

mines isn't woring

 

In the administrator command prompt, i get this message "is not recognized as an internal or external command, operable program or batch file" ?? help?

 

the command i typed in was

 

C:\>SQLServer2005_SSMSSE_x64.msi

Answer 10

Thank you - you helped me too

 

Answer 11

problem is not solved at my system, using vista 32 bit, home premium

kindly suggest

Rajesh

Answer 12

By the time I've found this, I hope you have solved your problem.

Anyway I think this can be usefull for future reference:

 

Your .msi must be on C: to run it that way, or you must provide the complete path to the .msi (something like C:\Users\yourUser\Downloads\SQLServer2005_SSMSSE_x64.msi).

 

 

 

Answer 13

Installing as admin from the command line worked for me too.

Answer 14

How extremely Bizzar! I allowed it to run as admin etc and didn't work, but does from command prompt lol, very weird.

Answer 15

Fresh Install of Windows Vista 64 I7, Priv Command Line solution worked.  Saved a lot of time here, thanks

Answer 16

It works perfect on Win7 Ultimate 64 bit as well.

Thanks

Answer 17

thx, this really helped me

Answer 18

YOU THE MAN!!!!!!!!!!!!!!!!!!!
I've been fighting with this thing for upwards of 2 hours. Reinstalling everything thinking that something went wrong.   

Something not mentioned is this.
If you saved the file to your desktop, when typing in the command line, make sure you type in the location of the saved file.  If it's on Desktop, then type that in (not "downloads").  I was an idiot the first 5 times.  :)

Also, anybody else wondering if 2005 SQL works on Windows 7.... I don't know yet,  But I DID just finish getting it installed.  Should be ok.

Answer 19

Thanks LukeDJ87 and georgegar...
you both ar right thats work perfect thanks
Regards
Mohandar

---

MLdodwani