+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 26
MIS Systems Thread, FMS level 5 Access has gone from all my users HELP in Technical; we have recently upgraded our sims server (about a month ago) to server 2008R2 running SQL 2008 it all seemed ...
  1. #1

    Join Date
    Oct 2007
    Posts
    131
    Thank Post
    16
    Thanked 14 Times in 14 Posts
    Rep Power
    16

    FMS level 5 Access has gone from all my users HELP

    we have recently upgraded our sims server (about a month ago) to server 2008R2 running SQL 2008 it all seemed fine until the bursar came in today and found that he didn't have the correct access rights so phoned me and asked me to add them I tryed and I don't have access no one does!! I have phoned our help desk but they have no idea how to get them back waiting on capita at the moment has any one had this before or know a fix ? I run the password transfer script as part of my back up so do see how this has happened any Ideas??

  2. #2
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Have you tried using the default login of 'sysman' & 'password'? If that lets you in, you can set up your FMS main user and give them permissions to create the logins & permissions again.

  3. Thanks to Rawns from:

    alextreadwell (29th March 2011)

  4. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by Rawns View Post
    'password'
    Your mean 'finance'

  5. Thanks to matt40k from:

    Rawns (29th March 2011)

  6. #4
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Indeed I do...

  7. #5

    Join Date
    Oct 2007
    Posts
    131
    Thank Post
    16
    Thanked 14 Times in 14 Posts
    Rep Power
    16
    Hi thasnks for the responces but I tried that straight away with no luck any ideas welcome as the LA is dragging its heals at the moment.

  8. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    What's your LA?

  9. #7

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    @Rawns:

    What version of SQL are you running with?

  10. #8

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    @Rawns:

    Can you log in as the SA user and map the other users?

    When you upgraded the server did you detach both the Sims and FMS databases and then re-attach or was it just a straight server upgrade?

  11. #9

    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
    @Bossman - i think you mean to address your response to @AlexTreadwell who is the OP.

    - tried to have a quick look at my fms db but couldn't see where the users were

    am making a test setup in next day or so, and may play with it more - i was going to suggest a hack but problem is it wouldn't be supported.

  12. #10
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    I think you can run this command on the SQL server which will reset the sysman password back to it's default...

    Code:
    osql -Sserver_name\instance_name -U sa -P sa_password -n -Q"exec ccsfms.sims.db_p_reset_sysman_password"
    For example:

    Code:
    osql -S127.0.0.1\SIMS2008 -U sa -P abcd1234 -n -Q"exec ccsfms.sims.db_p_reset_sysman_password"
    EDIT: You can use the above. Just tested it on my own FMS system and it's reset the password back to 'finance'. Give that a bash.
    Last edited by Rawns; 30th March 2011 at 08:49 AM.

  13. Thanks to Rawns from:

    alextreadwell (31st March 2011)

  14. #11

    Join Date
    Oct 2007
    Posts
    131
    Thank Post
    16
    Thanked 14 Times in 14 Posts
    Rep Power
    16
    Thanks for all your replies the data has been looked at by capita and It apears to ok ie all the users have level 5 access at their end ??? I can get access as sysman all my users can login but when I try to add new user or change permissions as sysman or any user it greys out all the buttons ie the plus and minus and change passord / access rights. so only the user can change their own password. going to try installing it all again on a different server see if it changes anything, I detached the database and I have also tried attaching a backed up database as well with no change its driving me mad.

  15. #12

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    61
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    16
    Have seen this before, and I think this stems back to a problem with he original migration from SQLAnywhere to Microsoft SQL Server. Only the user the migration was run as was given true level 5 access at the time, and there was a patch that needed to be applied to fix the other users, but that patch is probably well out of date by now. If you know the user the migration was run as you can log in as that user and reset the level 5 access by editing the users and access rights.

  16. Thanks to splattthecat from:

    alextreadwell (5th April 2011)

  17. #13

    Join Date
    Oct 2007
    Posts
    131
    Thank Post
    16
    Thanked 14 Times in 14 Posts
    Rep Power
    16
    Thanks I remembered this and yes I think do know the user that did the migration a user that has been disabled and I have no Idea of there password can I reset a users password I do know how to reset the sysman password also can I enable a disabled account? I have SQL management studio installed and can see all the users have level 5 access but the the change password / access rights are still greyed out it very strange?? any Ideas welcome need to have it back up to do end of year very soon

  18. #14

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Personally, log it with your LA and get them to log it with Capita. It's what you pay for, it's pretty serious so it should be sorted within 10 working days (I think).

  19. #15
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    But might not Capita turn round and say "unsupported server OS"? Server 2008 R2 was only supported from the, just released, Spring update.

    I know FMS is very particular about how you update SQL, move the DB around etc. The common thing is for it to 'drop' the SQL logins. This sounds similar.

    @AlexTreadwell: Did you use the FMS DBAttach, or the SIMS DBAttach?

  20. Thanks to NorthernSands from:

    alextreadwell (6th April 2011)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 5
    Last Post: 4th December 2009, 11:50 PM
  2. Access to Low Level file
    By steve_nfi in forum Windows 7
    Replies: 3
    Last Post: 23rd November 2009, 05:45 PM
  3. FMS multiple users?
    By adamf in forum MIS Systems
    Replies: 7
    Last Post: 19th August 2008, 01:17 PM
  4. FMS "level 5" user login
    By dhicks in forum MIS Systems
    Replies: 1
    Last Post: 20th June 2008, 02:34 PM
  5. Reading FMS from Access
    By LitVer in forum MIS Systems
    Replies: 11
    Last Post: 25th May 2007, 08:19 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
  •