What Is name space?

Simply, it is a Unique identification of a XML elements

Why namespace?

In XML, To avoid conflict between the Elements, we are using the namespace. It is dfined in the schema Level.

To know more, pls visit

http://msdn.microsoft.com/en-us/magazine/cc302166.aspx

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

Can't able connect with SSODB from biztalk admin console

Can't able connect with SSODB from biztalk admin console

There are lot of causes and solutions available in the internet. But I have the issue which is entirely different from others and fortunately I have solved the issue!!!!
root Cause:
I have did something in the biztalk admin console regarding Entereprise SSO configuration.

Problem:

I can't restart or start the application in the console.

Solation:

1.Reconfigure the SSO related thing from the stable documentation or try recall from your memeory if possible
2.Restore the stable config with the export config options

BTS 2004 VS 2006

BTS 2004 VS 2006

BIZTALK SERVER 2006 IMPROVEMENTS

“Applications” In Biztalk 2004
For each solution developed there are a set of inter-related artifacts (schemas, maps, pipelines, orchestrations, receive ports, receive locations, send ports, other...) that need to be managed. In BizTalk Server 2004 the idea of a formal application container did not exist.
The result was a mishmash of BizTalk artifacts that required thorough documentation to or access to the original developer ;) to understand their relation.

In Biztalk 2006
To improve the productivity of the developer and administrator, BizTalk Server 2006 introduces the BizTalk "Application”. In BizTalk 2006, an application is a logical grouping of all the BizTalk design-time artifacts (schemas, maps, pipelines, orchestrations), messaging components (receive ports, receive locations and send ports) and other related items such as policies that comprise an integrated business process. Therefore as the number of complex applications increases they can still be individually managed in a simple and intuitive manner.

Great… Isn’t it???


“BizTalk Administration Console”
In Biztalk 2004
To administrate Biztalk artifacts logon on to that server and open MMC.
To monitor message and services go to HAT.
To import binding files go to Biztalk Deployment wizard
To import policies go to Rules Engine deployment wizard.

In Biztalk 2006:
Every thing mention above will be achieved by going only to BizTalk Administration Console. It will be having ability to create, configure and manage one or more applications across multiple servers. Additionally, the MMC includes the ability to import and export applications for installation across multiple servers or for facilitating moving between staging and production environments.

Yes, you can view HAT as well in MMC.
Although message monitoring is no longer a function of HAT, Biztalk 2006 gives new “hub” pages which give an administrator visibility into messaging active within BizTalk in same MMC.

Also, you can import bindings/policies from same MMC.


“Artifacts Dependencies Hell”
In BizTalk Server 2004
We have to start, stop, enlist, and bind artifacts individually. As dependencies grew it was up to developer to understand all the dependencies between artifacts and to stop these artifacts in order based on their dependencies before deploying or redeploying.

In BizTalk Server 2006
Administration console makes it much, much easier. With a single click on the application, all the artifacts contained within will be started in the correct sequence and the application will instantly be ready to process messages

There is also significant improvement in Packaging Biztalk solution again through single MMC.

DTCPing Utility

DTCPing Utility

Use the DTCTester utility to verify transaction support between two computers if SQL Server is installed on one of the computers. The DTCTester utility uses ODBC to verify transaction support against a SQL Server database. For more information about DTCTester see How to Use DTCTester Tool.

Use DTCPing to verify transaction support between two computers if SQL Server is not installed on either computer. The DTCPing tool must be run on both the client and server computer and is a good alternative to the DTCTester utility when SQL Server is not installed on either computer.