Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Counldn't configure the Rep Agent for MS SQL.

2 posts in Replication Agent Last posting was on 2005-01-05 21:57:52.0Z
Jayadev Posted on 2004-12-20 18:38:00.0Z
Sender: 13d8.41c468f6.1804289383@sybase.com
From: Jayadev
Newsgroups: sybase.public.rep-agent
Subject: Counldn't configure the Rep Agent for MS SQL.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41c71c03.3d14.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-2-dub41c71c03"
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 20 Dec 2004 10:37:55 -0800, 10.22.241.42
Lines: 242
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 20 Dec 2004 10:37:58 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 20 Dec 2004 10:38:00 -0800
X-Trace: forums-1-dub 1103567880 10.22.108.75 (20 Dec 2004 10:38:00 -0800)
X-Original-Trace: 20 Dec 2004 10:38:00 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:736
Article PK: 862379

Hi All,

We are facing problem while configuring rep agent for MS SQL
2000,

we are using following S/W

Rep agent 12.5
MS SQL 2000
Rep Server 12.5
Sybase ASE 12.5.1
Oracle 9i

this is on Window 2000.

We have followed all the steps which is given in the sybase
document, Installation and configuration 12.5 for
Replication Agent 12.5.

When we give test_connection it is showing PDS: failed and
RS: Succeeded.

This is error we get in RA instance error log. (please find
the attachment)

for connection we have given following syntax.

create connection to ra_sql_dcorasrv.pubs
set error class rs_sqlserver_error_class
set function string class rs_sqlserver_function_class
set username sql_rs
set password sql_rs
with log transfer on, dsi_suspended

sql_rs is the maintenance user of MS SQL server.

after creating this connection it is showing status as down.

this is the message we get in RS error log.

E. 2004/12/21 00:10:57. ERROR #13045 DSI(121
ra_sql_dcorasrv.pubs) - eue(2760)
Failed to connect to server 'ra_sql_dcorasrv' as user
'sql_rs'. See CT-Lib and/or server error messages for more
information.
I. 2004/12/21 00:10:57. The DSI thread for database
'ra_sql_dcorasrv.pubs' is shutdown.

we have given all rights to sql_rs login.

thanks in advance

regards
Jayadev.


> 2004/12/20 22:36:33.24. com.sybase.ra.ltm.LTM Processing request to change to state: <REPLICATE>.
>I. 2004/12/20 22:36:33.24. com.sybase.ra.la.mssql.RAMLogAdmin LogAdmin attempting to connect to PDB <pubs>.
>I. 2004/12/20 22:36:33.24. com.sybase.ra.conn.RAConnectionMgr Attempting connection to URL: jdbc:sqlserver://MSSQL_MCD141:1433:
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Attempt to unlock branded JDBC driver FAILED for connection <MSMERJDBC(server:port): 'MSSQL_MCD141:1433'> :
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Message: [SYBASE][SQLServer JDBC Driver]Error establishing socket.
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo SQLState: 08001
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Message: [SYBASE][SQLServer JDBC Driver]MSSQL_MCD141
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo SQLState: HY000
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Attempt to unlock branded JDBC driver FAILED for connection <MSMERJDBC(server:port): 'MSSQL_MCD141:1433'> :
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Message: [SYBASE][SQLServer JDBC Driver]Error establishing socket.
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException SQLState: 08001
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Message: [SYBASE][SQLServer JDBC Driver]MSSQL_MCD141
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException SQLState: HY000
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Message: [SYBASE][SQLServer JDBC Driver]Error establishing socket.
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException SQLState: 08001
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Message: [SYBASE][SQLServer JDBC Driver]MSSQL_MCD141
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException SQLState: HY000
>E. 2004/12/20 22:36:33.26. com.sybase.ra.conn.query.QueryException Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQL connection or execution failed:
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin Message: [SYBASE][SQLServer JDBC Driver]Error establishing socket.
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQLState: 08001
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin Message: [SYBASE][SQLServer JDBC Driver]MSSQL_MCD141
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQLState: HY000
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQL connection or execution failed: SQL connection or execution failed:
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin Message: [SYBASE][SQLServer JDBC Driver]Error establishing socket.
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQLState: 08001
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin Remote Code: 0
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQL ERROR --
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin Message: [SYBASE][SQLServer JDBC Driver]MSSQL_MCD141
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin SQLState: HY000
>E. 2004/12/20 22:36:33.26. com.sybase.ra.la.mssql.RAMLogAdmin Remote Code: 0
>I. 2004/12/20 22:36:33.26. com.sybase.ra.conn.RAConnectionMgr Attempting connection to URL: jdbc:sybase:Tds:MCD78:6000:
>I. 2004/12/20 22:36:33.29. com.sybase.ra.ltm.LTM Instance: ra_sql_dcorasrv - Microsoft SQL Server
>I. 2004/12/20 22:36:33.29. com.sybase.ra.ltm.LTM RepAgent: Sybase Replication Agent for Unix & Windows NT,2000/12.5.0.301/P/generic/JDK 1.2.2/main/301/VM: Sun Microsystems Inc. 1.2.2/OPT/Fri Mar 1 13:28:46 MST 2002
>I. 2004/12/20 22:36:33.29. com.sybase.ra.ltm.LTM Java Runtime Environment: Sun Microsystems Inc. 1.2.2
>I. 2004/12/20 22:36:33.29. com.sybase.ra.ltm.LTM Primary Data Server: < unknown >
>I. 2004/12/20 22:36:33.29. com.sybase.ra.ltm.LTM PDS JDBC Driver: < unknown >
>I. 2004/12/20 22:36:33.29. com.sybase.ra.ltm.LTM RepServer: Replication Server/12.5/P/PC Intel/Windows NT 4.0/1/OPT/Mon Apr 8 13:33:39 PDT 2002
>I. 2004/12/20 22:36:33.29. com.sybase.ra.ltm.LTM Sybase JDBC Driver: com.sybase.jdbc2.jdbc.SybDriver 5.5
>I. 2004/12/20 22:36:33.29. com.sybase.ra.ltm.LTM Replication Agent changed to <ADMIN> state.
>I. 2004/12/20 22:36:33.30. com.sybase.ra.lti.LTI Attempting to connect to Rep Server on <MCD78>
>I. 2004/12/20 22:36:33.30. com.sybase.ra.conn.RAConnectionMgr Attempting connection to URL: jdbc:sybase:Tds:MCD78:6000:
>I. 2004/12/20 22:36:33.32. com.sybase.ra.lti.LTI Successfully connected to the Rep Server.
>I. 2004/12/20 22:36:33.47. com.sybase.ra.la.mssql.RAMLogAdmin LogAdmin attempting to connect to PDB <pubs>.
>I. 2004/12/20 22:36:33.47. com.sybase.ra.conn.RAConnectionMgr Attempting connection to URL: jdbc:sqlserver://MSSQL_MCD141:1433:
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Attempt to unlock branded JDBC driver FAILED for connection <MSMERJDBC(server:port): 'MSSQL_MCD141:1433'> :
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo SQL ERROR --
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Message: [SYBASE][SQLServer JDBC Driver]Error establishing socket.
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo SQLState: 08001
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Remote Code: 0
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo SQL ERROR --
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo Message: [SYBASE][SQLServer JDBC Driver]MSSQL_MCD141
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerantJDBCInfo SQLState: HY000
>E. 2004/12/20 22:36:33.49. com.sybase.ra.conn.drivers.MSSqlServerMerant


