Cant create linked server repl_distributor

• j.snowden

  Old Hand

  Points: 317

  More actions

  June 21, 2016 at 4:15 am

  #308547

  Hi,

  I have a 2008R2 publisher and a 2012 distributor. I have set up the remote distributor by running

  --distributor

  sp_adddistributor

  sp_adddistributiondb

  sp_adddistpublisher

  --Publisher

  sp_adddistributor

  However when i run sp_adddistributor at the publisher it fails with this error

  OLE DB provider "SQLNCLI10" for linked server "repl_distributor" returned message "Unable to complete login process due to delay in opening server connection".

  Msg 7303, Level 16, State 1, Procedure sp_adddistributor, Line 168

  Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "repl_distributor".

  I have tested a connection between both the pub and the dist. There is no problem. I have tested this with windows authentication and it works, i've also logged into the distributor with the distributor_admin SQL login and that works. The only problem is creating a linked server from the 2008r2 box to the sql 2012 box. I always fails with this error. (2012 - 2008r2 I can create a linked server)

  Can anyone help with this problem?

  Thanks