|
Home > Archive > BizTalk Server Setup > April 2006 > Error Configuring Biztalk - 80040e14
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error Configuring Biztalk - 80040e14
|
|
|
| I am trying to install and configure Biztalk 2004 and get
an error during the configure related to the Biztalk DB in
SQL Server. On previous attempts I was able to add an
account by hand using Enterprise Manager even though the
Biztalk configure step failed.
using:
Windows 2000 Server (Service Pack 4)
SQL Server 2000 Service Pack 3a (select @@version gives
8.00.760)
MDAC 2.8 (registry says 2.80.1022.3)
collation sequence is SQL_Latin1_General_CP1_CI_AS
using SQL Server and Windows Authentication
Installation of SQL Server is also new (as part of Biztalk
install). Everything is running on one machine.
Configure error log extract is below.
I have limited experience doing this kind of
install/configure so I may be doing something simple that
is wrong. Do you have any suggestions? Thanks in advance
for your help.
[11:35:25 AM Info SSOServerCfg] The Single Sign-On (SSO)
service is running
[11:35:25 AM Info SSOServerCfg] Generating the Master
Secret
[11:35:25 AM Info SSOServerCfg] Leaving function:
CSSOServerCfg::ConfigureFeature
[11:35:25 AM Info ConfigFramework] Successfully configured
feature: SSOServer,Engine
[11:35:25 AM Info ConfigFramework] Retrieved cached
IConfig object for feature: MessageQueuing ProgID:
MSEBiz.MSMQTConfig
[11:35:25 AM Info ConfigFramework] Currently configuring:
MessageQueuing
[11:35:25 AM Info MSMQTConfig] Entering function:
CMSMQTConfig::ConfigureFeature
[11:35:25 AM Info MSMQTConfig] Message Queuing will use
computer name WIN2003SERVER-H
[11:35:25 AM Info MSMQTConfig] Message Queuing will bind
to all IP addresses on this computer (no side-by-side mode)
[11:35:25 AM Info MSMQTConfig] Leaving function:
CMSMQTConfig::ConfigureFeature
[11:35:25 AM Info ConfigFramework] Successfully configured
feature: MessageQueuing
[11:35:25 AM Info ConfigFramework] Retrieved cached
IConfig object for feature: RulesEngine ProgID:
MSEBiz.RuleEngineConfig
[11:35:25 AM Info ConfigFramework] Currently configuring:
RulesEngine
[11:35:25 AM Info RuleEngineConfig] Entering function:
CRuleEngineConfig::ConfigureFeature
[11:35:25 AM Info RuleEngineConfig] Configuring Feature:
RulesEngine
[11:35:25 AM Info ConfigHelper] Connected to WMI namespace
[11:35:25 AM Info ConfigHelper] set security credentials
to WMI namespace
[11:35:25 AM Info ConfigHelper] Did not find
existing database: BizTalkRuleEngineDb on computer:
WIN2003SERVER-H
[11:35:26 AM Info ConfigHelper] Created SQL
database: BizTalkRuleEngineDb on computer: WIN2003SERVER-H
collation: Default
[11:35:26 AM Info ConfigHelper] Executed SQL
script: C:\Program Files\Microsoft BizTalk Server 2004
\Schema\\BTS_Security_Logic.sql on database:
BizTalkRuleEngineDb on computer: WIN2003SERVER-H
[11:35:26 AM Info ConfigHelper] Executed SQL
script: C:\Program Files\Microsoft BizTalk Server 2004
\Schema\\BTS_Version_Schema.sql on database:
BizTalkRuleEngineDb on computer: WIN2003SERVER-H
[11:35:26 AM Info ConfigHelper] Executed SQL
script: C:\Program Files\Microsoft BizTalk Server 2004
\Schema\\BTS_Version_Logic.sql on database:
BizTalkRuleEngineDb on computer: WIN2003SERVER-H
[11:35:26 AM Info ConfigHelper] Executed SQL
script: C:\Program Files\Microsoft BizTalk Server 2004
\Schema\\Backup_Setup_All_Tables.sql on database:
BizTalkRuleEngineDb on computer: WIN2003SERVER-H
[11:35:26 AM Info ConfigHelper] Executed SQL
script: C:\Program Files\Microsoft BizTalk Server 2004
\Schema\\Backup_Setup_All_Procs.sql on database:
BizTalkRuleEngineDb on computer: WIN2003SERVER-H
[11:35:27 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:35:28 AM Info ConfigHelper] Executed SQL
script: C:\Program Files\Microsoft BizTalk Server 2004
\Schema\\BTS_RulesEngine_Schema.sql on database:
BizTalkRuleEngineDb on computer: WIN2003SERVER-H
[11:35:28 AM Info ConfigHelper] Executed SQL
script: C:\Program Files\Microsoft BizTalk Server 2004
\Schema\\BTS_RulesEngine_Logic.sql on database:
BizTalkRuleEngineDb on computer: WIN2003SERVER-H
[11:35:28 AM Info ConfigHelper] Connected to WMI namespace
[11:35:28 AM Info ConfigHelper] set security credentials
to WMI namespace
[11:35:30 AM Error RuleEngineConfig] c:\depot4000
\jupiter\source\private\mozart\source\en
gine\rules\configfw
kext\extension\ruleengineconfig.cpp(1261): FAILED hr =
80040e14
[11:35:30 AM Error RuleEngineConfig] Failed to add
WIN2003SERVER-H\BiztalkAcct as a member of the SQL role
RE_HOST_USERS in the Rule Engine database. You probably do
not have sufficient privileges to add an SQL login, grant
database access, or modify the role membership.
[11:35:30 AM Error RuleEngineConfig] c:\depot4000
\jupiter\source\private\mozart\source\en
gine\rules\configfw
kext\extension\ruleengineconfig.cpp(530): FAILED hr =
80040e14
[11:35:30 AM Info RuleEngineConfig] Leaving function:
CRuleEngineConfig::ConfigureFeature
[11:35:37 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:35:47 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:35:57 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:36:07 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:36:17 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:36:27 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:36:37 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:36:47 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:36:57 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:37:07 AM Info ConfigFramework] Waiting for
configuration thread to complete.
[11:37:12 AM Info ConfigFramework] Showing MessageBox with
text: Failed to add WIN2003SERVER-H\BiztalkAcct as a
member of the SQL role RE_HOST_USERS in the Rule Engine
database. You probably do not have sufficient privileges
to add an SQL login, grant database access, or modify the
role membership. Return Code: 4
| |
| Bill Ticehurst 2005-03-30, 5:51 pm |
| Hi Mike,
The first thing to check is that you're a sysadmin on the box. The actual
error text would indicate a permissions issue.
The actual error code returned (80040e14) however is generally a SQL syntax
error. It appears this occurred trying to add the login
"WIN2003SERVER-H\BiztalkAcct" to the role "RE_HOST_USERS" in the Rules
Engine Database. The code at the file/line number outlined actually calls
into the stored procedure 'adm_AddLoginUser' which takes 2 parameters;
@LoginName and @RoleToGrant.
If the permissions look fine could you please try running this stored
procedure from SQL Query Analyzer on the rules engine database for the same
login and role, and post back with any more specific errors that occur. (Or
even if it works)
Thanks and regards,
- Bill Ticehurst [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights
"Mike" <chadwickmg@comcast.net> wrote in message
news:082601c534a4$cc920650$a601280a@phx.gbl...
>I am trying to install and configure Biztalk 2004 and get
> an error during the configure related to the Biztalk DB in
> SQL Server. On previous attempts I was able to add an
> account by hand using Enterprise Manager even though the
> Biztalk configure step failed.
>
> using:
>
> Windows 2000 Server (Service Pack 4)
>
> SQL Server 2000 Service Pack 3a (select @@version gives
> 8.00.760)
>
> MDAC 2.8 (registry says 2.80.1022.3)
>
> collation sequence is SQL_Latin1_General_CP1_CI_AS
>
> using SQL Server and Windows Authentication
>
> Installation of SQL Server is also new (as part of Biztalk
> install). Everything is running on one machine.
>
> Configure error log extract is below.
>
> I have limited experience doing this kind of
> install/configure so I may be doing something simple that
> is wrong. Do you have any suggestions? Thanks in advance
> for your help.
>
> [11:35:25 AM Info SSOServerCfg] The Single Sign-On (SSO)
> service is running
> [11:35:25 AM Info SSOServerCfg] Generating the Master
> Secret
> [11:35:25 AM Info SSOServerCfg] Leaving function:
> CSSOServerCfg::ConfigureFeature
> [11:35:25 AM Info ConfigFramework] Successfully configured
> feature: SSOServer,Engine
> [11:35:25 AM Info ConfigFramework] Retrieved cached
> IConfig object for feature: MessageQueuing ProgID:
> MSEBiz.MSMQTConfig
> [11:35:25 AM Info ConfigFramework] Currently configuring:
> MessageQueuing
> [11:35:25 AM Info MSMQTConfig] Entering function:
> CMSMQTConfig::ConfigureFeature
> [11:35:25 AM Info MSMQTConfig] Message Queuing will use
> computer name WIN2003SERVER-H
> [11:35:25 AM Info MSMQTConfig] Message Queuing will bind
> to all IP addresses on this computer (no side-by-side mode)
> [11:35:25 AM Info MSMQTConfig] Leaving function:
> CMSMQTConfig::ConfigureFeature
> [11:35:25 AM Info ConfigFramework] Successfully configured
> feature: MessageQueuing
> [11:35:25 AM Info ConfigFramework] Retrieved cached
> IConfig object for feature: RulesEngine ProgID:
> MSEBiz.RuleEngineConfig
> [11:35:25 AM Info ConfigFramework] Currently configuring:
> RulesEngine
> [11:35:25 AM Info RuleEngineConfig] Entering function:
> CRuleEngineConfig::ConfigureFeature
> [11:35:25 AM Info RuleEngineConfig] Configuring Feature:
> RulesEngine
> [11:35:25 AM Info ConfigHelper] Connected to WMI namespace
> [11:35:25 AM Info ConfigHelper] set security credentials
> to WMI namespace
> [11:35:25 AM Info ConfigHelper] Did not find
> existing database: BizTalkRuleEngineDb on computer:
> WIN2003SERVER-H
> [11:35:26 AM Info ConfigHelper] Created SQL
> database: BizTalkRuleEngineDb on computer: WIN2003SERVER-H
> collation: Default
> [11:35:26 AM Info ConfigHelper] Executed SQL
> script: C:\Program Files\Microsoft BizTalk Server 2004
> \Schema\\BTS_Security_Logic.sql on database:
> BizTalkRuleEngineDb on computer: WIN2003SERVER-H
> [11:35:26 AM Info ConfigHelper] Executed SQL
> script: C:\Program Files\Microsoft BizTalk Server 2004
> \Schema\\BTS_Version_Schema.sql on database:
> BizTalkRuleEngineDb on computer: WIN2003SERVER-H
> [11:35:26 AM Info ConfigHelper] Executed SQL
> script: C:\Program Files\Microsoft BizTalk Server 2004
> \Schema\\BTS_Version_Logic.sql on database:
> BizTalkRuleEngineDb on computer: WIN2003SERVER-H
> [11:35:26 AM Info ConfigHelper] Executed SQL
> script: C:\Program Files\Microsoft BizTalk Server 2004
> \Schema\\Backup_Setup_All_Tables.sql on database:
> BizTalkRuleEngineDb on computer: WIN2003SERVER-H
> [11:35:26 AM Info ConfigHelper] Executed SQL
> script: C:\Program Files\Microsoft BizTalk Server 2004
> \Schema\\Backup_Setup_All_Procs.sql on database:
> BizTalkRuleEngineDb on computer: WIN2003SERVER-H
> [11:35:27 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:35:28 AM Info ConfigHelper] Executed SQL
> script: C:\Program Files\Microsoft BizTalk Server 2004
> \Schema\\BTS_RulesEngine_Schema.sql on database:
> BizTalkRuleEngineDb on computer: WIN2003SERVER-H
> [11:35:28 AM Info ConfigHelper] Executed SQL
> script: C:\Program Files\Microsoft BizTalk Server 2004
> \Schema\\BTS_RulesEngine_Logic.sql on database:
> BizTalkRuleEngineDb on computer: WIN2003SERVER-H
> [11:35:28 AM Info ConfigHelper] Connected to WMI namespace
> [11:35:28 AM Info ConfigHelper] set security credentials
> to WMI namespace
> [11:35:30 AM Error RuleEngineConfig] c:\depot4000
> \jupiter\source\private\mozart\source\en
gine\rules\configfw
> kext\extension\ruleengineconfig.cpp(1261): FAILED hr =
> 80040e14
>
> [11:35:30 AM Error RuleEngineConfig] Failed to add
> WIN2003SERVER-H\BiztalkAcct as a member of the SQL role
> RE_HOST_USERS in the Rule Engine database. You probably do
> not have sufficient privileges to add an SQL login, grant
> database access, or modify the role membership.
> [11:35:30 AM Error RuleEngineConfig] c:\depot4000
> \jupiter\source\private\mozart\source\en
gine\rules\configfw
> kext\extension\ruleengineconfig.cpp(530): FAILED hr =
> 80040e14
>
> [11:35:30 AM Info RuleEngineConfig] Leaving function:
> CRuleEngineConfig::ConfigureFeature
> [11:35:37 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:35:47 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:35:57 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:36:07 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:36:17 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:36:27 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:36:37 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:36:47 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:36:57 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:37:07 AM Info ConfigFramework] Waiting for
> configuration thread to complete.
> [11:37:12 AM Info ConfigFramework] Showing MessageBox with
> text: Failed to add WIN2003SERVER-H\BiztalkAcct as a
> member of the SQL role RE_HOST_USERS in the Rule Engine
> database. You probably do not have sufficient privileges
> to add an SQL login, grant database access, or modify the
> role membership. Return Code: 4
>
>
>
>
>
| |
| PeterW 2006-04-12, 10:18 am |
| This is a long time later... however I had the same problem with the log reporting an Error and some stuff including "ruleengineconfig.cpp(530): FAILED hr = 80040e14". A complete show stopper and time waster!
I resolved it by just deleting the database users configured for use with BizTalk and recreating them. SQL Server came up with a dialogue box indicating that other stuff would be affected. Accepted that to get rid of the dependent records elsewhere.
After that the configFramework.exe worked just fine.
Hope this is of use to someone else in the future.
cheers
Peter |
|
|
|
|