New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the Community Exchange, where community members ask and answer questions about DNN. To get started, just start typing your question below and either select one of the suggested questions or ask a new question of your own.

Azure SQL Database question, why am I connected to two databases?

Return to previous page

  • 10/31/2016
  • 2500 Views

Question:

Alex Day 8 years ago

I was doing some cleanup of my Azure subscriptions and was going to kill one of the databases for which I am being charged. Come to find out, I am connected to two databases and both seem to be required for my site to function. Below are how they are referenced in the Web.Config file:

<!-- Connection String for SQL Server 2008/2012 Express -->
<add name="SiteSqlServer" connectionString="Data Source=qpo01e47py.database.windows.net;Initial Catalog=Sheltowee_2016-02-09T07-35Z;User ID=*********;Password=*****;Connection Timeout=600;" providerName="System.Data.SqlClient" />
<!-- Connection String for SQL Server 2008/2012
<add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" />
-->
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2008/2012 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Data Source=qpo01e47py.database.windows.net;Initial Catalog=Sheltowee;User ID=**********;Password=********" />
<!-- Connection String for SQL Server 2008/2012 - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>


Why am I connected to two databases? Any help appreciated.

Azure SQL Database question, why am I connected to two databases?

Alex Day
Alex Day 8 years ago
Add an Answer

Answers

Sign In to Participate
Or register to become a member