Not able to open the BTS admin console.

hi Guys... Recently I worked with a customer where they weren’t able to open the BTS admin console. The BTS application as such works fine, when they open the MMC, it just hangs… nothing happens.. eventually they will get a timeout error message. From MBV we aren’t able to conclude as well.
Using DebigDiag tool (you can get the tool from the following location http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1286), and here is what we found.

0:000> !clrstack
OS Thread Id: 0x3218 (0)
ESP EIP
0007e63c 7c8285ec [InlinedCallFrame: 0007e63c] <Module>.SNIReadSync(SNI_Conn*, SNI_Packet**, Int32)
0007e638 067e01e0 SNINativeMethodWrapper.SNIReadSync(System.Runtime.InteropServices.SafeHandle, IntPtr ByRef, Int32)
0007e6b0 049dfeb6 System.Data.SqlClient.TdsParserStateObject.ReadSni(System.Data.Common.DbAsyncResult, System.Data.SqlClient.TdsParserStateObject)
0007e6e8 049dfd10 System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32)
0007e6f4 067e294d System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
0007e6fc 067e28c3 System.Data.SqlClient.TdsParserStateObject.ReadByte()
0007e704 067e1ef5 System.Data.SqlClient.TdsParser.Run(System.Data.SqlClient.RunBehavior, System.Data.SqlClient.SqlCommand, System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.BulkCopySimpleResultSet, System.Data.SqlClient.TdsParserStateObject)
0007e750 067ee8b8 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
0007e764 067ee7cf System.Data.SqlClient.SqlDataReader.get_MetaData()
0007e790 067ee448 System.Data.SqlClient.SqlCommand.FinishExecuteReader(System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.RunBehavior, System.String)
0007e7c8 067e9ae6 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, Boolean)
0007e848 067e8be3 System.Data.SqlClient.SqlCommand.RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String, System.Data.Common.DbAsyncResult)
0007e894 067e8a95 System.Data.SqlClient.SqlCommand.RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String)
0007e8a4 067e87cc System.Data.SqlClient.SqlCommand.ExecuteReader(System.Data.CommandBehavior, System.String)
0007e8e0 067e874b System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(System.Data.CommandBehavior)
0007e8e4 067e8728 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(System.Data.CommandBehavior)
0007e8e8 067e8584 System.Data.Common.DbDataAdapter.FillInternal(System.Data.DataSet, System.Data.DataTable[], Int32, Int32, System.String, System.Data.IDbCommand, System.Data.CommandBehavior)
0007e93c 067e83b2 System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable[], Int32, Int32, System.Data.IDbCommand, System.Data.CommandBehavior)
0007e97c 067e829a System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable)
0007e9b0 0634709c Microsoft.BizTalk.ExplorerOM.ReceivePort.SelectAll(Microsoft.BizTalk.ExplorerOM.IRootObject)
0007e9bc 06346eb3 Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.get_ReceivePorts()
0007e9f0 06d0ca6c Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.BuildApplicationCache()
0007ea1c 00386462 Microsoft.BizTalk.Administration.SnapIn.Nodes.ApplicationsFolder.Refresh()
0007ea48 06d09729 Microsoft.BizTalk.SnapIn.Framework.ScopeNode.Refresh(System.Type)
0007ea7c 06d095cf Microsoft.BizTalk.SnapIn.Framework.ScopeNode.RefreshChildren()
0007ea84 0640bb1e Microsoft.BizTalk.Administration.SnapIn.Nodes.GroupNode.RefreshNode()
0007eabc 0640ba2b Microsoft.BizTalk.Administration.SnapIn.Nodes.GroupNode.Refresh()
0007eaf4 00385a3d Microsoft.BizTalk.Administration.SnapIn.Nodes.GroupNode.OnRefresh()
0007eafc 00385a18 Microsoft.BizTalk.Administration.SnapIn.Nodes.GroupNode.OnRefresh(System.Object, Microsoft.BizTalk.SnapIn.Framework.ActionEventArgs)
0007eb2c 01fbba91 [MulticastFrame: 0007eb2c] System.EventHandler`1[[System.__Canon, mscorlib]].Invoke(System.Object, System.__Canon)
0007eb40 00385733 Microsoft.BizTalk.SnapIn.Framework.Action.OnTrigger(Microsoft.BizTalk.SnapIn.Framework.ActionEventArgs)
0007eb90 00385587 Microsoft.BizTalk.SnapIn.Framework.Action.ExecuteMain(Microsoft.BizTalk.SnapIn.Framework.ActionEventArgs)
0007eba0 003853fe Microsoft.BizTalk.SnapIn.Framework.Action.Execute(IntPtr, IntPtr)
0007ebbc 003852ab Microsoft.BizTalk.SnapIn.Framework.Node.Notify(UInt32, IntPtr, IntPtr)
0007ec04 0640769e Microsoft.BizTalk.SnapIn.Framework.Component.Notify(UInt32, IntPtr, IntPtr, System.String)
0007ed34 06406b1d Microsoft.BizTalk.SnapIn.Framework.Component.Notify(IntPtr, UInt32, IntPtr, IntPtr)
0007ef5c 79f047fd [GCFrame: 0007ef5c]
0007f0b8 79f047fd [ComMethodFrame: 0007f0b8]

From this we see that BizTalk is not able to connect to the SQL server for some reason.
Tested by creating a simple UDL file on Biztalk node and wasn’t able to connect to the database. We were getting a similar error message. Then it was found that there was a Named Pipes entered to the SQL DB on the BizTalk node after removing which we were able to access the admin console without any issues

 

Here are some of the articles related to Names pipes.

How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by using the client tools in the earlier version of SQL Server
http://support.microsoft.com/kb/265808