Hosting Umbraco databases on an Azure Managed Instance
We have a bunch of Umbraco sites on some on prem virtual servers and we are migrating them to be hosted in Azure.
The databases are on an Azure SQL managed instance and we have different sites on different versions from 7.2.8 through to 7.15.3.
There is a big gap between 7.7.6 and 7.11.1. Anything newer than 7.11.1 we are having login issues to the sites. You login and it says login failed but if you go back to the root Umbraco folder it has actually logged on but just hasn't redirected into the CMS.
There are various errors in the logs:
Error Number:229,State:5,Class:14
The SELECT permission was denied on the object 'TABLES', database 'mssqlsystemresource', schema 'INFORMATION_SCHEMA'.
We have checked and all database permissions are the same.
The other thing that we notice is that when you try and update a users permissions you get an error saying 'failed to save user' but again in has updated but Umbraco isn't getting the message.
It's almost as if there are problems returning information from the umbracoUser table.
Has anyone else seen a similar issue when hosting in Azure?
Hosting Umbraco databases on an Azure Managed Instance
We have a bunch of Umbraco sites on some on prem virtual servers and we are migrating them to be hosted in Azure.
The databases are on an Azure SQL managed instance and we have different sites on different versions from 7.2.8 through to 7.15.3.
There is a big gap between 7.7.6 and 7.11.1. Anything newer than 7.11.1 we are having login issues to the sites. You login and it says login failed but if you go back to the root Umbraco folder it has actually logged on but just hasn't redirected into the CMS.
There are various errors in the logs:
Error Number:229,State:5,Class:14
The SELECT permission was denied on the object 'TABLES', database 'mssqlsystemresource', schema 'INFORMATION_SCHEMA'.
We have checked and all database permissions are the same.
The other thing that we notice is that when you try and update a users permissions you get an error saying 'failed to save user' but again in has updated but Umbraco isn't getting the message.
It's almost as if there are problems returning information from the umbracoUser table.
Has anyone else seen a similar issue when hosting in Azure?
is working on a reply...