Move on-premise RDS Database to another SQL server

PavelIT 1 Reputation point
2021-10-24T11:22:33.057+00:00

Hello, I am trying to move our on-premise RDS solution to newer server. We are using the HA connection broker with SQL connection.
I have migrated the RDS database to new SQL server already, but I do not know how to change the connection string.

I am using following command

Set-RDConnectionBrokerHighAvailability -ConnectionBroker rdcbserver -DatabaseConnectionString "DRIVER={ODBC Driver 17 for SQL Server};SERVER=rdsqlserver,1433;DATABASE=RDSCB;APP=Remote Desktop Services Connection Broker;Trusted_Connection=Yes;"

But I am getting following error

Set-RDConnectionBrokerHighAvailability : The -DatabaseFilePath parameter is mandatory for RD Connection Broker server rdcbserver that is not running Windows 2016 or later OS version.

We are currently running all on Windows Server 2019

Pavel

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
4,244 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PavelIT 1 Reputation point
    2021-10-24T12:16:23.65+00:00

    Just to add. Even if I add -databasepath parametr with the path to file, I get following

    Set-RDConnectionBrokerHighAvailability : The specified path C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\RDSDB.mdf for -DatabaseFilePath parameter should contain the SQL Server database file.

    Pavel

    0 comments