- This topic has 16 replies, 1 voice, and was last updated 3 years, 5 months ago by
.
-
Posts
-
-
HI,
we have BizTalk and SQL server running on the same box (both development and production). I would like to separate them on different boxes.
Can anyone please advise the steps /guide to do this task. Do I need re-install Biztalk Again?
Please advise as soon as poosible.
Thank you in anticipation
Sangeetha
-
Hi Sangeetha.
We run here also BizTalk and the Database on different servers. The only thing you have to take care about are new AD Groups and Andmin rights.
Here is a link to a document which explains what goups you have to build: http://www.microsoft.com/downloads/details.aspx?FamilyID=9C697E02-D1BC-4684-8748-28B3A292D5BF&displaylang=en&displaylang=en
Scroll down and download the thrid document.
After installing all needed groups etc. you just have to re-configure the BizTalk Server again.
Hope this helps.
Wolfgang
-
Hi,
Thank you for this information. But I need clarification, our BIZTALK server is already up and running. We have SQL and BizTalk on the same server, now I want to separate them.
Do I need re-installation? in this case how do I separate?
Please help
Thank you
Sangeetha
-
Hi.
On your BizTalk Server the is under All Programs -> Microsoft BizTalk Server 2009 a program called BizTalk Server Configuration. This you should use to unconfigure and re-configur with the datas to the new SQL Server. The only thing I don’t know is what will be if you use the BAM Tools. Because of the Application Pools in IIS.
First I would save the configuration with the BizTalk Server Confugartion.
Second I would unconfigure with the BizTalk Server Configuration.
Third re-configure Biztalk again with the new database links (you should have build the new groups etc.)
But as I said before – I did’t know if you will go back and for the new configuration what will be with the IIS AppPools for BAM. But the connection to the new SQL is going smooth…
I hope this ok for you.
Wolfgang
-
Thank you Wolfgang. Currently we have comfigured BAM, but we are not usng it. I am pretty new for BAM concepts. Can I keep my BAM as it is without changing them as we are not using them and mey not use in near future.
Please advise.
-
What you can do is, leave the BAM configured as it is and unconfigure just the other connection for BizTalk.
I would just un- and re-configure Enterprise SSO, Group, BizTalk Runtime and BRE for the new SQL Server.
Because this should work without BAM as well. It is here the same, we configured BAM, but we didn’t used it ath the moment.
What I know about BAM is, that it is not a must have for running BizTalk Server.
Wolfgang
-
Thank you again.
One last question, I have create the Biztalk databases in the new SQL server right? can I copy/paste mdf from the local sql server to the new ones?
Please advise.
-
Hi,
Save from yourself problem of copying and restoring BizTalk DB’s. Not sure it would work at all. Just unconfigure the existing configuration, and configure form the beginning.
If you don’t use BAM/BRE/EDI – don’t install – less parts installed – less stuff to deal with 🙂
Also pay attention for MSDTC – it must be configured properly.
-
-
Hi,
I am getting error configuring the group. Here is some of the errors that I am getting.
2010-07-27 22:00:38:0227 [INFO] WMI CWMIInstProv::EnumerateInstances() try to acquire lock
2010-07-27 22:00:38:0258 [INFO] WMI CWMIInstProv::EnumerateInstances() lock acquired successfully
2010-07-27 22:00:38:0274 [INFO] WMI CWMIInstProv::EnumerateInstances(MSBTS_GroupSetting) started
2010-07-27 22:00:38:0274 [INFO] WMI CWMIInstProv::EnumerateInstancesWithQuery(MSBTS_GroupSetting) started
2010-07-27 22:00:38:0290 [INFO] WMI CAdmCoreInstance::Load() started for ‘Group’ DBObject
2010-07-27 22:00:38:0290 [WARN] AdminLib GetBTSMessage: hrErr=c0c024bf; Msg=The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.;
2010-07-27 22:00:38:0305 [ERR] WMI Failed in RetrieveInstances in CWMIInstProv::EnumerateInstancesWithQuery(). HR=c0c024bf
2010-07-27 22:00:38:0305 [ERR] WMI WMI error description is generated: The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
2010-07-27 22:00:38:0321 [INFO] WMI CWMIInstProv::EnumerateInstances() finished. HR=c0c024bf
[10:00:38 PM Error BtsCfg] f:\bt\890\private\source\setup\prod\btssetup\btscfg\btswmi.cpp(1012): FAILED hr = c0c024bf[10:00:38 PM Error BtsCfg] The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
[10:00:38 PM Info BtsCfg] Leaving function: CBtsCfg::UnConfigureFeature
[10:00:38 PM Info BtsCfg] Leaving function: CBtsCfg::ConfigureFeature
[10:00:38 PM Warning Configuration Framework]Feature failed to configure: WMI.
[10:00:38 PM Info Configuration Framework]Configuration Summaries:
[10:00:38 PM Error Configuration Framework]Feature: [Group] Failed to configure with error message [Failed to create subscription database “BizTalkMsgBoxDb” on server “CC-DT-IT-01”.
Cannot find the object ‘bts_UpdateCopyTrackedMessagesJob’, because it does not exist or you do not have permission.SQL script file: “C:\Program Files\Microsoft BizTalk Server 2009\Schema\\msgboxlogic.sql”
SQL command batch: “GRANT EXEC ON [dbo].[bts_UpdateCopyTrackedMessagesJob] TO BTS_ADMIN_USERS
“]Can someone helps
Thank you
-
-
Hi,
Did you decide to reconfigure your BizTalk on remote SQL?
If so – did you configure MSDTC on both servers? (BizTalk + SQL)?
Your user under which run service – is it Active Direcory defined? Because it must – groups and users need to be defined in domain.
The user under which will run BizTalk service – need for configuration to have sufficient rights on master – while configuring BizTalk, it creates DataBases and jobs, and different objects like this.
In my case – sysadmins define the service account as administrator on SQL, and after if they want to set lower rights – they do so.
Your error seems like unsufficient rights on SQL.
Good Luck,
Yonathan.
-
Hi,
I have done all the following successfully(thank you all for your inputs)
1. installed SSO on new SQL server
2. Un-configured and Re-Configured the sso, groups, EDI/AS2 etc
3. Restored the databases to the new server.
4. Connected the group in BizTalk Administration
I can now see the Msgbox and Mgmt DB showing my new server name.
Only thing which I am unable to follow is when I go back in BizTalk Configuration , I still see the ENTSSO configured on the old/current server and not pointing to the new SQL server.
Is it something wrong?
Secondly , can I safely uninstall SQL server and ENTSSO from my current machine.
Your advise is very imp to me.
Please advise
Thank you all again. I will detail all the steps that I did after this task is completed successfuly
-Sangeetha
-
First you have to install your new database server an leave it as it is. No installation of other databases are required so far.
Unconfigure on the BizTalk server SSO, Groups an whatever you need.
Just configure BizTalk new – also the parts you have unconfigured before.
The first thing you have to configure is the SSO and you will see on the database server, that there will be a new table automatically installed.
If this isn’t working properly, please check the log.
And one more thing. Check that DTC is enabled that means on the database side is Network DTC Access enabled with Allow Inbound and Allow Outbound and no Authentification Required. So it works for me.
I hope this helps.
Wolfgang
-
-
-
-
-
-
-
-
-
-
-
-
The Dirty Girls Social Club by Alisa Valdés-Rodríguez · 9781250765864
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.