+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Sims.NET - SQL 2008 upgrade to SQL 2008 R2 in Technical; Has anyone come across any problems moving from SQL 2008 to SQL 2008 R2? (I've had a search around support ...
  1. #1

    Join Date
    Jul 2007
    Location
    Nottingham
    Posts
    195
    Thank Post
    19
    Thanked 7 Times in 7 Posts
    Rep Power
    16

    Sims.NET - SQL 2008 upgrade to SQL 2008 R2

    Has anyone come across any problems moving from SQL 2008 to SQL 2008 R2? (I've had a search around support net and not found anything)

    I'm in the process of moving Sims.NET to a new server running SQL 2008 R2 and I've come across two problems:

    1. When re-attaching the DB I get warnings that some users could not be created, all the users have an apostrophe in their name which I guess causes the error but can't believe SQL can't handle this.
    2. After attaching the DB to SQL 2008 R2 (came from a SQL 2008 server) all the passwords are lost/corrupt, having a look around Edugeek I've tried running the Sims stored procedures sims.db_p_install, sims.db_p_grant, sims.db_p_importusers but still nothing.

    Thanks, Dan.

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    Go back to the old server, run sims.db_p_transfer_logins, do a backup, restore onto the new server.

    Hopefully 2. is now solved. As for 1. are they on the same domain?

  3. Thanks to matt40k from:

    dan400007 (30th July 2012)

  4. #3

    Join Date
    Jul 2007
    Location
    Nottingham
    Posts
    195
    Thank Post
    19
    Thanked 7 Times in 7 Posts
    Rep Power
    16
    Thanks, will give that a try a little latter.

    Both servers are on the same domain.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Upgrade SQL 2008 Express to FULL 2008 R2 Standard
    By fiza in forum MIS Systems
    Replies: 9
    Last Post: 29th June 2013, 07:46 PM
  2. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  3. "Upgrading" to Server 2008
    By googlemad in forum Windows Server 2008
    Replies: 1
    Last Post: 26th November 2009, 12:35 PM
  4. Will you be upgrading to server 2008 this summer?
    By FN-GM in forum Windows Server 2008
    Replies: 34
    Last Post: 18th July 2008, 08:12 PM
  5. FMS Upgrade to SQL and CFR reports
    By wesleyw in forum MIS Systems
    Replies: 0
    Last Post: 3rd April 2008, 08:58 AM

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
  •