I have the same problem. I just went to restore my local copy and got the db connection error discussed above.

DNN Error

Connection To The Database Failed

I have deleted and recreated my user with no luck. I even tried using the SA credentials and am still not able to connect the site to the database.

Anything else I should be trying?

Thanks.

JoAnn

also, I created a stand alone page on the dnn site with only this in the page_load

try
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SiteSqlServer"].ConnectionString);
}

catch (Exception ex)
{
Response.Write(ex);
Response.End();
}
and I still get the generic

DNN Error

Connection To The Database Failed

No idea where to go with this. Any help would be much appreciated.

JoAnn