full uninstall of MSSQL 2005 Ent SP1

Hi,

I am facing a serious problem with the unproper uninstall. I have installed MSSQL 2005 Enterprise and created an Active Directory at the server. I have removed the AD and wanted to uninstall SQL 2005.

I was not able to uninstall it fully. I have reinstalled it several times, just to tryying to remove the registry entries.

Is there a solution / tool or a document describing, how I can fully manually remove MS SQL 2005 from a server?

I have already installed SP1.

Dejan

What isn't being uninstalled? Is the uninstall completing, but leaving behind files/registry keys? Or does the uninstall fail somewhere along the way?

Thanks,
Sam Lester (MSFT)

|||

Hi Dejan,

here is an article for removal of SQL Server 2005 which would be helpful to you but in order to get a good answer please re-phrase your question is that only registry which won't removes or some files are their ?

http://msdn2.microsoft.com/en-us/library/aa337087.aspx

Regards

|||

Hi Sam,

I am sorry for my late reply. The uninstall is successful, but the install already reports some errors. It leaves files and registry entries behind.

\Program Files (x86)\Microsoft SQL Server\90\COM

REPLAGNT.dll

REPLDP.dll

snapshot.exe

sqlwep.dll

sqlresld90.dll

\Program Files (x86)\Microsoft SQL Server\90\EULA

\Program Files (x86)\Microsoft SQL Server\90\Shared

D:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn

Here is a portion of the MSSQL 2005 registry entries left behind in the registry after uninstall. Although I delete it manually from the registry (via regedit), it does not help me when I try reinstalling MS SQL 2005 Ent. (64-bit).

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Class Name: <NO CLASS>
Last Write Time: 12/3/2006 - 12:13 PM

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
Class Name: <NO CLASS>
Last Write Time: 11/18/2006 - 8:39 AM

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
Class Name: <NO CLASS>
Last Write Time: 11/18/2006 - 8:39 AM
Value 0
Name: CurrentVersion
Type: REG_SZ
Data: 9.00.2047.00

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
Class Name: <NO CLASS>
Last Write Time: 11/18/2006 - 8:39 AM
Value 0
Name: ProtocolList
Type: REG_MULTI_SZ
Data: np

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Np
Class Name: <NO CLASS>
Last Write Time: 11/18/2006 - 8:39 AM
Value 0
Name: PipeName
Type: REG_SZ
Data: \\.\pipe\sql\query

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp
Class Name: <NO CLASS>
Last Write Time: 11/18/2006 - 8:39 AM
Value 0
Name: TcpPort
Type: REG_SZ
Data: 1433

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
Class Name: <NO CLASS>
Last Write Time: 11/18/2006 - 8:39 AM
Value 0
Name: SQLPath
Type: REG_SZ
Data: D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL

|||

Hi,

after uninstall, I noticed on many places that registry entries have not been removed (several hundred places). I do not have a complete list (too many entries).

After uninstall, I try to install MSSQL 2005 Ent. (64-bit) once again. System Configuration Check goes fine (all are with status = Success). See the attached report at the end (att 1).

At the selection of components, I check all options (I can not select SQL Server failover cluster).

I select "Default instance". For service account, I choose "Use built-in System account" and select "Local system". By default, the following are selected to start and the end of the setup (SQL server, Analysis Service, Reporting Service). SQL Server agent is unchecked. Also, "Customize for each service account is unchecked".

For the Authentication Model, I select Mixed model (I have entered a password).

SQL Collation is set to "Slovenian dictionary order, case-sensitive, for use with 1250 (Central European).

Report Server is set to default configuration.

Overview of the installing components (see att 2). I click "Install" to start the installation.

I get an error message : An instance with the same name already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name. (Error at SQL Server Database Service). See att 3 for more details from the log file.

I get also an error message with the Reporting services : "There was un unexpected failure during the setup wizard. You may review the setup logs ... Event ID: 50000. I have my content of the 2 installation CDs copied to a hard disk.

__

Att 1:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Success)

Messages

Operating System Service Pack Level Requirement.

Check Passed

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Success)

Messages

Minimum Hardware Requirement

Check Passed

- IIS Feature Requirement (Success)

Messages

IIS Feature Requirement

Check Passed

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Performance Monitor Counter Requirement (Success)

Messages

Performance Monitor Counter Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

Att 2

The following components will be installed:SQL Server Database Services

(Database Services, Replication, Full-Text Search)Analysis Services

Reporting Services(Reporting Services, Report Manager)Notification Services

Integration Services

Client Components(Connectivity Components, Management Tools, Business Intelligence Development Studio, SQL Server Books Online)

Att 3

<Func Name='ValidateInstanceName'>
Error Code: 0x80076db6 (28086)
Windows Error Text: Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Wed Sep 21 01:10:12 2005
Function Name: ValidateInstanceName
Source Line Number: 445

Error Code: 28086
MSI (s) (E8!D4) [12:45:13:054]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 28086. An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

Error 28086. An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
<EndFunc Name='LaunchFunction' Return='28086' GetLastError='0'>

|||

Hi,

here are steps to perform Manuall uninstalltion of SQL Express Edition

http://support.microsoft.com/kb/909967

http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx

Hemantgiri S. Goswami

|||

Hi Hemantgiri,

thank you for your reply. Is the uninstall the same for the SQL 2005 64-bit Dev Edition?

Thanks!

Dejan

|||

Hi Dejan,

AFAIK it is the same process to be follow while uninstalling 64-bit edition.

HTH

Hemantgiri S. Goswami