Replace HA database connection string for a RDS deployment

Rap One 0 Reputation points
2025-01-20T08:33:48.75+00:00

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?

Windows for business | Windows Client for IT Pros | User experience | Remote desktop services and terminal services
0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.