分别在两个不同的服务器安装appserver和sqlserver，出现appser启动不了的问题。Start -> All Programs -> Open Edge Explore -> Management Console. 在这里启动，发现启动不了，报的错是Login failed for user ''


原因是admin server for OpenEdge要使用域帐号，而不是本地帐号连接到另一个装sql server的服务器。

103328713.png

这个服务应当使用域帐户登录。并满足以下2项要求：

1. 这个域帐户应当可以访问远程SQL Server，我在测试环境里直接给这个域帐户SQL Server sysadmin的角色。

103419476.png

否则在启动AppServer时会在Epicor905.server记录以下错误：

（1）当ODBC配置成Windows身份验证时

[13/05/10@04:52:22.642-0700]P-004440 T-004776 1 AS -- Login was denied because of an authorization error.(6179)

[13/05/10@04:52:22.642-0700]P-004440 T-004776 1 AS -- 28000: [Microsoft][SQL Server Native Client 10.0][SQLServer]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

[13/05/10@04:52:22.642-0700]P-004440 T-004776 1 AS -- Failed to connect to the MSS database. (6142)

[13/05/10@04:52:22.642-0700]P-004828 T-004896 1 AS -- Error initializing the application server. (5479)

（2）当ODBC配置成sa帐号时

[13/05/10@04:54:25.978-0700]P-005272 T-005160 1 AS -- Login was denied because of an authorization error.(6179)

[13/05/10@04:54:25.978-0700]P-005272 T-005160 1 AS -- 28000: [Microsoft][SQL Server Native Client 10.0][SQLServer]Login failed for user ''.

[13/05/10@04:54:25.978-0700]P-005272 T-005160 1 AS -- Failed to connect to the MSS database. (6142)

[13/05/10@04:54:25.982-0700]P-005272 T-005160 1 AS -- Error initializing the application server. (5479)


2. 这个域帐户应当是ApplicationServer的本地管理员。否则，AdminService 没有权限打开的默认20931端口，从而客户端无法与AppServer通讯。