ASP.NET MVC app cannot connect to Azure SQL

Question

I have created a database in Azure SQL. I have updated firewall so that my local machine and dev server can hit the database. I have tested on both machines using the credentials using SQL Server Enterprise Manager all connects fine.

When I use the same server details and credentials in my web.config, it cannot connect - I get this error:

A connection string is configured but Umbraco cannot connect to the database

The website is an umbraco cms website.

I have tried recreating the database, and also deleting reading the login and user still no joy.

can we see your connection string? please hide sensitive info :) — ChizT
– ChizT, Commented Mar 13, 2019 at 11:54
<add name="umbracoDbDSN" connectionString="server=xxx.database.windows.net;database=xxx;user id=xxx;password=xxx;MultipleActiveResultSets=true;" providerName="System.Data.SqlClient" /> — Ismail
– Ismail, Commented Mar 13, 2019 at 12:09

ChizT · Accepted Answer · 2019-03-13 12:16:19Z

0

<add name="umbracoDbDSN" providerName="System.Data.SqlClient" connectionString="data source={dbServer};initial catalog={databaseName};persist security info=True;user id={userID};password={userPassword};MultipleActiveResultSets=True;" />

please try this just change {} to your configuration

answered Mar 13, 2019 at 12:16

ChizT

7273 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ismail Over a year ago

ok mystery solved epic fail on my part in the db name i had - changed it to _ not it works. i am guessing ranton187 your suggestion would have also fixed this

Collectives™ on Stack Overflow

ASP.NET MVC app cannot connect to Azure SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related