2005 SP 1 Install Failure Solution - Unable to install Windows Installer MSP file

This is posted for others who have
If this error occurs here is what worked for me. I hope it may work for you
but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run
both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Installer
to include the account that is doing the install with Full Control. Click
Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and removed the SQL 2005 Setup
Files Installer and the SQL Express Installer. I then reinstalled the SQL
Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't don't do
this you won't be able to use the SP.
Q290301 OFFXP: Windows Installer CleanUp Utility
http://support.microsoft.com/support/kb/articles/q290/3/01.asp
I then reinstalled the SP and it worked.
Hope this helps somebody.
Special thanks to Peter Yang of Microsoft for his invaluable assistance on
this issue.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.comForgot to mention this is on a Windows Server 2003 SP1 platform.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
"vbnetdev" <vbnetdev@.community.nospam> wrote in message
news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> This is posted for others who have
> If this error occurs here is what worked for me. I hope it may work for
> you but am not sure.
> In my case I had SQL Express 2005 Installer on my system as well as I run
> both (one for development, one for production).
> Shut down all SQL related services manually.
> I set registry permissions on
> Software\Policies\Microsoft\Windows\Installer to include the account that
> is doing the install with Full Control. Click Advanced and make sure
> everything is selected.
> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
> Setup Files Installer and the SQL Express Installer. I then reinstalled
> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
> don't do this you won't be able to use the SP.
> Q290301 OFFXP: Windows Installer CleanUp Utility
> http://support.microsoft.com/support/kb/articles/q290/3/01.asp
> I then reinstalled the SP and it worked.
> Hope this helps somebody.
> Special thanks to Peter Yang of Microsoft for his invaluable assistance on
> this issue.
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>|||Hi,
Thanks for your feedback. This information has been added to Microsoft's
database. Your solution will benefit many other users, and we really value
having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "vbnetdev" <vbnetdev@.community.nospam>
>References: <OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl>
>Subject: Re: 2005 SP 1 Install Failure Solution - Unable to install
Windows Installer MSP file
>Date: Thu, 27 Apr 2006 10:15:48 -0500
>Lines: 50
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uQdG71gaGHA.3740@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 63-252-11-73.ip.mcleodusa.net 63.252.11.73
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429460
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Forgot to mention this is on a Windows Server 2003 SP1 platform.
>--
>Get a powerful web, database, application, and email hosting with KJM
>Solutions
>http://www.kjmsolutions.com
>
>"vbnetdev" <vbnetdev@.community.nospam> wrote in message
>news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
>> This is posted for others who have
>> If this error occurs here is what worked for me. I hope it may work for
>> you but am not sure.
>> In my case I had SQL Express 2005 Installer on my system as well as I
run
>> both (one for development, one for production).
>> Shut down all SQL related services manually.
>> I set registry permissions on
>> Software\Policies\Microsoft\Windows\Installer to include the account
that
>> is doing the install with Full Control. Click Advanced and make sure
>> everything is selected.
>> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
>> Setup Files Installer and the SQL Express Installer. I then reinstalled
>> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
>> don't do this you won't be able to use the SP.
>> Q290301 OFFXP: Windows Installer CleanUp Utility
>> http://support.microsoft.com/support/kb/articles/q290/3/01.asp
>> I then reinstalled the SP and it worked.
>> Hope this helps somebody.
>> Special thanks to Peter Yang of Microsoft for his invaluable assistance
on
>> this issue.
>> --
>> Get a powerful web, database, application, and email hosting with KJM
>> Solutions
>> http://www.kjmsolutions.com
>>
>>
>
>

2005 SP 1 Install Failure Solution - Unable to install Windows Installer MSP file

