Yes I have a domain user account. Yes, I have sysadmin rights on the SQL Server.
I attempted to configure the BizTalk Server giving the SQL Server name of the other machine. Only the Enterprise SSO, MSMQT and BRE features succeeds. All the other features fails. Tried to reconfiger the Group feature (which trys to create Managment, Messagebox and Data DB’s in the other Machine) fails.
In the log i get a set of errors loged. It is as below.
[12:01:14 PM Error Configuration Framework]Feature: [Group] Failed to configure with error message [Failed to create SQL login for BizTalk Administrators Group on database server “CT-SDESILVA”.
Windows NT user or group ‘CT-SDESILVA\BizTalk Server Administrators’ not found. Check the name again.]
[12:01:14 PM Error Configuration Framework]Feature: [BizTalk Runtime] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [] Failed to configure with error message [Feature is skipped due to dependent feature (BizTalk Runtime) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [HWS Runtime] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [HWS WebService] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [] Failed to configure with error message [Feature is skipped due to dependent feature (HWS Runtime) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [] Failed to configure with error message [Feature is skipped due to dependent feature (BizTalk Runtime) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [BAM Tools] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [BAM Portal] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [BizTalk EDI/AS2 Runtime] Failed to configure with error message [Feature is skipped due to dependent feature (BizTalk Runtime) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [] Failed to configure with error message [Feature is skipped due to dependent feature (BizTalk Runtime) failed to configure correctly.]
The BizTalk box has the “BizTalk Server Administrators” Group. The SQL Box doesn’t have the “BizTalk Server Administrators” Group. BizTalk is not installed in the SQL box. I tried manually creating a “BizTalk Server Administrators” group in the SQL Box, yet no use.