I am migrating an Umbraco setup (Version 7.12.3) from my local machine to Azure.
I copied all of the deployed files from my local site, updated the connection string in the web.config, and duplicated my Umbraco DB from my local SQL server (SQLSERVER2014) to the SQL server on Azure.
The site compiles, but remains on the install screen. When I check the logs, I see the following errors:
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoMigration
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser'.
It seems that Umbraco can access the DB (otherwise I would be getting a different error), but can't access the SQL tables.
On both my local DB and Azure, the table Schemas are set to "dbo". The SQL login that I am using also has "dbo" as the default schema.
Is my Azure SQL DB incorrectly configured? Am I missing a .config property or setting?
I would really appreciate help from any of the Umbraco gurus our there. This is my first venture into Umbraco, but I'm liking it so far, but as with all new things, sometimes the simplest things can be the most difficult and frustrating the first time around.
Are you using SQL Authentication? Make sure that that user can access the tables.. from your local SSMS, you should be able to connect to the database (depending on firewall rules) and log in as that user to verify the permissions are setup correctly.
Migrating from Local to Azure - Azure SQL Issues
I am migrating an Umbraco setup (Version 7.12.3) from my local machine to Azure.
I copied all of the deployed files from my local site, updated the connection string in the web.config, and duplicated my Umbraco DB from my local SQL server (SQLSERVER2014) to the SQL server on Azure.
The site compiles, but remains on the install screen. When I check the logs, I see the following errors: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoMigration
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser'.
It seems that Umbraco can access the DB (otherwise I would be getting a different error), but can't access the SQL tables.
On both my local DB and Azure, the table Schemas are set to "dbo". The SQL login that I am using also has "dbo" as the default schema.
Is my Azure SQL DB incorrectly configured? Am I missing a .config property or setting?
I would really appreciate help from any of the Umbraco gurus our there. This is my first venture into Umbraco, but I'm liking it so far, but as with all new things, sometimes the simplest things can be the most difficult and frustrating the first time around.
Are you using SQL Authentication? Make sure that that user can access the tables.. from your local SSMS, you should be able to connect to the database (depending on firewall rules) and log in as that user to verify the permissions are setup correctly.
Thanks for the reply, John. Your questions helped guide me towards a solution.
is working on a reply...