SQL Server 2005 Installation Failure with Windows Installer installed the product. Product Name: Microsoft Office 2003 Web Components. Product Version: 11.0.6558.0. Product Language: 1033. Installation success or error status: 1635. MainEngineThread is returning 1635 + OWC11SP3.MSP + Microsoft Office 2003 Web Components -- Installation failed.

Today i was working on an installation failure ,For SQL Server 2005 in Windows Sever 2003, I was reviewing the logs and from the logs .

FROM THE LOGS:
==============

MSI (s) (D0:54) [19:29:01:692]: Unable to create a temp copy of patch 'OWC11SP3.msp'.
MSI (s) (D0:54) [19:29:01:692]: Searching provided command line patches for patch code {34E1EB8F-BDB2-475C-BD80-A86217C41B4D}
MSI (s) (D0:54) [19:29:01:692]: Note: 1: 1708
MSI (s) (D0:54) [19:29:01:692]: Product: Microsoft Office 2003 Web Components -- Installation failed.
MSI (s) (D0:54) [19:29:01:692]: Windows Installer installed the product. Product Name: Microsoft Office 2003 Web Components. Product Version: 11.0.6558.0. Product Language: 1033. Installation success or error status: 1635.
MSI (s) (D0:54) [19:29:01:692]: MainEngineThread is returning 1635

I got stumbled with the issue, and i was researching a lot and finally fixed the issue.

STEPS FOLLOWED:
===============
1.Downloaded the OWC from http://www.microsoft.com/en-us/download/details.aspx?id=22276.
2.Tried to install the OWC.
3.Installation Failed an so identified that there is problem with the previous installation and it was corrupted.
4.Took a backup of the Registry.
5.Renamed the Registry Key HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\90404A0900063D11C8EF10054038389C
to HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\OLD_90404A0900063D11C8EF10054038389C.
6. Reinstalled the OWC.
7.Restarted the SQL Installation and it completed successfully.

Hope this finds Interesting.

Error result: -2058354685, Result facility code: 1360,Result error code: 3

Today i was working on a hot fix installation failure, and to fix the issue i checked the logs and from the logs

2013-11-16 16:48:59 Slp:
2013-11-16 16:48:59 Slp: Error result: -2058354685
2013-11-16 16:48:59 Slp: Result facility code: 1360
2013-11-16 16:48:59 Slp: Result error code: 3

To resolve the issue i did the following troubleshooting steps.

ACTION PLAN:
=============

• Uninstall The patch for the all the components of SQL Server.
• Took the Backup Of Registry.
• Modify the value for the Registry Key MPT_AGENT_CORE_CNI Under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\Configuration State from 4 to 1.
• Rebooted the server.
• Checked if the build Number has change to 10.50.2500.
• Stopped SQL SERVER and WMI Interface.
• Re install the patch.
• But the Above steps failed with the same error message.
• Stopped Windows Management Instrumentation Service and the other dependencies on it.
• Renamed the file  perf-MSSQL10_50.MSSQLSERVER in the location c:\windows\system32 and c:\windows\SysWOW64 to old_perf-MSSQL10_50.MSSQLSERVER.
• Ran the setup again and asked for a reboot and the server was rebooted.
• Started the setup again and it ran successfully.

Error: 9004 Severity: 21 State: 1

Today i saw a DB was in Recovery state and i wanted to check why it was in recovery state for a log time, so i checked the SQL Error Log and from the Error log i found the below error Message.

ERROR MESSAGE:
==============
An error occurred while processing the log for database 'X'.  If possible restore from backup. If a backup is not available<c/> it might be necessary to rebuild the log.

11/04/2013 21:17:29,spid17s,Unknown,Error: 9004<c/> Severity: 21<c/> State: 1.

CAUSE:
======

The Transaction Log File is Corrupted.

Resolution :
========

Fix the corruption by restoring from the latest backup or Rebuild the log file.

Can not rename the database name because it is published or it is a distribution database used by replication. (Microsoft SQL Server, Error: 18855

Today i was on a corruption issue, and i had to rename a database and when attempted to restore the database i got the below error message.

Error Message:

 ==================================

Can not rename the database name because it is published or it is a distribution database used by replication. (Microsoft SQL Server, Error: 18855.

Cause:

====

The newly Created the database is a part of replication confirmed this from the column IS_PUBLISHED of sys.databases system view.

Resolution:

=======

Fixed the issue by Removing the Replication from the database by issuing the below command .

sp_removedbreplication @dbname=name of the db.