sql server 2005 uninstallation issues!

sql server 2005 uninstallation issues!

Error message when you uninstall SQL Server 2005 or install SQL Server 2005 Service Pack 1:

 "The setup has encountered an unexpected error while Setting Internal Properties. The error is:

 Fatal error during installation"

SYMPTOMS

When you uninstall Microsoft SQL Server 2005, you receive the following error message:

The setup has encountered an unexpected error while Setting Internal Properties. 
The error is

: Fatal error during installation.

This problem occurs when you perform the following operations 
before you uninstall SQL Server 2005:

• You install the Active Directory directory service on the server.
• You install SQL Server 2005.
• You remove Active Directory from the server.

In another scenario, after you move Microsoft Windows from one domain to another domain,

you receive the same error message when you install Microsoft 
SQL Server 2005 Service Pack 1 (SP1).

CAUSE

This problem occurs because the SQL Server user groups do not match the corresponding

 security IDs in the Windows registry.

SQL Server 2005 requires that the SQL Server user groups match the corresponding 

security IDs in the Windows registry to successfully install or uninstall SQL Server 2005.

Back to the top

WORKAROUND

To work around this problem, follow these steps:

Start Registry Editor, and then locate one of the following registry subkeys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2005\Setup

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup

Note Only one of these registry subkeys will exist on your computer.

Empty the following registry entries:

SQLGroup

FTSGroup

AGTGroup

Exit Registry Editor.

Uninstall SQL Server 2005 or install SQL Server 2005 SP1.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are

 listed in the "Applies to" section.

APPLIES TO

Microsoft SQL Server 2005 Standard Edition

Microsoft SQL Server 2005 Workgroup Edition

Microsoft SQL Server 2005 Developer Edition

Microsoft SQL Server 2005 Enterprise Edition

Microsoft SQL Server 2005 Service Pack 1

Original Message:

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

XML schema target namespace Shouldn't contain the keywords listed in the below URL

http://msdn.microsoft.com/en-us/library/ms946140.aspx

All of sudden biztalk server 2006 admin console not responding, start throwing errors. The wonder is all errors looks like connectivity with SQL server.


Types of Errors
Porblem1:


MMC could not create a snap-in. The snap-in might not have been installed correctly.
Name:Microsoft BizTalk Server Administration
CLSID:FX: {9A77C670-2FFD-4ab4-8F20-169C08FB8320}


Reason:
If it is long running server, there might be a performance issue. So we have to place performance counter to find  where the issue will be. to do that we have just follow below steps (got from microsoft web)

How to manually recreate missing BizTalk performance counters

To identify performance issues in a BizTalk solution, you should rely on the performance counters that BizTalk Server uses. All the BizTalk performance counters should be  added to the registry when you run the configuration wizard. If the registry keys were overwritten somehow, those performance counters were gone.  You could use the configuration wizard to recreate those missing BizTalk performance counters, but it requires reconfiguring the features that use the performance counters. To do so you should unconfigure them first, which is something you might not want to do.  Even though it is undocumented, you can manually populate those resister keys for the missing performance counters.

There are two types of the performance libraries that BizTalk Server uses:

1. BTSPerfMonExt.dll for the performance objects that the unmanaged code of BizTalk Server uses.

2. netfxperf.dll for the performance objects that the managed code of BizTalk Server uses.

• Note: netfxperf.dll is a .NET framework component. It is shared for all .NET performance counters. For more information about netfxperf.dll see .NET Performance Counters.

The following tables shows which performance library is used for each BizTalk performance object:

Object	Performance Counter Library	Installer
BizTalk:Message Box:*	netfxperf.dll	Microsoft.BizTalk.MsgBoxPerfCounters.dll
BizTalk:Message Agent BizTalk:File Receive Adapter BizTalk:File Send Adapter BizTalk:HTTP Receive Adapter BizTalk:HTTP Send Adapter BizTalk:POP3 Receive Adapter BizTalk:FTP Receive Adapter BizTalk:FTP Send Adapter BizTalk:MSMQ Receive Adapter BizTalk:MSMQ Send Adapter BizTalk:SOAP Receive Adapter BizTalk:SOAP Send Adapter BizTalk:SMTP Send Adapter BizTalk:SQL Receive Adapter BizTalk:SQL Send Adapter BizTalk:Messaging BizTalk:Messaging Latency	BTSPerfMonExt.dll	BTSPerfMonExt.ini BTSPerfMonExt.h
BizTalk: BAS TPM Management Web Service	netfxperf.dll	Microsoft.BizTalk.KwTpm.TPMgmtWSPerf.dll
BizTalk: BAS TPM Publishing Web Service	netfxperf.dll	Microsoft.BizTalk.KwTpm.TPPubWSPerf.dll
BizTalk:Windows SharePoint Services Adapter	netfxperf.dll	Microsoft.BizTalk.KwTpm.WssAdapter.Runtime.dll
BizTalk:TDDS	netfxperf.dll	Microsoft.BizTalk.Bam.EventBus.dll

To recreate the performance counters using netfxperf.dll, you can use InstallUtil.exe in the .NET Framework. If the assembly is installed in the GAC, you can run InstallUtil.exe as follows:

Installutil /i /assemblyname ", Version=, Culture=neutral,
PublicKeyToken="

For example,

InstallUtil /i /assemblyname "Microsoft.BizTalk.MsgBoxPerfCounters, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

If it is not, you can run InstallUtil.exe as follows:

InstallUtil /i 

For example,

InstallUtil /i Microsoft.BizTalk.KwTpm.TPMgmtWS.dll

To recreate the performance counters using BTSPerfMonExt.dll,  you can use lodctr.exe and unlodctr.exe as follows:

• Note: lodctr.exe is a tool for registering new performance counters, and unlodctr.exe is for removing performance counters. For more information about these tools, see How to manually rebuild Performance Counter Library values.

1. Copy the BTSPerfMonExt.ini and BTSPerfMonExt.h files to the %windir%\system32 folder.
2. At a command prompt, go to the the %windir%\system32 folder, and then type the following command to uninstall the damaged performance counters.

unlodctr "BTSSvc.3.0"

3. Then, type the following command to reinstall the BizTalk performance counters:

lodctr BTSPerfMonExt.ini

==================================================================================
Problem2:


biztalk  admin console failed to connect BiztalkmgmtDb 


 Reason:

This error occurs, If we are try to connect, database server from Biztalk with Unprivileged user account.


Resolution:

1. Account connecting from biztalk to sql server should have the necessary permission in sql server.
2. If installation under domain, make sure that DC up and running

Problem3:

TITLE: BizTalk Server 2006 Administration Console

------------------------------

Could not retrieve transport type data for Receive Location 'Receive Location5' from config store. Primary SSO Server 'sqlserver' failed. Cannot perform encryption or decryption because the secret is not available from the master secret server. See the event log (on computer 'mysystem') for related errors.

 (Microsoft.BizTalk.SnapIn.Framework)

For help, click: http://go.microsoft.com/fwlink/?LinkId=47400&ProdName=Microsoft+BizTalk+Server+2006&ProdVer=3.5.1602.0&EvtSrc=Microsoft.BizTalk.ExplorerOM.Resources&EvtID=IDS_ERR_RL_SSO_GETCONFIG

Reason and Resolutions

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