Register | Log In
Download Contact
Resources > Forums
HomeHomeGetting StartedGetting StartedInstalling DotN...Installing DotN...Database issue in "Configure Database Connection " pageDatabase issue in "Configure Database Connection " page
Previous
 
Next
New Post
6/3/2012 8:58 AM
 
User is offline Matthias Schlomann


Matthias Schlomann's Avatar

www.aarsys.de
Joined: 8/10/2003
Posts: 3101

I forgot that you used the SQL server with named instance, so the correct Connection string must be:

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

<add name="SiteSqlServer" connectionString="Server=localhost\SQLExpress;Database=myDotnetnuke;uid=mycms;pwd=dotnetnuke;" providerName="System.Data.SqlClient" />

Hope this fixed your issue, and don't forget the 2nd connection string!

Regards
Matthias
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
6/4/2012 6:13 AM
 
User is offline Reza Hosseinzadeh


Joined: 5/28/2012
Posts: 10

I did the same and changed the connection string in Web.config. 

Again filed :

Installing Database - Version 06.00.00...FAILURE ERROR: See D:\\dotnetnuke\Providers\DataProviders\SqlDataProvider\06.00.00.log.resources for more information

I even changed the appSettings in my next attempt and changed the "SiteSqlServer" key to :

<add key="SiteSqlServer" value="Data Source=localhost\SQLExpress;Initial Catalog=myDotnetnuke;User ID=mycms;Password=dotnetnuke" />

but again same error. I changed the localhost to my computer name and again same error :(

I have never felt so much miserable when installing a new software/app before this.. Digging the whole internet cannot find why this happen at all!
 
New Post
6/4/2012 6:21 AM
 
User is offline Matthias Schlomann


Matthias Schlomann's Avatar

www.aarsys.de
Joined: 8/10/2003
Posts: 3101

Had you recreate your database ?  After a failed install you have to delete trhe existing database and recreate it, about it could be that any Creation already done, and so the new install could not be run.

Please post the content of the D:\dotnetnuke\Providers\DataProviders\SqlDataProvider\06.00.00.log  file if it isn't empty.

 

Be sure the iUser have execute and read permissions and the Application pool user have full access to your DotNetNuke folder and the permissions are inherit to all files and subfolders!

 

Regards
Matthias
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
6/4/2012 7:00 AM
 
User is offline Reza Hosseinzadeh


Joined: 5/28/2012
Posts: 10
Matthias Schlomann wrote:

Had you recreate your database ?  After a failed install you have to delete trhe existing database and recreate it, about it could be that any Creation already done, and so the new install could not be run.

Please post the content of the D:\dotnetnuke\Providers\DataProviders\SqlDataProvider\06.00.00.log  file if it isn't empty.

Be sure the iUser have execute and read permissions and the Application pool user have full access to your DotNetNuke folder and the permissions are inherit to all files and subfolders!

 I do create new database every time it fails and assign the user with db_owner to that.

The error log does not even created on the path that has been shown!

I have given modify access to IIS AppPool\DefaultAppPool on my dotnetnuke folder as it was shown in installation video. I also did add IUSR and gave all the permission you told. 

Still same problem and it shows the above error. I am about to give up this..it is now 4 days I am doing this task
 
New Post
6/4/2012 7:05 AM
 
User is offline Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 36759
Please make sure, you did enable TCP/IP protocol for both, SQL Server and Client. If SQL Server is on a different machine, it needs to have remote access be enabled during install as well.
Cheers from Germany,
Sebastian Leupold (DotNetNuke MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals
 
 Page 2 of 5
Previous123...5Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DotN...Installing DotN...Database issue in "Configure Database Connection " pageDatabase issue in "Configure Database Connection " page


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Start Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP