Error reported when creating a new SQL Server Reporting Service database

Question

I'm using the SSMS Configuration Tool to create a new ReportServer database. The database is a SQL Server Managed Instance in Azure. In the SQL Managed Instance version is: "Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 18 2023 08:44:24"

When I run the Change Database function in the Configuration utility, I get a success on Verifying database sku and Generating database script but I receive this pretty much useless error on the Running database script. Can anyone shed light on what the issue is?

System.Data.SqlClient.SqlException (0x80131904): This ALTER DATABASE statement is not supported. Correct the syntax and execute the statement again.
ALTER DATABASE statement failed.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper)
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
   at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
ClientConnectionId:409f1c5a-926f-4b3b-802c-f8d3ef7dfb8c
Error Number:5008,State:14,Class:16

Answer 1

Hi @JohnSebastian-3934

Based on my search, the SQL statement "ALTER DATABASE" is not supported in Azure SQL Database.

You can refer to this link for information on how to migrate the report server database from an existing SSRS instance to Azure SQL Managed Instance: https://techcommunity.microsoft.com/t5/azure-sql-blog/modernizing-ssrs-and-a-step-by-step-guide-to-bringing/ba-p/2483050.

If the answer is helpful, please click "Accept Answer" and upvote it. If you have any questions, please feel free to let me know.

Best regards,

Aniya