Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk group configuration with sql 2005 on diferent server
- This topic has 5 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
May 30, 2008 at 8:46 AM #19812
I have a BizTalk 2006 R2 Developer Edition installed on a Windows Server 2003 SP2, and I need to configure the BizTalk with a SQL Server 2005 SP2 on a diferent computer, but on this computer has 2 versions of SQL, they are SQL 2005 SP and SQL 2000, and when I’m going to configure the BizTalk Group on this server I can not, I recieve an error, as described as follow:
[INFO] WMI CoCreate Microsoft.BizTalk.Deployment.Deployer
[INFO] WMI Deploying ‘C:\Program Files\Microsoft BizTalk Server 2006 Microsoft.BizTalk.GlobalPropertySchemas.dll’
[WARN] AdminLib GetBTSMessage: hrErr=80070002; Msg=The system cannot find the file specified.;
[WARN] AdminLib GetBTSMessage: hrErr=c0c02560; Msg=Failed to read “KeepDbDebugKey” from the registry.
The system cannot find the file specified.;After 2 days working to solve this, I tried to install SQL 2005 SP2 on the same server where BizTalk is installed, after this when I went to configure, in the first time, I got, but only localy, and I need to configure the databases of BizTalk on diferent server.
Anyone have any idea, anything to tell me about this problem to help me?
Thanks
Thiago Di Giorgio
MCP/MCTS
-
May 30, 2008 at 9:49 AM #19813
Does each version of SQL have an instance name? Are you specifying the instance name in BizTalk?
Neal
-
May 30, 2008 at 11:55 AM #19815
Yes each version of SQL have an especific name, the instance I want to use is the servidor03\sql_nd02 (SQL 2005) and we have another instance on the same server named servidor03\SQL_DESV (SQL 2000), and ofcourse I’m specifying the right name in the configuration.
I have no idea what can be happening!
-
May 30, 2008 at 12:48 PM #19816
Another idea – nothing for sure. Have you tried running DTCPing and DTCTester (free downloads from Microsoft) first? This will assure that the Distributed Transaction Coordinator is set up and working properly. If it’s not – you can get strange errors during install. I’ve almost made it a habit to run these two utilities before attempting a BizTalk install/config.
Neal
-
June 2, 2008 at 11:02 AM #19830
Ha Neal, thanks, your answer helped me a lot, I tried to test DTC, and figured out that the error was because the DNS, the IP of the biztalk computer was wrong, I changed the IP in the DNS and the group was configured normaly.
Thanks a lot!!!!!
Thiago Di Giorgio
-
-
-
-
May 31, 2008 at 6:05 AM #19821
That error message makes me suspect the BizTalk installation is corrupt. Have you tried repairing the installation? It could also very well be an MSDTC issue. Have you carefully checked the DTC settings on the BizTalk and SQL server, and made sure they are as specified in the BizTalk docs?
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.