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 ...
30th July 2012, 03:50 PM #1
- Rep Power
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.
30th July 2012, 03:56 PM #2
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?
Thanks to matt40k from:
dan400007 (30th July 2012)
30th July 2012, 04:08 PM #3
- Rep Power
Thanks, will give that a try a little latter.
Both servers are on the same domain.
By fiza in forum MIS Systems
Last Post: 29th June 2013, 08:46 PM
By dtakias in forum MIS Systems
Last Post: 18th January 2011, 01:20 PM
By googlemad in forum Windows Server 2008
Last Post: 26th November 2009, 01:35 PM
By FN-GM in forum Windows Server 2008
Last Post: 18th July 2008, 09:12 PM
By wesleyw in forum MIS Systems
Last Post: 3rd April 2008, 09:58 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)