SQL Server Performance

SQL Server 2000 Replication

Discussion in 'Performance Tuning for SQL Server Replication' started by curplunk52, Sep 11, 2005.

  1. curplunk52 New Member

    Experts,

    Can you help me please?

    I'm trying to learn how to manage a SQL Server.

    I wanted to replicate my database from my SQL Server 2000 Standard Ed. to my SQL Server 2000 Professional installed in one of my work station.

    I have tried to follow some on-line tutorials that I found but I still have this error.

    during my first sync. but the first snapshot was a success.

    I really need your help.

    Here is the error that I get:

    AGENT error 20048 : The process could not connect to Subscriber 'BCOY'.

    Data Source error 18452 : Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

    Thanks Experts!
    curplunk52, Sep 11, 2005
    #2

  2. dineshasanka Moderator

    dineshasanka, Sep 11, 2005
    #2

  3. satya Moderator

    This problem is more likely to occur when both Multi-Protocol and TCP/IP sockets trusted connections are attempted from the same client computer. Connection stress also makes the problem more likely to occur.

    Use one of the following workarounds:
    Use trusted connections over named pipes where appropriate.
    Disable multiprotocol for SQL Server using the Server Network Utility.


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Sep 12, 2005
    #2

  4. chaitu1385 New Member

    are the two servers that r in replication in same domain?

    krishna chaitanya sanka
    project engineer-SQLDBA

    'TO IMPROVE IS TO CHANGE....TO BE PERFECT IS TO CHANGE OFTEN!!!!
    chaitu1385, Oct 13, 2005
    #2

Share This Page