""Error Installing DotNetNuke

First of all, clear your head and forget every thing you've done in the past 3 months!!

Also it is best if you delete any previous attempts of installing, and delete the database!

Then :

• Create a database with the name DotNetNuke
• Create a user and assing "owner" privileges
• Go to your iis and create a virtual directory ponting to your folder with DotNetnuke files ( you can set the alias as "DotNetNuke"
• Go to your DotNetNuke Folder and in the properties / Sharing &Security add the user ASPNET with ful control
• Rename the release.config file to web.config
• Change the connection strings for your server ( the right ones are comment out)

         <connectionStrings>
                    <!-- Connection String for SQL Server 2000/2005 -->
                    <add name="SiteSqlServer" connectionString="Server=SERVERNAME;Database=DotNetNuke;uid=User;pwd=Password;" providerName="System.Data.SqlClient"/>
 </connectionStrings>

and

<appSettings>
              <!-- Connection String for SQL Server 2000/2005  -->  <add key="SiteSqlServer" value="Server=SERVERNAME;Database=DotNetNuke;uid=User;pwd=Password;"/>

• Then do something like --> htt://localhost/dotnetnuke

Still having problems , say something!

Hi Wolf

I am haveing the same problem as the gentleman above. Kept looking back to see if what he did helped but I guess he gave up or did not appreciate your help.

This is the error message i keep getting:

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

AND

DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.Login failed for user 'UserName'. The user is not associated with a trusted SQL Server connection.

I have been useing DNN for two years now and have installed several versions on my developement machine here and have two sites working on the web.

I followed what you suggested above and still get same Error Message. I have check spelling, permission, security, etc. on ASP.Net and users. Still same Error Message.

It seems there is a common denominator that i am missing because the Error Message keeps refering to not being able to find the SQL Server. I have tried both SQL Server 2000 and SQL Express 2005.

Here are the following excerpts from the Web Config. Could you look them over and make any suggestions. Would appreciate it.

<appSettings>
  <add key="SiteSqlServer" value="Server=(sqlexpress);Database=dotnetnuke;uid=UserName;pwd=Password;"/>
  <add key="MachineValidationKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902" />
  <add key="MachineDecryptionKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902F8D923AC" />
  <add key="MachineValidationMode" value="SHA1" />
  <add key="InstallTemplate" value="DotNetNuke.install.resources" />
  <add key="AutoUpgrade" value="true" />
  <add key="UseDnnConfig" value="true" />
  <add key="InstallMemberRole" value="true"/><!--optionally install the MemberRole scripts -->
  <add key="ShowMissingKeys" value="false" /><!-- Show missing translation keys (for development use) -->
  <add key="EnableWebFarmSupport" value="false" /><!--Set to true to enable web farm suppot.  See Web Farm Support documentation for additional configuration steps.-->
  <add key="EnableCachePersistence" value="false" /><!--Some cached items can persist an app recycle by serializing the object to disk. Set to "true" to enable this performance enhancement.-->
 </appSettings>

<data defaultProvider="SqlDataProvider">
   <providers>
    <clear />
    <add name="SqlDataProvider"
     type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
     connectionStringName="SiteSqlServer"
     upgradeConnectionString=""
     providerPath="~\Providers\DataProviders\SqlDataProvider\"
     objectQualifier="dotnetnuke"
     databaseOwner="UserName"/>
   </providers>
  </data>

My Development machine that I am useing has the following installed:

Windows XP Pro
SQL Server 2000
SQL Express
Framework 2.0
IIS 5.1

Any help would be appreciated

Thank you

Lowell Curtis

lecurtis@direcway.com