+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, New Sims Install User Names missing in Master DB in Technical; I did a new sims and fms install on Windows Server 2008 R2. Everything went ok, e.g no errors. I ...
  1. #1

    Join Date
    Feb 2011
    Location
    London
    Posts
    5
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    New Sims Install User Names missing in Master DB

    I did a new sims and fms install on Windows Server 2008 R2. Everything went ok, e.g no errors. I now restored the sims database from a backup but I cannot log in.
    At get the error, invalid user name/password. Are username and passwords stored in the Master DB. How can I transfer them accross?

  2. #2

    Join Date
    Feb 2011
    Location
    London
    Posts
    5
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks, but that didn't do the trick. First command executed fine. Running exec sims.db_p_grant didn't get any acknowlegment at the end.

  3. #3

    Join Date
    Apr 2010
    Posts
    2,036
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    Do you still have access to the old sims system?

  4. #4

    Join Date
    Feb 2011
    Location
    London
    Posts
    5
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I can connect using sqlcmd to the sims database either from the server or from my laptop

  5. #5

    Join Date
    Feb 2011
    Location
    London
    Posts
    5
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Yes, the old system is still running. Building this system in it's own environment and only roll out once everything is working.

  6. #6

    Join Date
    Apr 2010
    Posts
    2,036
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    can you detatch the old database using sims dbattach and attach to the new server. This is the preferred method.

    Sorry if its how you did it the first time but just covering all bases.

  7. #7

    Join Date
    Feb 2011
    Location
    London
    Posts
    5
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks to everyone. When I did the whole procedure again. Detaching old Database using dbatach, copying it over and re-ataching it using dbatach it somehow did the trick this time round. Tried it twice before. Sims application will always be a mistery. Thanks very mcuh

  8. #8
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    For future reference, run this SQL command from a cmd prompt before you detach the database from your old system. it will transfer all logins from the master database first:

    SIMS
    Code:
    osql -S%COMPUTERNAME%\SIMS2008 -Usa -Psa_password_here -n -Q"exec sims.sims.db_p_transfer_login"
    FMS
    Code:
    osql -S%COMPUTERNAME%\SIMS2008 -Usa -Psa_password_here -n -Q"exec ccsfms.sims.db_p_transfer_login"

  9. 2 Thanks to Rawns:

    bgall (23rd February 2011), matt40k (21st February 2011)

  10. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,391
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Cheers, was just looking for that... saved me having to install SQL Studio

  11. #10
    jimothy's Avatar
    Join Date
    Mar 2008
    Location
    Shrewsbury
    Posts
    43
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I had to run the following query in SQL Studio to allow me to login and the sysman account:

    exec sims.db_p_reset_sysman_password

  12. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by jimothy View Post
    I had to run the following query in SQL Studio to allow me to login and the sysman account:

    exec sims.db_p_reset_sysman_password
    That's handy, but the best you can do then, is to go into system manager and reset other people's accounts. That's still a huge pain dishing out those horrid initial passwords to all.

  13. #12
    jimothy's Avatar
    Join Date
    Mar 2008
    Location
    Shrewsbury
    Posts
    43
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    That's handy, but the best you can do then, is to go into system manager and reset other people's accounts. That's still a huge pain dishing out those horrid initial passwords to all.
    True, but I was only using it for copying data from a few fields which had been mistakenly deleted. We also use AD Trusted Auto so we don't have to dish out all the extra usernames and passwords.

  14. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,391
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    @vikpaw - Good opportunity to brush up on those ctl+C\ctl-V skills

  15. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by matt40k View Post
    @vikpaw - Good opportunity to brush up on those ctl+C\ctl-V skills
    - i need the practise, since i seemed to bork that up on my new OP Smartdesk install.

    Maybe the new system manager will have an email to user option .... [ if only the MD of SIMS read these forums.... ] </sigh>

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2007] Word says the file is locked by a user, but names the wrong user!
    By AngryTechnician in forum Office Software
    Replies: 10
    Last Post: 12th January 2012, 12:45 PM
  2. User Names
    By knightrider in forum Windows Server 2000/2003
    Replies: 23
    Last Post: 9th June 2010, 12:40 PM
  3. User names
    By leco in forum Comments and Suggestions
    Replies: 31
    Last Post: 19th January 2010, 08:06 AM
  4. Can't install SIMS - "package missing" error
    By Rowley_THS in forum MIS Systems
    Replies: 15
    Last Post: 9th September 2009, 08:59 AM
  5. Sims.net (unique user defined reports missing)
    By edie209 in forum MIS Systems
    Replies: 3
    Last Post: 15th June 2006, 12:17 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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