[Solved] Error 29506 when installing Microsoft SQL Server Manament Studio Express on Windows Vista or Windows 7
[Solved] Error 29506 when installing Microsoft SQL Server Manament Studio Express on Windows Vista or Windows 7
December 3, 2011
Administration
Note: This article is applied on installing Microsoft SQL Server Management Studio Express which is used for manage Microsoft SQL Server 2005 Express only.
When you are installing Microsoft SQL Server Management Studio Express on Windows Vista or Windows 7, you may receive this error message:
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 29506.
This error message relates with permission issue (UAC) on Windows Vista and Windows 7. To solve this problem, you have to re-run the installer again using elevated command prompt by run the command prompt as administrator and execute the installer in there. If you are using 64-bit Windows, you should use the command prompt at C:\Windows\SysWOW64\cmd.exe instead. Otherwise, you can use the command prompt at C:\Windows\System32\cmd.exe. You will see the step-by-step guide to use elevated command prompt to execute the installer file on the section below.
The other solution, you can disable UAC on Windows but I don’t recommend it since it will lower your security system.
Step-by-step to fix error 29506
- Run elevated command prompt by right-click on Command Prompt in Start -> All Programs -> Accessories -> Command Prompt and select Run as administrator.
Note: This step is for 32-bit Windows. If you are using 64-bit Windows, see the next step.
- If you are using 64-bit Windows, you have to run the command prompt in C:\Windows\SysWOW64. Right-click on cmd.exe and select Run as administrator.
- On User Account Control, click Yes.
- On Command Prompt (both 32-bit and 64-bit Windows), change path to directory where the installer file is and execute the file. By default, the file name for 32-bit version is SQLServer2005_SSMSEE.msi and 64-bit version is SQLServer2005_SSMSEE_x64.msi.
- On Setup Wizard, follow the instruction as usual. There won’t be the error message this time.
- Remove From My Forums
-
Question
-
hai……
I’ve several ways in tried to install SQL management studio including running of cmd prompt as admin.But the installer shows that «the installer has encountered an unexpected error installing this package.This may indicate a problem with this package.The
error code is 29506» ………..Please help me…..
Answers
-
Hi Adsamarnalkar,
This error message relates with permission issue (UAC) on Windows Vista and Windows 7. To solve this problem, you have to re-run the installer again using elevated command prompt by run the command prompt as administrator and execute the installer in there.
The other solution, you could change the UAC settings to be minimal (search for UAC in the start bar and select Control Panel –> Change User Account Control Settings) and set to minimal settings. Or you can disable UAC to solve the issue. Then you
could install SQL Server Management Studio.For more information, you could refer to
http://www.linglom.com/2011/12/03/solved-error-29506-when-installing-microsoft-sql-server-manament-studio-express-on-windows-vista-or-windows-seven/.Thanks,
Maggie
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
-
Proposed as answer by
Tuesday, December 20, 2011 1:11 AM
-
Marked as answer by
Maggie Luo
Tuesday, December 20, 2011 9:02 AM
-
Proposed as answer by
- Remove From My Forums
-
Question
-
hai……
I’ve several ways in tried to install SQL management studio including running of cmd prompt as admin.But the installer shows that «the installer has encountered an unexpected error installing this package.This may indicate a problem with this package.The
error code is 29506» ………..Please help me…..
Answers
-
Hi Adsamarnalkar,
This error message relates with permission issue (UAC) on Windows Vista and Windows 7. To solve this problem, you have to re-run the installer again using elevated command prompt by run the command prompt as administrator and execute the installer in there.
The other solution, you could change the UAC settings to be minimal (search for UAC in the start bar and select Control Panel –> Change User Account Control Settings) and set to minimal settings. Or you can disable UAC to solve the issue. Then you
could install SQL Server Management Studio.For more information, you could refer to
http://www.linglom.com/2011/12/03/solved-error-29506-when-installing-microsoft-sql-server-manament-studio-express-on-windows-vista-or-windows-seven/.Thanks,
Maggie
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
-
Proposed as answer by
Tuesday, December 20, 2011 1:11 AM
-
Marked as answer by
Maggie Luo
Tuesday, December 20, 2011 9:02 AM
-
Proposed as answer by
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
Перейти к контенту
[Solved] Error 29506 when installing Microsoft SQL Server Manament Studio Express on Windows Vista or Windows 7
[Solved] Error 29506 when installing Microsoft SQL Server Manament Studio Express on Windows Vista or Windows 7
December 3, 2011
Administration
Note: This article is applied on installing Microsoft SQL Server Management Studio Express which is used for manage Microsoft SQL Server 2005 Express only.
When you are installing Microsoft SQL Server Management Studio Express on Windows Vista or Windows 7, you may receive this error message:
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 29506.
This error message relates with permission issue (UAC) on Windows Vista and Windows 7. To solve this problem, you have to re-run the installer again using elevated command prompt by run the command prompt as administrator and execute the installer in there. If you are using 64-bit Windows, you should use the command prompt at C:WindowsSysWOW64cmd.exe instead. Otherwise, you can use the command prompt at C:WindowsSystem32cmd.exe. You will see the step-by-step guide to use elevated command prompt to execute the installer file on the section below.
The other solution, you can disable UAC on Windows but I don’t recommend it since it will lower your security system.
Step-by-step to fix error 29506
- Run elevated command prompt by right-click on Command Prompt in Start -> All Programs -> Accessories -> Command Prompt and select Run as administrator.
Note: This step is for 32-bit Windows. If you are using 64-bit Windows, see the next step.
- If you are using 64-bit Windows, you have to run the command prompt in C:WindowsSysWOW64. Right-click on cmd.exe and select Run as administrator.
- On User Account Control, click Yes.
- On Command Prompt (both 32-bit and 64-bit Windows), change path to directory where the installer file is and execute the file. By default, the file name for 32-bit version is SQLServer2005_SSMSEE.msi and 64-bit version is SQLServer2005_SSMSEE_x64.msi.
- On Setup Wizard, follow the instruction as usual. There won’t be the error message this time.
- Remove From My Forums
-
Question
-
hai……
I’ve several ways in tried to install SQL management studio including running of cmd prompt as admin.But the installer shows that «the installer has encountered an unexpected error installing this package.This may indicate a problem with this package.The
error code is 29506» ………..Please help me…..
Answers
-
Hi Adsamarnalkar,
This error message relates with permission issue (UAC) on Windows Vista and Windows 7. To solve this problem, you have to re-run the installer again using elevated command prompt by run the command prompt as administrator and execute the installer in there.
The other solution, you could change the UAC settings to be minimal (search for UAC in the start bar and select Control Panel –> Change User Account Control Settings) and set to minimal settings. Or you can disable UAC to solve the issue. Then you
could install SQL Server Management Studio.For more information, you could refer to
http://www.linglom.com/2011/12/03/solved-error-29506-when-installing-microsoft-sql-server-manament-studio-express-on-windows-vista-or-windows-seven/.Thanks,
Maggie
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
-
Proposed as answer by
Tuesday, December 20, 2011 1:11 AM
-
Marked as answer by
Maggie Luo
Tuesday, December 20, 2011 9:02 AM
-
Proposed as answer by
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
- Remove From My Forums
-
Question
-
hai……
I’ve several ways in tried to install SQL management studio including running of cmd prompt as admin.But the installer shows that «the installer has encountered an unexpected error installing this package.This may indicate a problem with this package.The
error code is 29506» ………..Please help me…..
Answers
-
Hi Adsamarnalkar,
This error message relates with permission issue (UAC) on Windows Vista and Windows 7. To solve this problem, you have to re-run the installer again using elevated command prompt by run the command prompt as administrator and execute the installer in there.
The other solution, you could change the UAC settings to be minimal (search for UAC in the start bar and select Control Panel –> Change User Account Control Settings) and set to minimal settings. Or you can disable UAC to solve the issue. Then you
could install SQL Server Management Studio.For more information, you could refer to
http://www.linglom.com/2011/12/03/solved-error-29506-when-installing-microsoft-sql-server-manament-studio-express-on-windows-vista-or-windows-seven/.Thanks,
Maggie
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
-
Proposed as answer by
Tuesday, December 20, 2011 1:11 AM
-
Marked as answer by
Maggie Luo
Tuesday, December 20, 2011 9:02 AM
-
Proposed as answer by
Error 29506 while installing SQL Server Management Studio Express
I’m trying to install SQL Server Management Studio Express on my PC running Windows XP Professional (SP2). Every time I try running it fails with an error at the very end of the installation.It ends with an error “The installer has encountered an unexpected error installing this package.This may indicate a problem with this package.The error code is 29506”. I tried looking for a solution everywhere. Some suggested running the file (here its an .msi file) from the command prompt with Administrator privileges. I tried that and it is still giving the same error.
Каждый хоть раз работающий с Visual Studio, попутно ставит SQL Management Studio Express, это бесплатная и самая обрезанная версия и для удобства работы с ней была придумана SQL Management Studio Express, как у издании выше(Developer, Enterprise). но установить там просто её не получается, за частую пользователи получают ошибку 29506 и установка не завершается и изменения откатываются назад.
Решение данной ситуации имеет два путя:
1. Отключить UAC(User Accounts Control).
2. Выполнить шаги далее не отключая UAC.
Установка с включенным UAC.
Данная ошибка связанна с безопасностью, точнее с записью значения в реест, правда не очень понятно почему она происходит тк запрос на запуском под главным администратором пользователь получает. Основная проблема заключается в том что надо запустить MSI файл с правами главного администратора, что не возможно, тк MSI был разработал для сетевой установки в основном. Я покажу вам как обойти эту проблему и установить SQL Management Studio Express на Windows Vista/Seven x64.
Существует два способа, но основа их одна — командная строка(cmd)
1. Более простой для пользователя.
- Скопировать SQLServer2005_SSMSEE_x64.msi в корень диска С или скопировать адрес текущего местонахождения
- Создать новый текстовый файл и вписать в него, например: START /WAIT C:SQLServer2005_SSMSEE_x64.msi
- Сохранить его, с расширением bat
- Запустить от главного администратора, как на картинке ниже
- Радоваться установленному SQL Management Studio Express
2. Более простой для сис-администратора.
- Запустить cmd с правами главного администратора, как на картинке ниже
- Скопировать SQLServer2005_SSMSEE_x64.msi в корень диска С или скопировать адрес текущего местонахождения
- Выйти в корень диска С, через команду cd
- Сделать папку активной в которой находиться установщик SQL Management Studio Express
- Набрать SQLServer2005_SSMSEE.msi и нажать «Enter»
PS Данная процедура может использоваться для все установщиков старых программ:-)
10 июля, 2009 —
Posted by |
Администрирование и Настройка | Администрирование, одна management studio express, ошибка 29506, ошибка при запуске sql management studio, ошибка при установке sql management studio, Express на Windows Vista/Seven x64, management studio express 2008 как установить, MS Windows, SQL 2005, SQL 2008, sql 29506, sql management studio, sql management studio 2008 on windows 7, SQL Management Studio Express, SQL Server, sql server management studio express vista, sql x64 manag, ssmsee 2005 sql seven x64, ssmsee 2005 sql vista x64, windows 7 sqlserver2005_ssmsee_x64, Windows Seven, Windows Seven RC1
When you are installing Microsoft SQL Server Management Studio Express on Windows Vista or Windows 7, you may receive this error message:
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 29506.
This error message relates with permission issue (UAC) on Windows Vista and Windows 7. To solve this problem, you have to re-run the installer again using elevated command prompt by run the command prompt as administrator and execute the installer in there. If you are using 64-bit Windows, you should use the command prompt at C:WindowsSysWOW64cmd.exe instead. Otherwise, you can use the command prompt at C:WindowsSystem32cmd.exe.
- 32-bit Windows : Run elevated command prompt by right-click on Command Prompt in Start -> All Programs -> Accessories -> Command Prompt and select Run as administrator.
- 64-bit Windows: Run the command prompt in C:WindowsSysWOW64. Right-click on cmd.exe and select Run as administrator.
- On User Account Control, click Yes.
- On Command Prompt (both 32-bit and 64-bit Windows), change path to directory where the installer file is and execute the file. By default, the file name for 32-bit version is SQLServer2005_SSMSEE.msi and 64-bit version isSQLServer2005_SSMSEE_x64.msi.
- On Setup Wizard, follow the instruction as usual. There won’t be the error message this time.