Skip to Content

Could not create connection from RS to MSSQL

Hi all,

I am trying to create a replication environment from ASE to MSSQL

When I execute following command:

create connection to CLUTSMTYRCI.Catalogos

using profile rs_ase_to_msss;standard

set username to "Par4rsc"

set password to "CowdJtis4"

set error class to scotia_msss_error_class


I receive following errors:


I. 2015/09/21 12:07:07. SQM starting: 108:0 CLUTSMTYRCI.Catalogos

E. 2015/09/21 12:07:07. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 18456, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=CLUTSMTYRCI|SQLState=28000|Native Error=18456|Message=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'Par4rsc'.[Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]'.

E. 2015/09/21 12:07:07. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 30000, State 0, Severity 16 -- 'Login failure. <SMR>'.

E. 2015/09/21 12:07:07. ERROR #1027 USER(uslibm) - seful/cm.c(3910)

Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.

E. 2015/09/21 12:07:07. ERROR #13045 USER(uslibm) - seful/cm.c(3914)

Failed to connect to server 'CLUTSMTYRCI' as user 'Par4rsc'. See CT-Lib and/or server error messages for more information.

W. 2015/09/21 12:07:07. WARNING #15542 USER(uslibm) - dl/ddldb.c(5655)

Connection to server <CLUTSMTYRCI> failed. Command batch not executed. See the Replication Server error log for details.

T. 2015/09/21 12:07:07. (97): Command(s) intended for 'CLUTSMTYRCI.Catalogos':

T. 2015/09/21 12:07:07. (97): 'drop table rs_info'

E. 2015/09/21 12:07:08. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 18456, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=CLUTSMTYRCI|SQLState=28000|Native Error=18456|Message=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'Par4rsc'.[Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]'.

E. 2015/09/21 12:07:08. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 30000, State 0, Severity 16 -- 'Login failure. <SMR>'.

E. 2015/09/21 12:07:08. ERROR #1027 USER(uslibm) - seful/cm.c(3910)

Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.

E. 2015/09/21 12:07:08. ERROR #13045 USER(uslibm) - seful/cm.c(3914)

Failed to connect to server 'CLUTSMTYRCI' as user 'Par4rsc'. See CT-Lib and/or server error messages for more information.

W. 2015/09/21 12:07:08. WARNING #15542 USER(uslibm) - dl/ddldb.c(5655)

Connection to server <CLUTSMTYRCI> failed. Command batch not executed. See the Replication Server error log for details.

T. 2015/09/21 12:07:08. (97): Command(s) intended for 'CLUTSMTYRCI.Catalogos':

T. 2015/09/21 12:07:08. (97): 'create table rs_info (rskey varchar (20), rsval varchar (20))'

E. 2015/09/21 12:07:08. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 18456, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=CLUTSMTYRCI|SQLState=28000|Native Error=18456|Message=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'Par4rsc'.[Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]'.

E. 2015/09/21 12:07:08. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 30000, State 0, Severity 16 -- 'Login failure. <SMR>'.

E. 2015/09/21 12:07:08. ERROR #1027 USER(uslibm) - seful/cm.c(3910)

Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.

E. 2015/09/21 12:07:08. ERROR #13045 USER(uslibm) - seful/cm.c(3914)

Failed to connect to server 'CLUTSMTYRCI' as user 'Par4rsc'. See CT-Lib and/or server error messages for more information.

W. 2015/09/21 12:07:08. WARNING #15542 USER(uslibm) - dl/ddldb.c(5655)

Connection to server <CLUTSMTYRCI> failed. Command batch not executed. See the Replication Server error log for details.

T. 2015/09/21 12:07:08. (97): Command(s) intended for 'CLUTSMTYRCI.Catalogos':

T. 2015/09/21 12:07:08. (97): 'insert into rs_info values ('charset_name', 'iso_1')'

E. 2015/09/21 12:07:08. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 18456, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=CLUTSMTYRCI|SQLState=28000|Native Error=18456|Message=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'Par4rsc'.[Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]'.

E. 2015/09/21 12:07:08. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 30000, State 0, Severity 16 -- 'Login failure. <SMR>'.

E. 2015/09/21 12:07:08. ERROR #1027 USER(uslibm) - seful/cm.c(3910)

.

.

.

Message from server: Message: 18456, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=CLUTSMTYRCI|SQLState=28000|Native Error=18456|Message=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'Par4rsc'.[Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]'.

E. 2015/09/21 12:07:11. ERROR #1028 USER(uslibm) - seful/cm.c(3910)

Message from server: Message: 30000, State 0, Severity 16 -- 'Login failure. <SMR>'.

E. 2015/09/21 12:07:11. ERROR #1027 USER(uslibm) - seful/cm.c(3910)

Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.

E. 2015/09/21 12:07:11. ERROR #13045 USER(uslibm) - seful/cm.c(3914)

Failed to connect to server 'CLUTSMTYRCI' as user 'Par4rsc'. See CT-Lib and/or server error messages for more information.

W. 2015/09/21 12:07:11. WARNING #15542 USER(uslibm) - dl/ddldb.c(5655)

Connection to server <CLUTSMTYRCI> failed. Command batch not executed. See the Replication Server error log for details.

T. 2015/09/21 12:07:11. (97): Command(s) intended for 'CLUTSMTYRCI.Catalogos':

T. 2015/09/21 12:07:11. (97): 'commit'

I. 2015/09/21 12:07:11. The DSI thread for database 'CLUTSMTYRCI.Catalogos' is started.

E. 2015/09/21 12:07:11. ERROR #13113 DSI(108 CLUTSMTYRCI.Catalogos) - seful/cm.c(4079)

Failed to obtain a reference to the indicated Connector. See messages from Connector factory for details. Data server make: mssql. Connector type: msnative. Data server: CLUTSMTYRCI. Database: Catalogos.

I. 2015/09/21 12:07:11. No Sybase library information is available.

I. 2015/09/21 12:07:11. The DSI thread for database 'CLUTSMTYRCI.Catalogos' is shutdown.

The connection is created but is down.

If I connect thru DC I reach the server with the same user and password without error.

Thanks for your help.

Luz Rodriguez



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 21, 2015 at 10:09 PM

    Hi Luz Rodriguez


    Drop the old connection completely to remove any traces.


    There is a "display_only" option for "create connection" RS command with a profile .

    If you run that it will show the actual commands RS server tries to run.

    And it tells you where it tries to run those.


    You can then take the command content and try running these by hand.


    E.g. While setting up Oracle connection I used that feature to find what was failing and why.


    So the full create connection command with display option for you will be :


    create connection to CLUTSMTYRCI.Catalogos

    using profile rs_ase_to_msss;standard

    set username to "Par4rsc"

    set password to "CowdJtis4"

    set error class to scotia_msss_error_class

    display_only

    go


    HTH


    Avinash

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Avinash,

      After we executed the alter connection command, the replication worked, only we got error 13110:

      W. 2015/10/07 14:09:35. WARNING #13110 DSI EXEC(111(1) CLUTSMTYRCI.Catalogos) - ul/cmapp.c(2017)

      'CLUTSMTYRCI.Catalogos' does not return native errors. Error action mapping may not be correct.


      This error is generated by CR 664491, The workaround is included in document 2090946.


      Thanks a lot for your help

      Luz rodriguez

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.