- This topic has 5 replies, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
-
-
You may have to go into the SQL 2005 Configuration Utility (Surface Configuration) and enabled \”named pipes\” and enable remote access. It seems like over-kill security, but by default, other machines cannot access your SQL server.
-
Getting the following error message when I try to deploy my BizTalk 2006 project.
Error 1 Deployment cannot initialize the connection to the database \”Dev_BizTalkMgmtDb\” on server \”XXXXX\”. 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. The database or the database version is incompatible with the installed version of this product.
When I right-click project, go to Deployment, enter server. It finds the Configuration database fine. I am also able to connect remotely to this database with no problem. The SQL does allow remote connections. Both named pipes and tcp-ip is enabled from BizTalk config. DTC is config to minimum secuity.
Any ideas?
Thanks!
-
[quote:48df13b7c9=\”Stephen W. Thomas\”]Is the user you are running under a member of the SSO Affiliate Admin and a BizTalk Server Admin?
If all else fails, you might want to try making the user a local Server Admin.[/quote:48df13b7c9]
Yep. One of the first things I did was threw my user into the administrators group.
-
Now getting
Error 1 SQL exception: \”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)\”
The SQL server is configured to allow remote connections. SQL Browser service is started.
Ideas?
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.