Unable to initialise connection to BizTalkMgmtDB!

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Unable to initialise connection to BizTalkMgmtDB!

Viewing 1 reply thread
  • Author
    Posts
    • May 23, 2006 at 11:16 AM #14731
      community-content

        Hi everybody,
        help me out please.

        Error 1 Deployment cannot initialize the connection to the database \”BizTalkMgmtDb\” on server ….. Verify that you have the required security permissions and that communication between Distributed Transaction Coordinator services on the machines involved is not prevented by current DTC security, firewall or authentication settings. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

        I am working with BTS2006 installed on Windows Server 2003 in a virtual pc. Tried to reconfigure databases from the project properties in the solution explorer. But I cannot find the installed SQL server. All I know is last week, I successfully deployed and this week I am getting this error.

        Thanks in advance,

        Chenue
        [color=blue:8f6c6076a8][/color:8f6c6076a8]

      • May 25, 2006 at 5:00 PM #14732
        community-content

          Two possibles:

          1) If you’re using SQL2k5 you will need to turn on Named Pipes and TCP/IP from the SQL Server configuration manager.

          2) When using Virutal PC you will invariably run into network connectivity issues when trying to connect to resources, even though those resources are on the same machine. On the Virtual PC you need to go to Add/Remove hardware, and manually choose & install the Microsoft Loopback adapter. Once its installed, it will show up in ControlPanel/Network Connections with an odd name like Network Connection 2. R-Click it, choose rename and give it a decent name, like ‘Loopback Adapter’. Then R-Click it again, choose Properties, scroll down to ‘Internet Protocol’ and click the Properties button. Switch to ‘Use the following IP address’ and then provide a bogus class C address, like 192.168.0.1. Press OK a couple of times and then shutdown and restart the Virtual PC.

          • May 26, 2006 at 9:19 AM #14733
            community-content

              Thanks guys, the problem is no more.

              • May 23, 2006 at 5:55 PM #14734
                community-content

                  The MSSQLServer service is running right? What happens when you use query analyzer…can you still connect to the SQL Server?

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.