Kbase P42582: Getting error 7255 and 6142 when trying to connect to SQL Server database using unified (mssbroker1)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/09/2008 |
|
Status: Verified
SYMPTOM(s):
Getting error 7255 and 6142 when trying to connect to SQL Server database using unified (mssbroker1) or _probrkr
No server available. DataServer connection failure. (7255)
Failed to connect to the MSS Database. (6142).
FACT(s) (Environment):
Uses the following connection parameters in the shortcut:
with unified broker (mssbroker1):
prowin32 -db <Schema holder name> -N tcp -H <dataserver machine name> -S <port the SH is running on> -db <ODBC DSN name> -dt MSS -ld <logical name> -H <DataServer machine name> -S <NameServer port> -DataService mssbroker1 -U <user name> -P <password> -Dsrv SVUB,1
with _probrkr:
prowin32 -db <Schema holder name> -N tcp -H <dataserver machine name> -S <port the SH is running on> -db <ODBC DSN name> -dt MSS -ld <logical name> -H <DataServer machine name> -S <broker port> -U <user name> -P <password>
The DataServer license is a SQL Server Personal DataServer
The workgroup database license is installed in the same machine.
MS SQL DataServer
Progress 9.1x
Windows NT 32 Intel/Windows 2000
CAUSE:
The Progress SQL Server Personal DataServer does not have server capabilities. Personal DataServer license can only be used locally to the DataServer machine without using the broker. In order to use broker in a client/server configuration, the SQL Server Enterprise DataServer license is required.
FIX:
Install Progress SQL Server Enterprise DataServer license