Kbase P21909: Error 1246 & 6142 occurs when no SQL Server Enterprise _probrkr has started
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/3/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
Windows
MS SQL
MS SQL DataServer
SYMPTOM(s):
Error 1246 and 6142 occur when connecting to SQL Server Database
Cannot access <db-type> with current CONFIG file. (1246)
Cannot access MSS with current CONFIG file. (1246)
Failed to connect to the <db-type> database. (6142)
Failed to connect to the MSS Database. (6142).
Error messages are reported on the client-side
Client-side license (i.e. Client-Networking, ProVision, ProVision Plus) installed on one machine
DataServer for Microsoft SQL Server license installed on another machine
DataServer _probrkr not started
CAUSE:
In order for a 4GL client to make a connection to a SQL Server Database, through a distributed configuration, the DataServer broker must be used.
FIX:
Start the DataServer broker. The broker can be started through the following methods:
Method 1. Use the _probrkr command.
Method 2. Use Unified DataServer Broker through Progress Explorer.
Method 3. Use ProControl (with Progress 9.1x only).
The following Solution outlines each method; P72265, "How to start/stop DataServer Broker"