+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SQL 2005 and SIMS FMS Finance in Technical; We have just done the SIMS August release update and migrated the DB to the full SQL 2005. After a ...
  1. #1
    thom's Avatar
    Join Date
    Jul 2005
    Location
    Bedford, East Anglia, UK
    Posts
    242
    Thank Post
    4
    Thanked 6 Times in 5 Posts
    Rep Power
    20

    SQL 2005 and SIMS FMS Finance

    We have just done the SIMS August release update and migrated the DB to the full SQL 2005. After a few glitches it seems to be OK.

    I was under the impression that the FMS modules would stop using sybase/sqlanywhere and also move to SQL 2005 but when I try to run SOLUS it says that the finance user I login as has'nt got the correct level of priveleges. Does anybody know of a default sysman userpassword that I could use?

    I phoned up the helpdesk and they said there was definately no Finance update to do with the 2005 migration so not to worry.

    However, when I run the finance modules on the client they throw up an error but then allow everything to carry on as normal.
    I also found this http://www.capitasolus.co.uk/Release...tion_Guide.pdf and that implies that there is an update?!? I'm confused :?

    The reason I am concerned is mainly because I will have to install FMS on 2 new PCs and the last upgrade disc we got was in May.

    Can anybody clear my head?

  2. #2

    Join Date
    Feb 2007
    Location
    Barnet
    Posts
    87
    Thank Post
    12
    Thanked 14 Times in 12 Posts
    Rep Power
    0

    Re: SQL 2005 and SIMS FMS Finance

    FMS as from this month has moved to SQL2005. You can run versions up to 6.85 on the old MySQL and continue to do so even after taking the rest of Sims to SQL2005. There is a migration process to take FMS to 6.91 which is the first one that works with SQL2005. The upgrade and migration process is separate to changing sims.net to SQL2005. There is a migration document available from Supportnet to help with this process.
    Amazing that your help desk could not be of more help.

  3. #3
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    Re: SQL 2005 and SIMS FMS Finance

    I had this problem, you need to make sure the SIMS.net update has been run on the PC's before using FMS.

    You can migrate FMS to SQL 2005, but there's no rush yet.

SHARE:
+ Post New Thread

Similar Threads

  1. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 10:27 AM
  2. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 09:20 AM
  3. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 PM
  4. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 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
  •