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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ... ERROR: Could not connect to database specified in connectionString for SqlDataProvider ERROR: Could not connect to database specified in connectionString for SqlDataProvider
Previous
 
Next
New Post
4/29/2008 6:51 PM
 

Hi all,

I have made a clean install of dnn482 but u after review the install man and many time I still unable to access the portal .

Jus to clarify , I have a new WinXP install on a virtual machine and it is just running a SQL express 2005  and VS 2005. The setup was made based on the guide contained on Michel's forum and I am definetly dure that every step has been followed to complete the setup. And I still geting the   ERROR: Could not connect to database specified in connectionString for SqlDataProvider . I ve tried almost everything and I not sure of what to do  as every configuration has been set .

So please if anyone got any suggestion get in touch I am really interested in see how dnn works but I geting frustated to the point ton giveup .

Here are the conn strings that I am using:

    <add name="SiteSqlServer" connectionString="Data Source=CARLOS-7F3D89A6\SQLEXPRESS;Integrated Security=True;User Instance=True;AttachDBFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dotnetnuke482.mdf;uid=dotnuke;pwd=password" providerName="System.Data.SqlClient" />

    <add key="SiteSqlServer" value="Data Source=CARLOS-7F3D89A6\SQLEXPRESS;Integrated Security=True;User Instance=True;AttachDBFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dotnetnuke482.mdf;uid=dotnuke;pwd=password" />

And the SQL sever has been set as it should .At least as far as I know and as far as the guide lines on the intall tutorial is demonstrating.

Thanks in advance.

 
New Post
5/1/2008 12:01 AM
 

Are you able to connect to the database using SQL Express Management Studio?

If so, be sure to disconnect before trying to load the site, Express won't allow you to connect with the site and management studio at the same time, from my experiences.


Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
5/1/2008 10:23 PM
 

And if you disconnect the db from SQL Studio Management Express, be sure to check the permissions on the files residing in your app data folder (both the db and log files) as from my experience this disconnect will reset permissions on these files and you will have to go back in and add the Network Service permissions again.

Paul

 
New Post
5/8/2008 7:23 PM
 

Hi Chris ,

 

Thaks for your reply .

I ve tryied your suggestions but no success.

I also am  able to connect the database through the sql management studio  and checked all permissions in the app data folder and the network services has full control in both dabtabase and log files.

Thanks again ,

 

Carlos

 
New Post
5/8/2008 7:25 PM
 

Hi Paul,

 

Thaks for your reply .

I ve the suggestions but no success.

I also am  able to connect the database through the sql management studio  and checked all permissions in the app data folder ...the network services has full control in both dabtabase and log files and have not been reset.

Thanks again ,

 

Carlos

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ... ERROR: Could not connect to database specified in connectionString for SqlDataProvider ERROR: 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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out