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 DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...ERROR: Could not connect to database specified in connectionString for SqlDataProviderERROR: Could not connect to database specified in connectionString for SqlDataProvider
Previous
 
Next
New Post
6/20/2006 11:57 AM
 
panza panza

Joined: 1/23/2004
Posts: 17

Trying to use vs2005 dnn4.3.0 starterkit

or dnninstall.zip,

And same error :

Error Installing DotNetNuke
Current Assembly Version: 04.03.00
ERROR: Could not connect to database specified in connectionString for SqlDataProvider

 

My rights are ok for aspnet and network services.
It s a sqlexpress mdb

 

Thanks
 
New Post
6/21/2006 8:58 AM
 
Baronne Mouton

Joined: 6/16/2006
Posts: 9

Hi,

I am experiencing the exact same error. I successfully installed DNN 4.3 the other day, but noticed there were no tables in my SQL database. It turned out that the data files were actually coming from some files in the DNN folder call "App_Data". I'm also using SQL Express 2005. Previously - when it worked - I had the following settings in my web.config - but this of course creates the files in the "App_Data" folder:

<connectionStrings>

<!-- Connection String for SQL Server 2005 Express -->

<add

name="SiteSqlServer"

connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"

providerName="System.Data.SqlClient" />

<!-- Connection String for SQL Server 2000/2005 -->

<!--<add

name="SiteSqlServer"

connectionString="Server=(local);Database=dotnetnuke;uid=dba;pwd=dbapass;"

providerName="System.Data.SqlClient" />-->

</connectionStrings>

<appSettings>

<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->

<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>

<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->

<!--<add key="SiteSqlServer" value="Server=(local);Database=dotnetnuke;uid=dba;pwd=dbapass;"/>-->
 
New Post
12/8/2006 8:31 AM
 
Mark Ham

www.menlosoftware.net
Joined: 10/3/2005
Posts: 5
I am using SQL SVR 2005 and the thing that finally made it connect is that after setting up a user and password I went under the properties of my user and checked the "db_owner" box under "Database role membership". So the error in my case was not very descriptive.
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...ERROR: Could not connect to database specified in connectionString for SqlDataProviderERROR: Could not connect to database specified in connectionString for SqlDataProvider


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.