MIS Systems Thread, 2003 to 2008 migration - No user passwords. in Technical; Hi.
Last week I initiated a move of our SIMS data to a new server (from server Windows version 2003 ...
5th August 2013, 09:23 AM #1
2003 to 2008 migration - No user passwords.
Last week I initiated a move of our SIMS data to a new server (from server Windows version 2003 to server 2008). I followed the usual SIMS method using DBattach etc and all seemed to go well right up until I attempted to log in.
So I call Capita and somebody dials into our servers. After a few minutes we manage to get the sysman password changed and we go in and we can see all the data - it's all there apart from user passwords.
We change my password and I can log in and I confirm that yes the data is all there where it should be only problem is nobody else would be able to get in (Thankfully the database isn't live yet.) They then say they need to escalate the call.
This was last week and I've heard nothing since. I've been pestering them quite a bit but have heard nothing.
Has anyone else had the same issue? I really need to get this resolved soon as possible.
5th August 2013, 11:30 AM #2
This happens sometimes when you detach the database before transfering the logins from the master table. It's best practice to force a transfer of the logins form the master database into the SIMS/FMS databases before detaching them and copying them to the new server. you can do this by running these commands via SSMS against the SIMS and FMS databases:
SIMS: exec sims.sims.db_p_transfer_login
FMS: exec ccsfms.sims.db_p_transfer_login
Last edited by Rawns; 5th August 2013 at 01:01 PM.
5th August 2013, 01:01 PM #3
Sorry - we can't trace a call like this. Please recall our desk if you still need assistance.
By Trapper in forum Windows Server 2008
Last Post: 29th March 2010, 12:06 PM
By techie08 in forum Windows Server 2008 R2
Last Post: 17th November 2009, 01:57 PM
By willv28 in forum Windows Server 2008 R2
Last Post: 12th November 2009, 05:56 AM
By garethedmondson in forum Windows Server 2008
Last Post: 30th October 2009, 07:34 AM
By KWestos in forum Wireless Networks
Last Post: 2nd October 2009, 03:32 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)