+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, passwords reset when attaching database in Technical; Hi there I have an usual query (I think!) has anyone every come across passwords in System manager 6 being ...
  1. #1

    Join Date
    Jun 2011
    Location
    UK
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    passwords reset when attaching database

    Hi there

    I have an usual query (I think!)
    has anyone every come across passwords in System manager 6 being reset for users when you reattached a database?
    We have problems with a database and brought it in to look at it. When the database was attached, all the users had their passwords reset. you could see it in sysman.
    I know it is no big deal as we can reset but I was wondering why it happened.

    has anyone any ideas?

  2. #2

    Join Date
    Apr 2010
    Location
    Cheshire
    Posts
    17
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    9
    For the passwords to be 'transported' to a new SQL Server, the database must be detached using the DBAttach utility from Capita. DBAttach transfers the passwords from the Master database into the SIMS database ready for transit. You will probably find that not all passwords are reset and it's only those that have been created since the last DBAttach which is probably when SIMS was migrated to SQL 2008.

  3. #3

    Join Date
    Apr 2010
    Location
    Cheshire
    Posts
    17
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    9
    BTW DBAttach isn't the only method of transferring the passwords as there's also a script you can run but I've never used it.

  4. #4

    Join Date
    Jun 2011
    Location
    UK
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I have just checked and they shifted it by stopping the services and copying the mdf and ldf. You have been a great help.
    Thanks Janit

  5. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by Janit View Post
    BTW DBAttach isn't the only method of transferring the passwords as there's also a script you can run but I've never used it.
    This can be ran from a command prompt or a batch file (Exclude the [] when putting your info in):
    Code:
    osql -S[IP_Address/Hostname]\[SQL_Instance] -U[username] -P[Password] -n -Q"exec [Database_Name].sims.db_p_transfer_login"
    SIMS:
    Code:
    osql -S127.0.0.1\SIMS2008 -Usa -Ppassword -n -Q"exec sims.sims.db_p_transfer_login"
    FMS
    Code:
    osql -S127.0.0.1\SIMS2008 -Usa -Ppassword -n -Q"exec ccsfms.sims.db_p_transfer_login"
    We use these in our backup script even though we backup the databases using dbAttach. There is no harm running the script first. If anything, it acts as a fail-safe to ensure login's are transferred first.
    Last edited by Rawns; 24th June 2011 at 04:51 PM.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by Rawns View Post
    ...We use these in our backup script even though we backup the databases using dbAttach. There is no harm running the script first. If anything, it acts as a fail-safe to ensure login's are transferred first.
    You should, because from the testing i did, it seems that doing a dbattach backup, doesn't transfer the logins. This is not very useful, so i made a CR for it:

    1103-855974

    Please vote if you haven't already done so. I also requested they add a command line / gui option to perform the procedure so that we dont have to run SPs ourselves manually.

    EDIT: This thread is also really useful to read, from when i did some testing on the issues, the linked post and also another one later on. Basically, it seemed that rather than doing a stopped service file move, if you do a backup and restore the .bak file, then any logins already held in the db would get pushed over.

    If you have ended up with no logins in your db, maybe just doing a detach/reattach will push whatever has been stored into your db, or could try to restore a backup. Both processes should put some users back. Might be good to try.

    Sims Backup
    Last edited by vikpaw; 26th June 2011 at 07:47 AM. Reason: add link

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 17
    Last Post: 31st December 2013, 10:49 AM
  2. Attaching a Sims database error
    By zag in forum MIS Systems
    Replies: 5
    Last Post: 24th September 2009, 02:43 PM
  3. Attaching FMS Database
    By mloveless in forum MIS Systems
    Replies: 0
    Last Post: 3rd June 2008, 03:39 PM
  4. Replies: 1
    Last Post: 3rd January 2008, 12:04 PM
  5. Replies: 12
    Last Post: 12th September 2005, 10:47 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
  •