OK, I am really frustated. Playing around this for more than 2 days and still din get any result. Hope someone can help me here.

I am following the video that website has provided for installing DDN. Every thing is fine till DB stage.

here is my configuration and settings.

Windows 7 Home Premium, IIS 7.5, SQL Server 2008 R2 Express edition

I have created a database called "myDotnetnuke". Created a user called "mycms" and assign the db_owner for "myDotnetnuke" to that.

My SQL security is " SQL Server and Windows Authentication mode".

Problem:

During the installation I chose "Typical" and in "Configure Database Connection" I chose SQL Server 2005/2008 (Express file). For server name I write dot(.). For filename I write "myDotnetnuke". Uncheck the integrated security and for User ID write "mycms" and the password I have provided. Then I get the following error.

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: 2
Message:

if I write the server name as "{My Computer Name}\sqlexpress" I will get the following error.

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 15364
Message:

I even tried "Automatic" mode without having any Database created and it always Fail in creating Database. I can assure you that my DB is fine as I am using Visual Studio 2010 and creating so many web application and working with my DB without any problem.

If anyone can help me to decode these error I will really appreciate. Thanks!

Now it goes to next step but fails and it shows:

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

But there is no file as such it shows in the error!

btw my connection string in web.config is like this:

<connectionStrings>
    <!-- Connection String for SQL Server 2005/2008 Express -->
    <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Initial Catalog=myDotnetnuke;User ID=mycms;Password=dotnetnuke" providerName="System.Data.SqlClient" />
    <!-- Connection String for SQL Server 2005/2008
    <add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" />
    -->
  </connectionStrings>

Any idea now?

Thanks

 I think I had to write that I followed what William Severance told and I chose SQL Server database instead of File! Even for me it is interesting why then in Web.config SQL Express is active and SQL Server is commented!

And if you read my first post I have written that I have assigned the db_owner to my database for the user I have created.

What I did next was to create brand new Database again and assigned db_owner. This time before I go through the installation I changed the web.config and used the "SQL Server" for my connection and commented the Express one. When I ran the install page it showed me:

The Auto option has been disabled as the DotNetNuke Application cannot connect to a valid SQL Server database. You can continue to use either of the other two Wizard options and configure the Database settings at the appropriate Wizard step.

I went through the Typical option and chose "SQL Server" but same problem. It goes to next stage but shows this error again:

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

and there is no error file as such! but db has created and the installation is not completed!

Where am I doing wrong? It seems other users don't have the same problem or I cannot find the same situation in your blog.

Any help?