Unable to install SQL 2008 due to the remnants of a previous installation

  Sometime remnants of a previous installation/ a failed install can prevent us from reinstalling SQL server I have documented the consequence of one such instance which rendered us to be unable to install SQL 2008 from the server       ·         When we launched the setup we got the following  error :  …

1

SQLSERVERAGENT service fails to start , SQLServer Error: 229

Issue The SQL agent services fail to start and give the following error when we try starting it from the  services console :   When we attempt to start SQL agent services we get the following error : ————————— Services ————————— The SQLSERVERAGENT service on Local Computer started and then stopped. Some services stop automatically…

0

SQL browser fails to come online after changing it to a static port

Issue SQL clustered service fails to come online after an attempt to change a static port   ·         We noticed the following error in the SQL server error logs 2010-10-24 09:10:53.92 spid6s      The resource database build version is 9.00.4230. This is an informational message only. No user action is required.2010-10-24 09:10:54.25 spid6s      Error: 15466, Severity:…

0

SQL 2008 setup (Add node) process fails with "Value cannot be null. Parameter name: group"

SQL Server 2008 SP1 (Add Node) process fails when we attempt to add the passive node, we get the following error : From the Summary.txt : Detailed results:   Feature:                       Database Engine Services   Status:                        Failed: see logs for details   MSI status:                    Passed   Configuration status:          Failed: see details below   Configuration error code:     …

1

How do we uninstall Just the replication component in SQL 2008 ?

In order to uninstall just the Replication component in SQL 2008 we need to do the following: Method 1 1) Go into Add/remove programs and choose the instance in question :  2) Click on the Uninstall/Change button 3) Click on Remove when the landing page is launched : 4)Select the instance again (we need to…

1