Kbase P110776: Unable to connect to MS SQL Server via Unified Broker using NT Authentication
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/07/2009 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
When trying to connect to SQL Server database using unified broker (mssbroker1) error 7255 and 6142 received
DataServer connection failure. (7255)
Failed to connect to the <db-type> database. (6142)
Starting broker via Progress Explorer, client could not connect
Starting broker manually using _probrkr, the connection works fine
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxx\xxx'.
Error "Posted EAbnormalShutdownServerEvent for PID:xxx" in broker log.
Error 1891 written to dataserv.lg
BROKER: The server could not open the foreign database. (1891)
ODBC Data Source configured to use MS SQL Server's NT Authentication
MS SQL Server on different machine than where the broker is running
CAUSE:
The NT Authentication requires that the user trying to connect to the MS SQL Server database must be a domain user and can be authenticated. On the machine that the broker was started from, it was started using the "local user account" which is not a domain user and therefore could not be authenticated on the machine running SQL Server.
FIX:
In the Progress Explorer's Broker properties, enter owner information for a domain user which can be authenticated via NT Authentication on the SQL Server Machine.