Home > Resources > SQL Server > Fix Error 29506 in SSMS Installation

Fix Error When Installing SQL Server Management Studio Express on Windows 7

By the end of SQL Server Management Studio Express installation on Windows 7 computer, suddenly a message pops up prompting that the installation is failed because of unexpected error 29506.

error 29506 in SQL Server Management Studio installation

I cannot realize the seriousness of this error at first, and think as long as try again, it would be solved, since I have just installed successfully SQL Server Management Studio Express on VM. The same SQL Server Management Studio Express is downloaded separately from Microsoft.

After several tries, the error still occurs. So I could only search the Internet to look for explanation and solution to this SSMS installation error. Originally this problem has involved to permission. And if you want to solve it, you would need higher authority to run the installation file of SSMS and install SSMS with cmd.

Fix Error 29506 with Command Prompt Run as Administrator

Step 1: Run Command Prompt as administrator.

Point to the location of cmd.exe and right-click it to run as administrator.

Step 2: Locate the directory of SQL Server Management Studio Express installation file with command.

fix SSMS installation error with command run as administrator

Step 3: Type command "msiexec" and press Enter. A prompting dialog will appear and show the details about what command "msiexec" can do. Click OK.

introduction about msiexec command

Step 4: Input command below and press Enter to launch SSMS setup program.

msiexec /i SQLServerxx_SSMSEE.msi /gf

launch SSMS setup program with msiexec command

In the following, you just need to install SSMS as usual on Windows computer until it is finished. It will be successfully installed on your computer.

complete SQL Server Management Studio Express setup

Related Articles:

Hot Categories
Windows Password
Product Key Finder
SQL Password
More +
Hot Articles
4 Ways to Change SQL Server SA Password
SQL Server 2012 SA Password Reset
How to Login SQL Server after SA Account Locked Out
How to Change Server Authentication Mode in SQL Server
How to Enable Mixed Mode Authentication for SQL Server
More +
Latest Articles
How to Correct SQL Login Failed Error after SA Password Forgot
Solve SQL Server Connection Error 26
How to Fix Login Failed to SQL Server
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +