Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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 ...Version: 04.03.04 ERROR: Could not connect to database specified in connectionString for SqlDataProvVersion: 04.03.04 ERROR: Could not connect to database specified in connectionString for SqlDataProv
Previous
 
Next
New Post
9/14/2006 2:46 PM
 

Hello everybody,

I'm in the process of installing my first 4.03.04 DNN site (i have a 3.x version running without a problem). I'm fallowing the install manual but can't seem to get this new version to start. What i have doen:

1) unziped the install files and copied them to a directory on the web/sql server

   a) server = 192.168.10.10

2) set the NTFS security on the directory and gave the "Network service" user full controle

3) created a database and created a local SQL user giving this user owen rights on the DB

   a) db = ittalks

   b) user= ittalks  | pw= password (*this is not the actual pw ofcourse)

4) Created the virtula directory

   a) dir name= ittalks

   b) installed dotnet2.0 | created seporate appl pool | enabled .net 2.0 on the virtual directory

5) edited the web.config file and added the SQL string in 2 locations

 

  <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=192.168.10.10;Database=ittalks;uid=ittalks;pwd=password;"
      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=192.168.10.10;Database=ittalks;uid=ittalks;pwd=password;"/>
    -->
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false"/>
    <add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
    <add key="RemoveAngleBrackets" value="false" />
    <!--optionally strip angle brackets on public login and registration screens-->
  </appSettings>

 

Now the manual tells me i should be able to access http://192.168.10.10/ittalks but when i try to do this i'm prompted with the fallowing error

Error Installing DotNetNuke

Current Assembly Version: 04.03.04

ERROR: Could not connect to database specified in connectionString for

I have created an ODBC DSN to check and can confirm the DB is there and my "ittalks" user had access to the db but for some reason the site is still not working.

Can anybody help me?

Thanks,

Tom Decaluwé

 
New Post
9/14/2006 7:20 PM
 

In your web.config file note that the connection strings that you have set up for SQL Server 2000/2005 are the ones that are commented out and hence are not being used.  Instead, the original settings for SQL Server 2005 Express are the active ones causing the database connection to fail.  Should be:

<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=192.168.10.10;Database=ittalks;uid=ittalks;pwd=password;"
      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=192.168.10.10;Database=ittalks;uid=ittalks;pwd=password;"/>
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false"/>
    <add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
    <add key="RemoveAngleBrackets" value="false" />
    <!--optionally strip angle brackets on public login and registration screens-->
  </appSettings>

Note how I have rearranged the ending comment marks (-->)


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
9/15/2006 4:54 AM
 

Thanks, it's working now!

Tom

 
New Post
10/20/2006 8:57 AM
 

Was the fact that the connection string for SQL server was commented out?  If it was not, then it might be nice to include that little tidbit of information.

 

- Michael

 
New Post
10/20/2006 1:09 PM
 

could u please help me  cant figure this out tried everything i have read over and over

the only thing i have changed were the xxx in the config string for user id and pass word etc. this is the info of my server dont know what to use  i have the same error he had

Domain Name: thondor.com
Server IP Address: 208.109.78.8

Database Name thondor
Host Name mysql211.secureserver.net
DSN Name Information
DSN Name mysql_thondor.dsn

ID User Host Database Command Time Status SQL query
Kill 14827487 thondor ip-208-109-14-26.ip.secureserver.net:37641 None Query 0 --- SHOW PROCESSLIST

 

This is what i have put in for  server=  database=  uid=  pwd=

is there more i have to change?

 

<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=208.109.78.8;Database=thondor;uid=thondor;pwd=XXXXX;"
      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=208.109.78.8;Database=thondor;uid=thondor;pwd=XXXXXX;"/>

 

What did i do wrong?

Thanx?

 

 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Version: 04.03.04 ERROR: Could not connect to database specified in connectionString for SqlDataProvVersion: 04.03.04 ERROR: Could not connect to database specified in connectionString for SqlDataProv


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out