This is posted for others who have
If this error occurs here is what worked for me. I hope it may work for you
but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run
both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Inst
aller
to include the account that is doing the install with Full Control. Click
Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and removed the SQL 2005 Setup
Files Installer and the SQL Express Installer. I then reinstalled the SQL
Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't don't do
this you won't be able to use the SP.
Q290301 OFFXP: Windows Installer CleanUp Utility
http://support.microsoft.com/suppor...s/q290/3/01.asp
I then reinstalled the SP and it worked.
Hope this helps somebody.
Special thanks to Peter Yang of Microsoft for his invaluable assistance on
this issue.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.comForgot to mention this is on a Windows Server 2003 SP1 platform.
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
"vbnetdev" <vbnetdev@.community.nospam> wrote in message
news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> This is posted for others who have
> If this error occurs here is what worked for me. I hope it may work for
> you but am not sure.
> In my case I had SQL Express 2005 Installer on my system as well as I run
> both (one for development, one for production).
> Shut down all SQL related services manually.
> I set registry permissions on
> Software\Policies\Microsoft\Windows\Inst
aller to include the account that
> is doing the install with Full Control. Click Advanced and make sure
> everything is selected.
> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
> Setup Files Installer and the SQL Express Installer. I then reinstalled
> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
> don't do this you won't be able to use the SP.
> Q290301 OFFXP: Windows Installer CleanUp Utility
> http://support.microsoft.com/suppor...s/q290/3/01.asp
> I then reinstalled the SP and it worked.
> Hope this helps somebody.
> Special thanks to Peter Yang of Microsoft for his invaluable assistance on
> this issue.
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>|||Hi,
Thanks for your feedback. This information has been added to Microsoft's
database. Your solution will benefit many other users, and we really value
having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "vbnetdev" <vbnetdev@.community.nospam>
>References: <OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl>
>Subject: Re: 2005 SP 1 Install Failure Solution - Unable to install
Windows Installer MSP file
>Date: Thu, 27 Apr 2006 10:15:48 -0500
>Lines: 50
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uQdG71gaGHA.3740@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 63-252-11-73.ip.mcleodusa.net 63.252.11.73
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429460
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Forgot to mention this is on a Windows Server 2003 SP1 platform.
>--
>Get a powerful web, database, application, and email hosting with KJM
>Solutions
>http://www.kjmsolutions.com
>
>"vbnetdev" <vbnetdev@.community.nospam> wrote in message
>news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
run[vbcol=seagreen]
that[vbcol=seagreen]
on[vbcol=seagreen]
>
>

2003 web edition

Is there a reason why the SQL 2000 installer would not be running on 2003 Web
edition?
Yes, as it is a limitation of Web Edition that you can not run SQL Server
(and the other Server platform products) on it.
You need to install SQL Server on Windows 2003 Standard or higher editions.
Regards
Mike
"Ed" wrote:

> Is there a reason why the SQL 2000 installer would not be running on 2003 Web
> edition?
|||http://www.microsoft.com/windowsserv...rview/web.mspx
"Installations of non-Web serving applications are prohibited".
Regards
Mike
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Yes, as it is a limitation of Web Edition that you can not run SQL Server
> (and the other Server platform products) on it.
> You need to install SQL Server on Windows 2003 Standard or higher editions.
> Regards
> Mike
> "Ed" wrote:
|||"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Yes, as it is a limitation of Web Edition that you can not run SQL Server
> (and the other Server platform products) on it.
> You need to install SQL Server on Windows 2003 Standard or higher editions.
> Regards
> Mike
> "Ed" wrote:
What is the limitation? Is there no adminpack that can correct this?
Its like having a linux apache server that cannot run MySQL or pgsql.
To correct his I will cause downtime for my users, which is not what I want
to do.
Why didn't the installer tell me that I cannot install it?
|||"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> http://www.microsoft.com/windowsserv...rview/web.mspx
> "Installations of non-Web serving applications are prohibited".
> Regards
> Mike
> "Mike Epprecht (SQL MVP)" wrote:
The SQL database's only job in this case is to serve data to IIS.
Notepad.exe does not serve web. I dont know what quantifiable extent I should
take this up on this list with but I strongly disagree with the limitation of
SQL server. There is no hosting company that I know of who do not offer SQL
database tables. It is not you who I should complain to.
|||"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:FEC8ABA5-E241-4B81-82A5-0A068556F03C@.microsoft.com...[vbcol=seagreen]
> "Mike Epprecht (SQL MVP)" wrote:
Server[vbcol=seagreen]
editions.[vbcol=seagreen]
2003 Web
> What is the limitation? Is there no adminpack that can correct this?
The limitation is in Web Edition. It's one reason Web Edition is cheaper
than other versions of 2003.
It's intential as far as I can tell.

> Its like having a linux apache server that cannot run MySQL or pgsql.
> To correct his I will cause downtime for my users, which is not what I
want
> to do.
> Why didn't the installer tell me that I cannot install it?