Post reply

Replication Setup

  • January 10, 2011 at 12:02 pm

    #229927

    Hi All,

    We are trying to set up the replication between teo cluster sql instances.

    whe we are trying to set up the subscriber we are getting below error:

    Changed database context to 'CTX-DEV'.

    OLE DB provider "SQLNCLI" for linked server "REPLLINK_USMKESQLPD-1509463212_CTX-D-806261540_CTX-D201864889_CTX-D-806261540" returned message "Login timeout expired".

    OLE DB provider "SQLNCLI" for linked server "REPLLINK_USMKESQLPD-1509463212_CTX-D-806261540_CTX-D201864889_CTX-D-806261540" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server

    2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

    HResult 0xFFFF, Level 16, State 1

    SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

    NULL

    Can anybody please suggest me how to resolve this ?

    Thanks in Advance!!

    Thank You.

    Regards,
    Raghavender Chavva

  • January 24, 2011 at 2:53 am

    #1277088

    On the subscriber,Just check whether the login through which you are trying to connect to SQL Server Management Studio has access to the database.

    Satnam

  • January 27, 2011 at 8:17 am

    #1279103

    its using sqlagent service accounts, which is same for both the servers, as we use same service accounts for all the systems which are in same domain.

    Thank You.

    Regards,
    Raghavender Chavva

  • January 28, 2011 at 4:59 am

    #1279621

    hi all

    i'm need learning to replication between 2 remote server.

    for example :

    i have 2 server : server1 & server2

    i need:once at day,server2 connect to server1 and get changes.

    note:

    1-server1 & server2 in other times are offline.

    2-i will use Static IP for connecting.

    3-size of data -> between 30MB and 100MB

    4- can i use FTP for transfer data?

    please help me.

    thanks.

  • February 2, 2011 at 7:20 am

    #1281432

    Hi,

    It seems like you are using a script to setup replication. Have you tried using GUI? 🙂

    ~Nag

  • February 4, 2011 at 4:04 am

    #1282348

    nagarajaitha (2/2/2011)

    Hi,

    It seems like you are using a script to setup replication. Have you tried using GUI? 🙂

    ~Nag

    Yes, but also tried with GUY, no use. still failed.

    Thank You.

    Regards,
    Raghavender Chavva

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply