I wanted to change our database's location from running locally on the SQLExpress server to Azure's SQL server.
The steps I followed were the following:
Since the CMS DB has a user that is needed, I created the credentials on the Azure DB using the following queries
-- Create SQL Login template for Azure SQL Database and Azure SQL Data Warehouse Database
CREATE LOGIN <Username>
WITH PASSWORD = 'StrongPassword'
-- Create User as DBO template for Azure SQL Database and Azure SQL Data Warehouse Database
-- For login <login_name, sysname, login_name>, create a user in the database
CREATE USER <user_name>
FOR LOGIN <login_name>
WITH DEFAULT_SCHEMA = <dbo>
The issue that I am having is that when I try to go to the admin portal -> pages and select one of my pages, it gives me "Exception of type 'System.Web.HttpUnhandledException' was thrown." error, and when I try to navigate to the selected page through the browser, I get an "Invalid Object Name" exception.
The invalid object name is my page name, I checked the DB table data on Azure's SQL server and the data is there. I don't know if there is an extra step that I should do or if it is not seeing the data due to some permissions issue.
Can someone help shed some light on this?
Does your db user have db owner privilege?
yes, I changed that to dbo instead of db_owner and it worked.
Please, sign in to be able to submit a new answer.