+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, FMS Fault in Technical; Hi all, Hope someone can advise here... Since doing a bit of maintenance on our SQL server yesterday, I'm getting ...
  1. #1

    Join Date
    Nov 2011
    Location
    Redditch
    Posts
    14
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    FMS Fault

    Hi all,

    Hope someone can advise here...

    Since doing a bit of maintenance on our SQL server yesterday, I'm getting this error when trying to log in to FMS with the 'sysman' account.

    FMS School (Pre Academy).jpg

    Cutting a long story short... The SIMS and FMS databases needed to be moved due to lack of HD space.
    This was done successfully, or so I thought!

    We have two FMS databases... One prior to becoming an academy and one since becoming an academy. Both were working perfectly well before the move and now only the academy database works.
    All of the other SIMS databases work fine.

    When logging into SQL Management Studio, I can see the users for that database and also the logins that tally up with them.

    I have tried logging on to the database in question with a standard user account and I get 'Invalid user id/password or database name error'

    Have also tried manually resetting the user password within Management Studio and still get the 'Invalid user id message.

    Trying to give as much information as I can without waffling.

    Hope someone can point me in the right direction...

  2. #2

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    8,897
    Thank Post
    351
    Thanked 1,289 Times in 881 Posts
    Blog Entries
    4
    Rep Power
    1128
    There is an old thread on this error here:

    Link: FMS problem

    Thread date: 31st October 2008. The reported fault is the same: @Hecate says that Capita sorted it.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Have you tried deattaching and reattaching the affected database?

  4. #4

    Join Date
    Nov 2011
    Location
    Redditch
    Posts
    14
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by DaveP View Post
    There is an old thread on this error here:

    Link: FMS problem

    Thread date: 31st October 2008. The reported fault is the same: @Hecate says that Capita sorted it.
    Thanks for the link...
    I did see this but with it being 4 years old, I wasn't sure if there would be any fresh information on this particular fault.

  5. #5

    Join Date
    Nov 2011
    Location
    Redditch
    Posts
    14
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Yes, I've tried detaching and reattaching and also restoring from really old backups too to see how far the fault goes back.
    Either way, the problem remains. :/

    Quote Originally Posted by matt40k View Post
    Have you tried deattaching and reattaching the affected database?

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Quote Originally Posted by GeekyGav View Post
    Yes, I've tried detaching and reattaching and also restoring from really old backups too to see how far the fault goes back.
    Either way, the problem remains. :/
    Did you attach it with a different name? Did you move the mdf\ldf out of the data directory first? I assume you used dbattach to attach?

  7. #7
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,287
    Thank Post
    600
    Thanked 159 Times in 144 Posts
    Blog Entries
    78
    Rep Power
    83
    That's odd... I had the very same error last week with this. @PhilNeal...something we can get support to look at? My fix was a detach reattach. There is also a script that I can post up which captures all you SQL login det,ails so you don't have to recreate them. PM me if you need anything

  8. #8

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    @theScafedOne - our desk will always try to reslove these issues. Your support unit should be your first port of call and that could be your LA or us.

  9. #9

    Join Date
    Mar 2012
    Posts
    18
    Thank Post
    3
    Thanked 6 Times in 4 Posts
    Rep Power
    7
    I've got the same problem at one of my schools - I'm so glad I'm not the only one!
    If I take a copy of the data and load in the office it works fine.
    Call logged with Capita.....

  10. #10
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,287
    Thank Post
    600
    Thanked 159 Times in 144 Posts
    Blog Entries
    78
    Rep Power
    83
    @PhilNeal, Ive put a post about this on my blog - hope thats ok.

  11. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Am I missing something, what you've described is (or similar to) the sims install store procedure - as far as I can make out. This creates the SQL users in the MASTER database and links to them to the database - you sometimes have issues if you have a very old database, say called fms, then to deattach\restore it as say, fmsold. Running the install procedure updates the sql logins so they become fmsold_username, rather then fms_username. Do I understand right?

  12. #12
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,287
    Thank Post
    600
    Thanked 159 Times in 144 Posts
    Blog Entries
    78
    Rep Power
    83
    It is kind of. It is more a fix for those who forget to do a DBAttach if moving a database between servers; but you can apply it to the "Atomic" error - where the recomendation is to do the Dettach Re-attach.

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Then just run exec sims.db_p_install.

SHARE:
+ Post New Thread

Similar Threads

  1. Strange mouse/keyboard fault
    By SimpleSi in forum Hardware
    Replies: 4
    Last Post: 12th June 2006, 12:12 PM
  2. Wanted: SIMS FMS & Fees Ledger Guru
    By pete in forum MIS Systems
    Replies: 0
    Last Post: 22nd May 2006, 09:05 AM
  3. FMS
    By StewartKnight in forum MIS Systems
    Replies: 19
    Last Post: 3rd May 2006, 09:35 PM
  4. FMS Famous Purple Hand!
    By Adam in forum MIS Systems
    Replies: 12
    Last Post: 28th March 2006, 02:56 PM

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
  •