Matti;
Please re-check the permissions into your Production SQL server. Your IIS account from the web site and your account on the web folders both need read/write/modify rights against the database

---

Ken Grierson
DotNetNuke Corporation
Test Lead

 Sebastian,  in my local pc I am using Sql-Server 2008 R2 Express, and I checked the compatibility level with the following T-SQL statement.

 sp_dbcmptlevel "DB-Name"

... which confirmed that the compatibility level is 90.

My hoster has SQL-server 2008 standard edition

Originally, I have migrated  - by myself - my DNN-sql-server database to hoster's  SQL-server  via SMSSE's copy database option
which created me an sql-script-file that I then ran against the hoster's database. In the process f creating the sql-script file I selected the
compatibility to 2008 version (=100). Maybe this way to migrate the DNN database is related to the problem ..?

Also, I noticed that with the following statement in SSMSE

DBCC TRACEON (3604);
GO
DBCC DBINFO('DB_NAME')
GO

.. I can find out that the the version number of the Database is differing between the R2 (=661) and SQL-server 2008 (=651).
When, for the purpose of testing I asked my hoster to attach my local R2 DNN-database to their SQL server 2008, they informed me
that they could not attach the database to SQL-server 2008 because of an version error.

Does this info illumine the issue any better for you?

Matti