Replace HA database connection string for a RDS deployment
Hello all,
I service a RDS farm that have two RDCB - RDCB1 and RDCB2 with a HA database in the configuration Listner and two node servers NODE1 (windows 2012 r2) and NODE2(windows 2012 r2). The database is stored in a location E:\database\rdsdb.mdf
the db connection string is DRIVER=SQL Native Client 11.0;SERVER=Listner;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=rdsdb
We need to swich to a windows 2016 servers to host the db, but the new location will be Z:\database\rdsdb.mdf
I am planning to use the PS command
Set-RDDatabaseConencitonString -ConnectionBroker "RDCB1.domain" -DatabaseConnectionstring "DRIVER=SQL Native Client 11.0;SERVER=Listner_new;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=rdsdb"
where to specify the new data base location ?
Also found that the RDCB conneciton string is a part of a reg key HKLM\SYSTEM\CurrentControlSet\Service\Tssdis\Parameters as reg_sz key called DBConnString. Is it enough to modify here instead of running the command and perform a restart
I cannot find the location of the db in the reg keys can you help?