1
Vote

Wizard fails when SQL is named instance

description

When trying to run the wizard against a BizTalk installation where the BizTalk databases is on a named instance, an error occurs:
 
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
 
************** Exception Text **************
Microsoft.BizTalk.ApplicationDeployment.ApplicationDeploymentException: Cannot open 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. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.set_ConnectionString(String value)
at Microsoft.BizTalk.ApplicationDeployment.Group.CreateInstance(Type type)
--- End of inner exception stack trace ---
 
Server stack trace:
at Microsoft.BizTalk.ApplicationDeployment.Group.CreateInstance(Type type)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
 
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.BizTalk.ApplicationDeployment.Group.CreateInstance(Type type)
at Microsoft.BizTalk.ApplicationDeployment.ApplicationCollection.<GetEnumerator>d__0.MoveNext()
at BizTalk.BuildGenerator.BizTalkHelper.GetApplications()
at BizTalk.BuildGenerator.UI.UserControls.ApplicationDescriptionControl.ApplicationDescriptionControl_Load(Object sender, EventArgs e)
at System.Windows.Forms.UserControl.OnLoad(EventArgs e)
at System.Windows.Forms.UserControl.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at Divelements.WizardFramework.Wizard.g()
at Divelements.WizardFramework.Wizard.set_SelectedPage(WizardPageBase value)
at Divelements.WizardFramework.Wizard.GoNext()
at Divelements.WizardFramework.Wizard.c(Object A_0, EventArgs A_1)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

comments

clineer wrote Nov 26, 2010 at 3:29 PM

Named pipes were enabled. Also, this was on BizTalk 2010 with SQL 2K8 R1 but I am not sure if the BizTalk version matters.

Thanks,
Ben Cline

clineer wrote Nov 26, 2010 at 8:03 PM

I was able to just modify the config file for the exe. Nevermind.

Thanks,
Ben Cline

wrote Feb 13, 2013 at 5:25 PM