Hi

I've been trying to install DNN for 4 days now and it's seriously doing my nut.

I've followed the How to Install DotNetNuke to Windows XP Home (Using VWD) video guide exactly and get as far as initiating the installation.

Then I get this error:

Error Installing DotNetNuke

Current Assembly Version: 04.09.00

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

I have read that I need to change the connectionString in the Web Config file to somthing like: value="Server=(local);Database=DotNetNuke;uid=**MYSERNAME**;pwd=**MYPASSWORD**;

I've tried this and it's telling me that the Username is't valid, how do I set the user name?

Thanks

If you are installing locally you should not need to change the connection string because it is already set to connect to a SQL Server Express database that is inside your dnn installation folders. You only need to change it if you are connecting to a SQL Server 2005.

Did you setup SQL Server Express when you installed it to use both windows authentication and SQL Server authentication?

If you are installing a new version of DotNetNuke and if it is at least 4.8.0 or higher, DotNetNuke includes an installation Wizard. If you delete any web.config file in the directory, then the Wizard should start when you browse to the site.

The Wizard will test your file permissions and help you configure you database connection strings. Just follow the prompts, and make sure that you try the test at every stage that includes one.

Hi

Thanks for your relpy Lee, I did select Mixed and added a password, I've reinstalled SQL Server Express 2005 again just to be extra sure.

This time I get a different error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

jncraig, thanks for your reply too, I've just tried deleting the Web.config file and VWD gives me a build error and gives me this:

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30451: Name 'Config' is not declared.

Source Error:

Line 66: Private Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
Line 67:
Line 68: If Config.GetSetting("ServerName") = "" Then
Line 69: ServerName = Server.MachineName
Line 70: Else


Source File: C:\DotNetDukeSites\Unhappy3\App_Code\Global.asax.vb Line: 68

Do you think I should uninstall VWD 2008 and start again?

Hello,

I would create a fresh folder and copy the DNN installation files into there (the files from a fresh download of the install package), don't make any changes to the web.config or delete it.

Just follow the steps through exactly as the video without using anyone else's written instructions.

See if it goes through, if you get an error when installing DNN, you are best starting again with new files, especially if you have been tweaking the web.config etc.

Hi,

This morning I've downloaded a fresh DotNetNuke_04.09.00_Install.zip and extracted this to a new folder on my C drive.

The install builds with no error, opens the installation wisard. I select Auto, click Next and again it gives me:

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

I have noticed that there is a broken image above this message that hasn't loaded properly:
http://localhost:1225/DNNTEST1/Install/logo.gif

Should this display normally or is it a symptom of a wider problem ?

Cheers

Are you running this as a normal website, or are you running this inside of Visual Studio? I'd recommend running it outside of Visual Studio.

Did you create an empty database in your SQL server? You must also attach a login name and password to this database. The login name must also be able to access the database as the database owner (dbo).

Did the Wizard start when the site loaded? I really do recommend that you use the Wizard, and that you use the test buttons at every stage.

Hi Joe

I'm following everything as the guide suggests:

Launch Visual Studio
Open New Site
Debug - Start Without Debugging

The Wizard only gets as far as the 1st page, were you can pick Custom, Typical or Auto.

I pick Auto and get the Error:
Could not connect to database specified in connectionString for SqlDataProvider

I never get to the part with the test buttons.


I haven't created an empty database or attached a login name & password as nothing in the guide mentions doing this.
How do I do this? I'll give it a try

Thanks

ah yes, because you are installing to XP home you have to go through visual studio and use the auto method - you can not use the wizard method as it will not complete on windows home XP so you wont be able to use the test buttons.

Did you install SQL Server Express 2005 rather than 2008?

There must be some configuration problem with SQL Server itself as it should just be able to connect to the database that is already created in the DNN installation files for you - the settings in the web.config automatically are set to connect to this database, so you should not have to create a database or make any changes to the web.config.

Hi

Yes, I'm using SQL Server Express 2005, what would you suggest I do if it is a configuaration problem?

Should I try SQL Server Express 2008?

Hi again,

I'm still getting absolutely nowhere with this, could anybody suggest any other ways to set this DNN on XP Home?

Any ideas would be very much appreciated.

Cheers

You will need to create an empty database, and give it appropriate login name and password. Your SQL server should be configured for mixed authentication. Your login name must have dbo privileges for the database.

You will also need to edit the two connection strings in your web.config file to be able to open the database.

ok I'm back from OpenForce, have you solved the problem?

Because you are having these problems, I would try exactly as Joe suggests with creating a new database and username and editing the web.config file.


But - It should work without doing this however, so, the first thing I would check is the settings on SQL Server Express and that they are set to 'SQL Server and Windows Authentication' mode not just 'Windows Authentication' check this post for further info:

SQL Server Authentication