+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, SQL 2012 Migration in Technical; Having a migration issue at one of my schools, runs CC4.3 on a Server 2008 R2 setup. SQL 2012 won't ...
  1. #1

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,945
    Thank Post
    583
    Thanked 1,017 Times in 783 Posts
    Blog Entries
    15
    Rep Power
    464

    SQL 2012 Migration

    Having a migration issue at one of my schools, runs CC4.3 on a Server 2008 R2 setup.

    SQL 2012 won't install, therefore the migration process from SQL2008R2 fails.
    The error I'm getting is:

    TITLE: SQL Server Setup failure.
    ------------------------------

    SQL Server Setup has encountered the following error:

    '.', hexadecimal value 0x00, is an invalid character. Line 1, position 51622.

    Error code 0x84B10001.

    For help, click: http://go.microsoft.com/fwlink?LinkI...25400x5539C151

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


    ****

    All the googling I can find says "Uninstall MSDE" (SQL Express 2000). There's no such thing, and I don't want to go uninstalling the original SQL server for obvious reasons. This is whether I go through Capita's migration process or straight to SQL Server 2012 Express installer. It extracts files, the first page loads (Installation Center) then clicking on "New SQL Server stand-alone installation" gives us a popup with the above failure.

    Anyone come across this? I've disabled everything I could think of that may have caused issues like the RM auditor databases etc.

  2. #2

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,945
    Thank Post
    583
    Thanked 1,017 Times in 783 Posts
    Blog Entries
    15
    Rep Power
    464
    Right, this can be disregarded. It was indeed an MSDE instance!

    So for those of you with a CC3/CC4 server which is also your SIMS/SQL server, you'll find your RMAUDPRINTERCREDITS database thingy is the cause. Uninstall from control panel (its under the RM Printer Credits Database) and bob's your uncle. If you use printer credits, find a working solution instead!

  3. #3

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,139
    Thank Post
    403
    Thanked 622 Times in 568 Posts
    Rep Power
    181
    Probably a stupid question but... can I run SQL2008 and SQL2012 side by side on the same server?

  4. #4

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,945
    Thank Post
    583
    Thanked 1,017 Times in 783 Posts
    Blog Entries
    15
    Rep Power
    464
    Yes you can

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SQL 2012 Migration Tools Now Avaiable!
    By Rawns in forum MIS Systems
    Replies: 27
    Last Post: 19th February 2014, 08:00 AM
  2. [SIMS] Migrated to SQL 2012 - Tons of password resets!
    By adamf in forum MIS Systems
    Replies: 12
    Last Post: 17th February 2014, 06:00 PM
  3. SIMS/SQL Server 2012 Migration
    By Bob_the_Goon in forum MIS Systems
    Replies: 7
    Last Post: 3rd February 2014, 04:43 PM
  4. SQL 2012 Migration
    By kennysarmy in forum MIS Systems
    Replies: 10
    Last Post: 2nd December 2013, 07:09 AM
  5. [SIMS] SQL 2012 Migration Planning Advice - Posted on SupportNet
    By Rawns in forum MIS Systems
    Replies: 10
    Last Post: 22nd October 2013, 02:07 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •