Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Changing Instance and Best Practice for Provider String in Linked Server conf

Hi Bill,

Our company is asking Salesforce to change the instance that salesforce is running on, in order to get off of NA1!

at the moment we have a linked server that is pointing to in the "Provider String" field

Our other servers are simply pointing to

A couple of questions are:
1. I see in the documentation that you recommend an empty provider string. Is this still the case? If so is this best practice in your opinion

2. I can make a guess that the server that points to NA1 will start to fail on the move over. In your opinion will the other server continue to function? (we will change based on your answer to question 1 i.e blank OR

Many Thanks

1 person has
this question