Specifically, the error is from the union where it is trying to convert the catalog.propertyfield which is ntext on the original SSRS 2012 db to the one in ReportServerTempDB tempcatalog.property...

• This reply was modified 3 years, 2 months ago by  jcourtjrSQL.

Also, since what its trying to do is add objects to upgrade the report server database, I tried to create the function in ssms and get the same error....

CREATE FUNCTION...

It is native. SSRS 2019 was fine before I moved the reportserver databases over.

So in other words I would only end up with 2 replicas in the end correct? The FCI on premesis and the Azure VM? (#Methodology 2 from the link) Async...

This looks like garbage. Anyone else want to take a crack at this?

Bump

Thanks Grant!

This stems from someone telling me a 1.7TB mdf is a bad idea without convincing data. There is nothing to accomplish other than figuring out what the risk is with...

How about besides performance? Are there reasons a multi TB mdf file a bad idea?

So I finally got it...

The Kerberos Configuration Manager is stupid in the fact that it will take whatever SQL server configuration manager has for the ports. In my...

Thank you, so I tried removing the spn with spn and it stated it was unable to locate account "NT Service\MSSQLServer". Now I thought that these virtual accounts could register/maintain...

Additionally if I specify the fake server name for @datasrc. It creates the linked server but when we try to browse it will error, which seems normal.