I am having some trouble connecting to my database in SQL 2008 R2 Express to activate a site on my local machine. I have done this several times in the past, but I am having issues on this new computer.
The files have been downloaded, the database backed up, downloaded, then restored in SQL 2008 R2 Express with the login user added. However, I am not able to restore the website locally.
I was able to create a new instance of DNN, but I cannot connect the older instance to the database that I have restored. I did add the portal alias "localhost" to the database. Gave DefaultAppPool full permissions to the folder. Changed my web.config file to...
<add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=mydatabase;User ID=myuser;Password=mypassword" providerName="System.Data.SqlClient" />
It seems as though the IIS is not configured correctly. The DefaultAppPool has been selected in IIS 7.5.
Then I got a machine key error. I have tried with WebMatrix and without it. Here is the error below.
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
Line 99: </system.webServer>Line 100: <system.web>Line 101: <machineKey validationKey="F96644F22F506793CDA1101F8D81B887F338825B" decryptionKey="9BA9D4FC3F355F3EFD902F17B2B91355EF0094AA48FE4715" decryption="3DES" validation="SHA1" />Line 102: <!-- HttpModules for Common Functionality -->Line 103: <httpModules>
Source File: C:\inetpub\wwwroot\maranata\web.config Line: 101
Show Additional Configuration Errors:
Microsoft .NET Framework Version:2.0.50727.5456; ASP.NET Version:2.0.50727.5456
Any help would be appreciated!