DotNetNuke database problems - install

[RFH Customer: Dazamb]

Hi all,
I'm hoping someone will be able to help me here.
I'm attempting to install DNN on RFH, i've followed all instructions, and trauled through the forums to hopefully find a solution.

I can't get past the "configure database connection" stage of the installation, whether I install with or without the wizard. I've deleted and recreated the database as suggested in some threads, and manually entered the connections strings.Each time I am presented with
"Login Failed for User"

I should point out that I am a novice and have a limited understanding of scripting.

Any help you guys could offer me would be much appreciated.

Many thanks,
Daz

[Staff: Warren Ashcroft]

I assume you are providing the username/password created for the database, not your account username/password?

[RFH Customer: Dazamb]

yes that is correct, the username & pass for the database.

[Tanzy]

I have just done a test install of DNN 4.8 using the install wizard and had no problem. I suggest that you delete the database and recreate it, also delete all files and upload them again.

For the database server are you entering the Internal server name? For example ALUMINIUM . You should NOT use the external name mssql2005.xxxx.lon.periodicnetwork.com

Warren I'm just about to put together a tread about installing DNN using the wizard and manually. What is the best way to upload the images and what are the max sizes of them?

[Staff: Warren Ashcroft]

Warren I'm just about to put together a tread about installing DNN using the wizard and manually. What is the best way to upload the images and what are the max sizes of them?

You should be able to attach them to the post? Press the Manage Attachments button in the options underneath the post textarea.

[Tanzy]

OK I will try to get them wrote tomorrow, unfortunatly COD4 is calling me at the moment

[RFH Customer: Dazamb]

Thanks for the quick response guys.
I have deleted and reinstalled all the files and recreated the database, but i am still presented with the same problem. I am using the internal server name NEON in this case.
The connection string is as follows from web.config

<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<!--add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Data base.mdf;"
providerName="System.Data.SqlClient" /-->
<!-- Connection String for SQL Server 2000/2005-->
<add
name="SiteSqlServer"
connectionString="Server=NEON;Database=dotnetnuke; User=site;Password=pass;"
providerName="System.Data.SqlClient" />
</connectionStrings>

I don't know if that helps. One other observation i noticed was that my account is running mySQL as opposed to msSQL2005, would that cause a problem?

Cheers,
Daz

[RFH Reseller: spire128]

Hi

Have u changed the connection string in the App settings as well

<appSettings>
<add key="Server=NEON;Database=dotnetnuke;User=site;Password =pass;"
providerName="System.Data.SqlClient" />

just a thought.

[RFH Customer: Dazamb]

Hi, thanks for the reply guys, Spire128, I did alter the string in the app settings also.
I folowed the walk through guide posted by Tanzy to the letter, and still encountered the same problem.
Could this be because my RFH account is running mySQL and not MSSQL? or would that not make any difference?

Thanks,
Daz

[Tanzy]

YES........

The default DNN will only work with SQL Server (MSSQL). To run it with mySQL you need a mySQL database provider for DNN. It is possible, but I'm not aware of one being available. Also if using mySQL most if not all the modules available for DNN will not work. One of the reasons that I said in the walkthrough that I assume you have created a MSSQL database.

I have just checked the walkthrough, and I have stated SQL Server. However, I don't think that it is highlighted enough. I can't edit it now though. Warren, could you do me a favour and edit it to make it more pronouce that you need to have a MSSQL server database please.

Ken