Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Jonas Eriksson 930 posts 1825 karma points
    Feb 14, 2010 @ 18:02
    Jonas Eriksson
    0

    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()

  • Stephan Lonntorp 195 posts 212 karma points
    Feb 14, 2010 @ 18:38
    Stephan Lonntorp
    0

    Are you sure you have exported your data correctly?

  • Jonas Eriksson 930 posts 1825 karma points
    Feb 14, 2010 @ 19:43
    Jonas Eriksson
    0

    It was just a backup/restore. I'll try again.

    Regards/ Jonas

  • Jonas Eriksson 930 posts 1825 karma points
    Feb 27, 2010 @ 22:33
    Jonas Eriksson
    0

    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.

  • jaygreasley 416 posts 403 karma points
    Mar 09, 2010 @ 11:29
    jaygreasley
    0

    Did you drop and recreate the Umbraco database user?

  • Jonas Eriksson 930 posts 1825 karma points
    Mar 10, 2010 @ 12:24
    Jonas Eriksson
    0

    Yeah, think so, but I'll give it another try, thanks.

Please Sign in or register to post replies

Write your reply to:

Draft