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.
SoftPro Connection in Mirrored Environment
-
- Posts: 411
- Joined: Thu Sep 11, 2008 11:35 am
- Location: Raleigh, NC, USA
- Contact:
Re: SoftPro Connection in Mirrored Environment
Select has not been tested in that scenario, so it is hard to say. From a code prespective, it *should* work.
John Morris
Sr. Software Architect
SoftPro
Sr. Software Architect
SoftPro
Re: SoftPro Connection in Mirrored Environment
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.
-
- Posts: 411
- Joined: Thu Sep 11, 2008 11:35 am
- Location: Raleigh, NC, USA
- Contact:
Re: SoftPro Connection in Mirrored Environment
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
John Morris
Sr. Software Architect
SoftPro
Sr. Software Architect
SoftPro
Re: SoftPro Connection in Mirrored Environment
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
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