question

PavelIT-8420 avatar image
0 Votes"
PavelIT-8420 asked PavelIT-8420 answered

Move on-premise RDS Database to another SQL server

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-generalremote-desktop-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PavelIT-8420 avatar image
0 Votes"
PavelIT-8420 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.