SQL helper exception after moving to SQL Server 2008 Express
Hi!
I'm quite stuck at this. I copied the Umbraco db from SQL Server 2000 to a SQL Server 2008 Express, but after that the site wont run. I get Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader. I even run in SQL 2000 compatibility mode to minimize problems. Any idea how I can fix this? (I had several problems with packages sql scripts not working in Sql 2000, that's why I liked to change).
Regards
/Jonas
Exception information:
Exception type: SqlHelperException
Exception message: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
Thread information:
Thread ID: 8
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at umbraco.BusinessLogic.User.setupUser(Int32 ID)
at umbraco.BusinessLogic.User..ctor(Int32 ID)
at umbraco.BusinessLogic.User.GetUser(Int32 id)
at umbraco.BusinessLogic.User.GetCurrent()
at umbraco.BasePages.UmbracoEnsuredPage.get_CurrentUser()
SQL helper exception after moving to SQL Server 2008 Express
Hi!
I'm quite stuck at this. I copied the Umbraco db from SQL Server 2000 to a SQL Server 2008 Express, but after that the site wont run. I get Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader. I even run in SQL 2000 compatibility mode to minimize problems. Any idea how I can fix this? (I had several problems with packages sql scripts not working in Sql 2000, that's why I liked to change).
Regards
/Jonas
Exception information:
Exception type: SqlHelperException
Exception message: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
Thread information:
Thread ID: 8
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at umbraco.BusinessLogic.User.setupUser(Int32 ID)
at umbraco.BusinessLogic.User..ctor(Int32 ID)
at umbraco.BusinessLogic.User.GetUser(Int32 id)
at umbraco.BusinessLogic.User.GetCurrent()
at umbraco.BasePages.UmbracoEnsuredPage.get_CurrentUser()
Are you sure you have exported your data correctly?
It was just a backup/restore. I'll try again.
Regards/ Jonas
Still have this issue, and other issues running SQL 2000. I'm going for a complete remake of the installation with a new Umb 4.0.3 + sql 2008.
Did you drop and recreate the Umbraco database user?
Yeah, think so, but I'll give it another try, thanks.
is working on a reply...