Kbase P126213: Error 6179 starting AppServer connecting to remote SQL server from data server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/22/2009 |
|
Status: Verified
SYMPTOM(s):
Error 6179 starting AppServer connecting to remote SQL server from data server
Login was denied because of an authorization error. (6179)
Login failed for user 'name'. Reason: Not associated with a trusted SQL Server connection.
FACT(s) (Environment):
SQL server 2005 server (database ) is remote
SQL server 2005 native client driver is used by data server
Using windows authentication
Logged in to the data server machine as a domain user
The domain user is admin to both the data server machine and the SQL server 2005 database machine
prowin32 connects to the remote SQL server database with no errors using the same parameter file
Only AppServer have errors
The admin service is started by local account
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
When using windows authentication, the remote user (the user that data server uses to login) has to be authenticated by the SQL server 2005 server machine. Since AppServer is started by local user, that user is not recognized by the SQL server
FIX:
Start admin service as the domain user, or start admin service as local user but assign the domain user as the owner of the AppServer broker within the broker's properties
or use _probrkr. Start _probrkr process as the domain user