SQL Server 2005: Backward Compaibility Errors


I am running a SQL Server 2000 enterprise default instance and SQL Server 2005 standard named instances on a machine. I uninstalled the default instance and tried to instance 2005 but was unable to with the error:

'an installation packages for the product Microsoft SQL Server Backward Compatibility cannot be found. Try the installation again using a valid copy of the installation packages sqlserver2005_bc.msi'



I have tried to repair the backward compatibility currently installed and have also tried runing the msi file again but it will not install.



I have also put back 2000 as the default instance. then tried to apply sp1 to the 2005 named instances and i cannot do that either. anyone have any ideas?



Thank you.

__________________
A.Rajesh Khanna

Hi,

Did repairing the Backward Compat package work for you? And when you tried to apply SP1 to your 2005 named instance, what error did you get?

Thanks,

__________________
Shaalini.S
Be the Best of Whatever you are...

Hi,

When trying to repair it could not find a local copy so i pointed it to the sqlserver2000_bc.msi on the disk and get the following error:


path\SQLServer2005_BC.msi is not a valid installation package for the product Microsoft SQL SErver 2005 Backwatd compatibility. To find the installation package 'sqlserver2005_bc.msi' in a folder from which you can install Microsoft SQL Server Backward Compatability.

and also

'an installation package cannot be found ....'

and also

'fatal error'

I have downloaded the .msi file and that still didnt work.
when i install sp1 i get the following error:

'hotfix has in ecountered a problem and needs to close.'


04/14/2009 09:37:22.782
04/14/2009 09:37:22.798 Product Status Summary:
04/14/2009 09:37:22.829 Product: SQL Server Native Client
04/14/2009 09:37:22.845 SQL Server Native Client (RTM ) - Success
04/14/2009 09:37:22.860
04/14/2009 09:37:22.876 Product: Setup Support Files
04/14/2009 09:37:22.907 Setup Support Files (RTM ) - Not Applied
04/14/2009 09:37:22.923
04/14/2009 09:37:22.938 Product: Database Services
04/14/2009 09:37:22.954 Database Services (SP1 2047 ENU) - Not Applied
04/14/2009 09:37:22.985
04/14/2009 09:37:23.001 Product: Database Services
04/14/2009 09:37:23.016 Database Services (SP1 2047 ENU) - Not Selected
04/14/2009 09:37:23.048
04/14/2009 09:37:23.063 Product: Client Components
04/14/2009 09:37:23.095 Client Components (SP1 2047 ENU) - Not Applied
04/14/2009 09:37:23.110
04/14/2009 09:37:23.126 Product: MSXML 6.0 Parser
04/14/2009 09:37:23.157 MSXML 6.0 Parser (RTM ) - Not Applied
04/14/2009 09:37:23.173
04/14/2009 09:37:23.188 Product: SQLXML4
04/14/2009 09:37:23.204 SQLXML4 (RTM ) - Not Applied
04/14/2009 09:37:23.220
04/14/2009 09:37:23.251 Product: Backward Compatibility
04/14/2009 09:37:23.266 Backward Compatibility (RTM ) - Not Applied
04/14/2009 09:37:23.282
04/14/2009 09:37:23.298 Product: Microsoft SQL Server VSS Writer
04/14/2009 09:37:23.329 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
04/14/2009 09:37:23.345

__________________
A.Rajesh Khanna

Hi All,


Did you ever get a resolution for this, I am trying exactly the same, I have deleted a 2000Ent default instance, and am trying to install a 2005 Std instance and am getting the same error on the backward compatability msi



Thanks