SoftPro Connection in Mirrored Environment

[vahqac06]

LA production will include DB mirroring. Will the SP application connect to either server using the approach listed below?

Standard connection string:

Data Source= <principal instance name>;Failover Partner= <mirror instance name>;Password=<xxxxxxx>;Initial Catalog=<My Database>;Persist Security Info=True;User ID=<login Id>

David Hunt has diagrams and additional info regarding this request.

[John Morris]

Select has not been tested in that scenario, so it is hard to say. From a code prespective, it *should* work.

[vahqac06]

Where would we need to put the failover partner = string. We need to update the client on Citrix ands the select server. We need to do failover testing this week. Thanks for your help with this matter.

[John Morris]

You need to modify the web.config file setting located on the Select Server. There is a db connection string setting in that file. It's usually located at C:\Program Files\SoftPro\Select Server\Website\web.config

[JDavis]

Did you guys every get the mirroring scenerio working?

John, yes you can set the failover partner setting in the config file for the Select Server, but I notice that in the SelectConfigDb there are settings for the server names that the content database. Would we have to manually change these in the SelectConfigDb, so that when the client asks the Server where the content database is it would give them the correct one if the Content database has mirrored over?

Thanks,
Jake