error while setting up linked error

  • atulyan.aries

    SSCommitted

    Points: 1998

    Hi

    I get the error Client and Server cannot communicate...they do not posses a common algorithm

    how to resolve this

    Regards

     

  • Mr. Brian Gale

    SSC-Insane

    Points: 22932

    Could you post the exact error message?

    I have links all over the place with different SQL versions (ranging from 2008 R2 to 2016) and everything seems to work without  much trouble.

    What version of SQL are you using on the 2 instances?  What provider are you using?

    What options are you turning on on the linked server?

    If you run just a VERY basic linked server creation script, does it succeed?  Something like:

    EXEC master.dbo.sp_addlinkedserver @server = N'TESTLINK', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N'server\instance,port'
    /* For security reasons the linked server remote logins password is changed with ######## */
    EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TESTLINK',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='########'
    GO

    That should create a very basic linked server for you connecting as sa (change the remtuser and rmtpassword values).

Viewing 2 posts - 1 through 2 (of 2 total)

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