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.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies