Adding another entry to get to second page...

What do you mean by this - 'I tried changing the column name'.  If you have control...

Make sure you are in the correct database - put a USE statement and a GO before the CREATE VIEW:

USE {your database here};
GO

CREATE VIEW ...
...
GO

And - please...

Unless I am missing something - you are not going to be successful using SQL Server Express Edition.  It looks like the original application was using SQL Server Express LocalDB.

Start...

It sounds like you are installing a named instance on the server - and not a default instance.  Named instances do not use the default port unless they are configured...

It isn't SQL that is the problem - it would be network latency between sites causing the issues or maybe the routing on the network.  SQL Server receives the request,...

What is the current OS on the server(s) - and was that performed as an in-place upgrade also?  The minimum OS to support SQL Server 2019 is Windows Server 2016. ...

It also looks like you are not performing regular frequent transaction log backups.  In SQL Server - when the database is not in simple recovery model, you must take frequent...

I would take the time to reinstall/reconfigure the workstations - using a CNAME alias instead of the actual server name.  In the future when you have to perform another upgrade...

That is very interesting - learn something new every day.  Thanks for the update.

Is this part of an availability group?

So you changed it from Azure to an Azure Managed Instance - and no, it isn't currently possible to setup an AG with an on-prem instance and an Azure Managed...

Another option is to use SSRS instead of SSIS - which then gives the end users a portal where they can access the 'report' and export it whenever and however...

It should be possible - I think it depends on the version and maybe edition.  How much effort is involved in setting it up may have changed with SQL Server...

Since the installation now includes enabling that feature - and when checked it places the per-service SID in the appropriate local policy, I am not sure why there is any...