SQL Server 2005 Issues

Question

I am trying to install SQL Server 2005 Standard Version and unable to complete the installation procedure. It gave me errors:

• COM Plus Catalog Requirement
• Edition Change Check

For COM Plus: The message is --> If SQL Sever Setup fails. Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more info, see --> How to: Work Around COM+ Check Failure in SQL Server Setup.

For Edition Change: The message is --> To change an existing instance of MS SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

After selecting SQL Server Database Services, Analysis Services, Reporting Services, Notification Services and Integration Services it is saying to select Default instance or Named instance. Either way it is displaying another screen with no selection at the bottom with a message like: The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on Details.

Name: Microsoft SQL Server 2005 (XYZ)

Allowed Action: Maintain (Action is only available from Add or Remove Programs)

Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Analysis Services (XYZ)

Allowed Action: Maintain (Action is only available from Add or Remove Programs)

Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Reporting Services (XYZ)

Allowed Action: Maintain (Action is only available from Add or Remove Programs)

Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Integration Services

Allowed Action: Maintain (Action is only available from Add or Remove Programs)

Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

The setup process is completing the installation with two Errors:

• SQLXML4 --

=== Verbose logging started: 8/11/2012  9:29:06  Build type: SHIP UNICODE 5.00.7601.00  Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (F0:E8) [09:29:06:002]: Resetting cached policy values
MSI (c) (F0:E8) [09:29:06:002]: Machine policy value 'Debug' is 0
MSI (c) (F0:E8) [09:29:06:002]: ******* RunEngine:
           ******* Product: C:\SQL Server 2005\1\Setup\sqlxml4.msi
           ******* Action:
           ******* CommandLine: **********
MSI (c) (F0:E8) [09:29:06:003]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (F0:E8) [09:29:06:003]: Grabbed execution mutex.
MSI (c) (F0:E8) [09:29:06:005]: Cloaking enabled.
MSI (c) (F0:E8) [09:29:06:005]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (F0:E8) [09:29:06:005]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (90:60) [09:29:06:012]: Running installation inside multi-package transaction C:\SQL Server 2005\1\Setup\sqlxml4.msi
MSI (s) (90:60) [09:29:06:012]: Grabbed execution mutex.
MSI (s) (90:80) [09:29:06:014]: Resetting cached policy values
MSI (s) (90:80) [09:29:06:014]: Machine policy value 'Debug' is 0
MSI (s) (90:80) [09:29:06:015]: ******* RunEngine:
           ******* Product: C:\SQL Server 2005\1\Setup\sqlxml4.msi
           ******* Action:
           ******* CommandLine: **********
MSI (s) (90:80) [09:29:06:015]: Note: 1: 2203 2: C:\SQL Server 2005\1\Setup\sqlxml4.msi 3: -2147287038
MSI (s) (90:80) [09:29:06:015]: MainEngineThread is returning 2
MSI (s) (90:60) [09:29:06:020]: User policy value 'DisableRollback' is 0
MSI (s) (90:60) [09:29:06:020]: Machine policy value 'DisableRollback' is 0
MSI (s) (90:60) [09:29:06:020]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (90:60) [09:29:06:021]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (90:60) [09:29:06:021]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (90:60) [09:29:06:022]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (90:60) [09:29:06:022]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (90:60) [09:29:06:022]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (s) (90:60) [09:29:06:022]: Restoring environment variables
MSI (c) (F0:E8) [09:29:06:028]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (F0:E8) [09:29:06:029]: MainEngineThread is returning 2
=== Verbose logging stopped: 8/11/2012  9:29:06 ===

• Notification Services gave me error as well.

NOTE:

I would like to clean uninstall and install again with Developer Edition as well so I will use SharePoint 2007 and SharePoint 2010 on the same machine.

When I started SQL Server Management Studio, it gave me error: Login failed for Computer\User (Microsoft SQL Server, Error: 18456

Pls help me out to fix this issue.

Regards

Answer 1

Do you have SQL Server 2005 Service Pack 3 installed?  This is the minimum that SharePoint 2010 requires.

---

http://sharepoint.nauplius.net

Answer 2

Good Afternoon Travor,

I have Service Pack 3 for SQL Server 2008, Service Pack 3 for SQL Server Reporting Services for 2005 ENU (KB955706) and Service Pack 3 for SQL Server Analysis Services for 2005 ENU (KB955706).

Answer 3

Hi Computer eyes,

You mentioned that your end goal was to run SharePoint 2007 and SharePoint 2010 on the same machine.  However, this is not possible; It's one or the other.  You could use the same SQL backend for both 2007 and 2010 but the 2007 and 2010 binaries cannot be installed on the same machine.

Also, in regards to the failed SQL login you may want to verify that mixed authentication is enabled on SQL Server.  You may also want to check the event logs on the Windows Server and to get more information.  Once you've found the event log for the failed login you can check the Error State as indicated in the following blog to determine more information regarding the login failure:

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

---

-Chopps

Answer 4

Hi Jimmy,

I need help in the clean uninstall SQL Server 2005 and its granular entries from registry and from Program Files folder. Kindly give me steps so I will uninstall and then instal again. Only SQL Server is giving hard time in installing and configuring sometimes with other versions like 2008 and others.

I am developing applications (WebParts, Workflows and many more things) for SharePoint. I am having Visual Studio 2005, 2008 and 2010 along with SQL Server Developer, Standard and Professional versions.

Answer 5

Typically, all you have to do to remove SQL Server is to go through Programs and Features in the control panel and remove SQL Server along with any other components.  Reboot the server and there should be no more references to include any references in the registry. 

---

-Chopps

Answer 6

Hi Jimmy,

Is it possible for you to see my screen via TeamViewer and my ID is 679 343 690. My phone # is 630-290-6252 based in Chicago, USA.

Kindly call me if you do have time to help me out and fix this a time-going issue.

Regards,

Ali