Wanda Beck Posted on 2005-01-05 21:57:52.0Z
From: "Wanda Beck" <wbeck@sybase.com>
Newsgroups: sybase.public.rep-agent
References: <41c71c03.3d14.1681692777@sybase.com>
Subject: Re: Counldn't configure the Rep Agent for MS SQL.
Lines: 79
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: wbeckw2k.sybase.com
Message-ID: <41dc62dc$1@forums-2-dub>
X-Original-Trace: 5 Jan 2005 13:57:48 -0800, wbeckw2k.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Jan 2005 13:57:49 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Jan 2005 13:57:52 -0800
X-Trace: forums-1-dub 1104962272 10.22.108.75 (5 Jan 2005 13:57:52 -0800)
X-Original-Trace: 5 Jan 2005 13:57:52 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:741
Article PK: 862378

Hi, Jayadev,

Are you still encountering this problem?

SQL ERROR --
Message: [SYBASE][SQLServer JDBC Driver]Error establishing socket.
SQLState: 08001
Remote Code: 0
SQL ERROR --
Message: [SYBASE][SQLServer JDBC Driver]MSSQL_MCD141
SQLState: HY000
Remote Code: 0

Seems to me that this is an environment issue. I found this thread in the
DataDirect forum for Connect JDBC:
http://forums.datadirect.com/ddforums/thread.jspa?forumID=4&threadID=367&messageID=1770#1770
that suggests that either the host name or port is specified incorrectly.

Thanks,
Wanda

<Jayadev> wrote in message news:41c71c03.3d14.1681692777@sybase.com...
> Hi All,
>
> We are facing problem while configuring rep agent for MS SQL
> 2000,
>
> we are using following S/W
>
> Rep agent 12.5
> MS SQL 2000
> Rep Server 12.5
> Sybase ASE 12.5.1
> Oracle 9i
>
> this is on Window 2000.
>
> We have followed all the steps which is given in the sybase
> document, Installation and configuration 12.5 for
> Replication Agent 12.5.
>
> When we give test_connection it is showing PDS: failed and
> RS: Succeeded.
>
> This is error we get in RA instance error log. (please find
> the attachment)
>
> for connection we have given following syntax.
>
> create connection to ra_sql_dcorasrv.pubs
> set error class rs_sqlserver_error_class
> set function string class rs_sqlserver_function_class
> set username sql_rs
> set password sql_rs
> with log transfer on, dsi_suspended
>
> sql_rs is the maintenance user of MS SQL server.
>
> after creating this connection it is showing status as down.
>
> this is the message we get in RS error log.
>
> E. 2004/12/21 00:10:57. ERROR #13045 DSI(121
> ra_sql_dcorasrv.pubs) - eue(2760)
> Failed to connect to server 'ra_sql_dcorasrv' as user
> 'sql_rs'. See CT-Lib and/or server error messages for more
> information.
> I. 2004/12/21 00:10:57. The DSI thread for database
> 'ra_sql_dcorasrv.pubs' is shutdown.
>
> we have given all rights to sql_rs login.
>
> thanks in advance
>
> regards
> Jayadev.
>