I have created a virtual directory for my DNN site and extracted the entire package to the DNN folder. I then created a database in SQL Server 2000 with the name “DotNetNuke” and created a user named DNN_user, with full permissions, under the permissions tab.
I then edited my web.config file to have the following details:
<!-- Connection String for SQL Server 2000/2005 -->
<add
name="SiteSqlServer"
connectionString="Server=Fred;Database=DotNetNuke;uid=DNN_user;pwd=****;"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules-->
<addkey="SiteSqlServer"value="Server=Fred;Database=DotNetNuke;uid=DNN_user;pwd=****;"/>
Upon loading the page, I get the following error:
Error Installing DotNetNuke
Current Assembly Version: 04.04.01
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
This particularly puzzles me because we had an installation of the ibuyspy portal from several year ago, and I confirmed that the connection string coding was similar (different DB, but same server).
Any suggestions people could provide would be immensely appreciated! The .NET version for the virtual site is set to 2.0, in case you were wondering.
Josi.