Deploying to Azure - Connection String cannot be null or empty
Hi - first time deploying a site and trying to get it uploaded to Azure web app.
I created a web app in Azure to upload the project to and it builds/runs fine on my local machine (ctrl-f5), however, when I hit publish and select Azure > account > select the web app I create on Azure and then hit publish I get the error: "The 'local-Web.config Connection String' argument cannot be null or empty.
Browsing for a solution I can't seem to find anything to help so hoping someone can help.
Here's the current connection string from web.config - sitting in its default spot below the closing of appSettings and I've posted the whole web.config below it
The issue seems to be because you are trying to use LocalDB - "Umbraco.sdf" on Azure.
You will need it to be a SQL (Express) DB, then you can copy that up using your preferred method (i.e. SQL scripts OR a DB transfer tool such as RedGate's SQL Compare & Data Compare).
Had the same issue but mine was a bit different the empty connection string was in an folder in app_data, some nuget backup folder which i have never seen before, but was the same thing in there was a config file with an empty connection string :(
Deploying to Azure - Connection String cannot be null or empty
Hi - first time deploying a site and trying to get it uploaded to Azure web app.
I created a web app in Azure to upload the project to and it builds/runs fine on my local machine (ctrl-f5), however, when I hit publish and select Azure > account > select the web app I create on Azure and then hit publish I get the error: "The 'local-Web.config Connection String' argument cannot be null or empty.
Browsing for a solution I can't seem to find anything to help so hoping someone can help.
Here's the current connection string from web.config - sitting in its default spot below the closing of appSettings and I've posted the whole web.config below it
Hi Sean,
The issue seems to be because you are trying to use LocalDB - "Umbraco.sdf" on Azure.
You will need it to be a SQL (Express) DB, then you can copy that up using your preferred method (i.e. SQL scripts OR a DB transfer tool such as RedGate's SQL Compare & Data Compare).
Regards
Craig
Managed to solve it - just deleted the first two lines before the connection string which had been in there from project app.
Rest works fine and uses the sdf database within web app on azure.
Glad you solved it mate!
Didn't see that blank connection string! :/
Have a good day!
Had the same issue but mine was a bit different the empty connection string was in an folder in app_data, some nuget backup folder which i have never seen before, but was the same thing in there was a config file with an empty connection string :(
is working on a reply...