dbTalk Databases Forums  

How to clean up / removing ALL sql 2005 instances whatsoever?

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.setup How to clean up / removing ALL sql 2005 instances whatsoever?

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss How to clean up / removing ALL sql 2005 instances whatsoever? in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DL
 
Posts: n/a

Default How to clean up / removing ALL sql 2005 instances whatsoever? - 03-23-2009 , 08:09 PM





My XP SP3 box has run tons of sql server 2005 installations, from
express to standard to enterprise (possibly) over the years... the
Windows Add/Remove utility has run out of its game, doing so from
registry, did not seem to have covered/removing all instances (may I
didn't know exact steps etc.). How?

Thanks.

Reply With Quote
  #2  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: How to clean up / removing ALL sql 2005 instances whatsoever? - 03-23-2009 , 08:59 PM





What do you mean "run out of its game"? Instances should remove fine from
Add/Remove Programs. Of course it won't delete MDF/LDF files for user
databases you have created (that would be bad). What exactly do you see as
not being removed?


On 3/23/09 10:09 PM, in article
4bd6e68d-f2e3-4bc2-846c-a8761ca37a37...oglegroups.com, "DL"
<tatata9999 (AT) gmail (DOT) com> wrote:

Quote:
My XP SP3 box has run tons of sql server 2005 installations, from
express to standard to enterprise (possibly) over the years... the
Windows Add/Remove utility has run out of its game, doing so from
registry, did not seem to have covered/removing all instances (may I
didn't know exact steps etc.). How?

Thanks.


Reply With Quote
  #3  
Old   
DL
 
Posts: n/a

Default Re: How to clean up / removing ALL sql 2005 instances whatsoever? - 03-23-2009 , 09:29 PM


On Mar 23, 10:59*pm, "Aaron Bertrand [SQL Server MVP]"
<ten.... (AT) dnartreb (DOT) noraa> wrote:
Quote:
What do you mean "run out of its game"? *Instances should remove fine from
Add/Remove Programs. *Of course it won't delete MDF/LDF files for user
databases you have created (that would be bad). *What exactly do you see as
not being removed?

On 3/23/09 10:09 PM, in article
4bd6e68d-f2e3-4bc2-846c-a8761ca37... (AT) j8g2000yql (DOT) googlegroups.com, "DL"



tatata9... (AT) gmail (DOT) com> wrote:
My XP SP3 box has run tons of sql server 2005 installations, from
express to standard to enterprise (possibly) over the years... the
Windows Add/Remove utility has run out of its game, doing so from
registry, did not seem to have covered/removing all instances (may I
didn't know exact steps etc.). *How?

Thanks.- Hide quoted text -

- Show quoted text -
All the instances are still showing up in the NT\Windows Services
console. It seems certain registries haven't been removed
accordingly. And a new instance installation fail. Box OS: XP SP3.
Log below. Thanks.


Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 3
(Build 2600)
Time : Mon Mar 23 15:29:05 2009

Machine : myMachine
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQLSupp ort_1.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQLNCLI _1.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SqlWrit er_1.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_MSXML6_ 1.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQLSupp ort_2.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQLNCLI _2.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_MSXML6_ 2.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL
Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine : myMachine
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL
Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL
Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (17058) .
Error Number : 29503
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_Tools.l og
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log
file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG
\Summary.txt.


Time : Mon Mar 23 15:35:44 2009


List of log files:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Core(Local).log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQLSupport_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQLNCLI_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SqlWriter_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_MSXML6_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQLSupport_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQLNCLI_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_MSXML6_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQL.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Tools.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Datastore.xml
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SNAC.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Core.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG
\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Support.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SCC.log
c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG




Reply With Quote
  #4  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: How to clean up / removing ALL sql 2005 instances whatsoever? - 03-24-2009 , 03:42 AM


"The SQL Server service failed to start" is a generic error message. You
should review the log files as the message refers. Also, check out the
Windows Event Logs.

Also, you mentioned installation of Enterprise Edition of SQL Server 2005 on
Windows XP; technically you can not do that, because by design it's not
allowed to run this edition of SQL Server 2005 on Client OSs. So what
edition is this that fails to install now?

If it's not Enterprise Edition, what account do you use as the service
account of this instance?

--
Ekrem Önsoy



"DL" <tatata9999 (AT) gmail (DOT) com> wrote

On Mar 23, 10:59 pm, "Aaron Bertrand [SQL Server MVP]"
<ten.... (AT) dnartreb (DOT) noraa> wrote:
Quote:
What do you mean "run out of its game"? Instances should remove fine from
Add/Remove Programs. Of course it won't delete MDF/LDF files for user
databases you have created (that would be bad). What exactly do you see as
not being removed?

On 3/23/09 10:09 PM, in article
4bd6e68d-f2e3-4bc2-846c-a8761ca37... (AT) j8g2000yql (DOT) googlegroups.com, "DL"



tatata9... (AT) gmail (DOT) com> wrote:
My XP SP3 box has run tons of sql server 2005 installations, from
express to standard to enterprise (possibly) over the years... the
Windows Add/Remove utility has run out of its game, doing so from
registry, did not seem to have covered/removing all instances (may I
didn't know exact steps etc.). How?

Thanks.- Hide quoted text -

- Show quoted text -
All the instances are still showing up in the NT\Windows Services
console. It seems certain registries haven't been removed
accordingly. And a new instance installation fail. Box OS: XP SP3.
Log below. Thanks.


Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 3
(Build 2600)
Time : Mon Mar 23 15:29:05 2009

Machine : myMachine
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQLSupp ort_1.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQLNCLI _1.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SqlWrit er_1.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_MSXML6_ 1.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQLSupp ort_2.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQLNCLI _2.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_MSXML6_ 2.log
--------------------------------------------------------------------------------
Machine : myMachine
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL
Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine : myMachine
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL
Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL
Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (17058) .
Error Number : 29503
--------------------------------------------------------------------------------
Machine : myMachine
Product : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_myMachine_Tools.l og
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log
file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG
\Summary.txt.


Time : Mon Mar 23 15:35:44 2009


List of log files:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Core(Local).log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQLSupport_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQLNCLI_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SqlWriter_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_MSXML6_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQLSupport_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQLNCLI_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_MSXML6_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SQL.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Tools.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Datastore.xml
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SNAC.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Core.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG
\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_Support.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
\SQLSetup0001_myMachine_SCC.log
c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG




Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top