Sql Server 2016 change provider of local host

• TryingToLearn

  SSCrazy

  Points: 2645

  More actions

  March 12, 2022 at 4:01 pm

  #3998077

  I am updating all Linked servers in use provider MSOLEDBSQL. i don't know how to change the local host? Any suggestions appreiacte

  server_id name product provider data_source

  0 LOCALHOST SQL Server SQLNCLI LOCALHOST

  server_id name product provider data_source

  2 REMOTEDB EMOEDB MSOLEDBSQL REMOTEDB

   

   

   

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  March 13, 2022 at 4:10 pm

  #3998546

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.