Kbase P22754: How to configure MS SQL Server Dataserver broker on Windows to support remote clients?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2010 |
|
Status: Verified
GOAL:
How to configure MS SQL Server Dataserver broker on Windows to support remote clients?
GOAL:
How to configure MS SQL Server Dataserver broker on Windows to support remote clients on windows?
GOAL:
How to configure MS SQL server dataserver broker on windows to support clients running on UNIX?
GOAL:
How to configure MS SQL server dataserver broker on windows to support remote character clients?
GOAL:
How to connect from UNIX client to MS SQL server broker on windows?
FACT(s) (Environment):
OpenEdge DataServer Category: SQL Server
MS SQL DataServer
FIX:
This solution outlines simplified steps configure MS SQL Server Dataserver broker on Windows to support UNIX and/or character clients.
On the WINDOWS Server
======================
CONFIGURE ODBC DSN, this will allow MS SQL server client connection to MS SQL Server.
1. Go to Control panel -> Administrative tools -> Data sources (ODBC) -> System DSN
Add a data source with either the SQL Server driver or a Progress Driver (Progress 9.1x SQL Server driver). Configure the datasource and make sure to perform a test connection.
CREATE AND CONFIGURE SCHEMA HOLDER
2. Create a schema holder, for example mssholder.
For detailed instructions on how to create a schema holder, please reference P23300, How to create a schema holder for MS SQL server dataserver?
CONFIGURE DATASERVER BROKER
There are several ways to configure the DataServer broker. Please review chapter Configuring the Remote DataServer within the Progress DataServer for Microsoft SQL Server Guide for all the options.
-Configuring with the Progress Explorer
-Configuring from the Command Line
The example below starts the broker through the command line:
3. Open the Progress PROENV shell and start the DataServer broker
_probrkr -H hostname -S brokerservice -N tcp
Use a unique service name/port
To shut down probroker
proshut -Gw -H hostname -S brokerservice
SERVICE THE SCHEMA HOLDER TO ACCEPT REMOTE CONNECTION
4. In the same Progress PROEVN shell, proserve the database
proserve mssholder -H hostname -S dbservice -N tcp
Use a unique service name/port
ON the UNIX Server
======================
CONFIGURE AND CONNECT REMOTE CLIENT TO DSRV BROKER/SQL SERVER
Remote Charater and UNIX client
_progres mssholder -H hostname -S dbservice -N tcp -db dsn_name -dt MSS -ld logical-datasrc-name -H hostname -S brokerservice -N tcp -U userID -P password
Remote gui clients
prowin32 mssholder -H hostname -S dbservice -N tcp -db dsn_name -dt MSS -ld logical-datasrc-name -H hostname -S brokerservice -N tcp -U userID -P password
Using the unified broker will change the connection string.
For unified broker, the connection string will look similar to following:
_progres mssholder -H hostname -S dbservice -N tcp -db dsn_name -dt MSS -ld logical-datasrc-name -H hostname -S mssbroker1(or 4446 port number) -N tcp -U userID -P password -Dsrv svub,1