I am having problems installing DNN 623 on IIS 7.5 and SQL Server 2008. I have downloaded the Install package, extracted the files, manually configured an IIS Application and database, set Modifiy/Write ACL permissions for the AppPool identity to the whole web folder, created a SQL Login with dbo role membership in the database and updated the connection string settings in web.config.

The DNN Installation Wizard starts up correctly, approves the file permissions and connection string details, and starts running the database scripts. Then it fails, displaying the error:

Installing Database - Version 06.00.00...FAILURE ERROR: See C:\inetpub\wwwroot\dnn623\Providers\DataProviders\SqlDataProvider\06.00.00.log.resources for more information

The log file in question does not exists so I can't get futher information. No errors in the windows event log relating to this.

I have had the same problem with all versions of DNN6 that I have tried to install on this machine. I have previously installed and configured scores of DNN5 webs without any problems.

Can anyone help me with this please?

Thanks Mattias, but have found the answer in this thread: http://www.dotnetnuke.com/Resources/Forums/forumid/107/postid/468877/scope/posts.aspx#468877.

To save a very long read, you have to set the SERVER collation to Latin1_General_CI_AS or various stored procedures will not run in. My server collation was set differently for some other projects with different requirements. Created a SQL Express instance for the DNN installation with that collation, and it works fine.

IMO this needs to be fixed, it took a lot of time to get to the cause of the error.