TeamCity Two Masters connecting to single SQLServer instance

Hello All,

I have tried connecting two teamcity masters to a single sqlserver 2016 db, though i was able to connect both masters to a single db instance however for the 2nd tc master teamcity initialized seperate set of tables for the same instance?? i did sync up server side data as well for the both instances.

what i want to do it this

1. have tow seperate (windows" servers called master1 and master2.

2. create one sqlserver db.

3. initialize master1 and master 2 to single sqlserver db to the same set of tables .

4 keep master 1 and master 2 server side data in sync ( this is done via windows clustering)

now it doesnt matter weather master 1 is active or master 2 is active, they both see same data, is it doable? if yes how?

i am stuck at a point that whenever i connrct master 2 to the database it creates seperate sets of tables for master2 in the db rather than pointing to single set of tables.