SQL 2005 database mirroring connection string
Posted on 2006-07-05
I have been doing a bit of research trying to find out how a connection string works for a SQL 2005 instance which is setup with database mirroring.
i am very familiar with microsoft clustering and there being a VIP.
in database mirroring there appears to be no VIP.
i have 3 nodes, a primary a mirror and a witness.
using microsoft sharepoint how would i modify the string and where to connect to a database mirror?
my guess is the web.config file but i cannot find a location.
any suggestions are much appreciated since i have not seen this question answered before it may be very usefull for future references, thanks team!