+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
MIS Systems Thread, SIMS + SQL 2005? in Technical; Has anyone tried SIMs with SQL 2005? Does it work? I did ask Capita but they said it was unsupported ...
  1. #1
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,384
    Thank Post
    54
    Thanked 315 Times in 245 Posts
    Blog Entries
    6
    Rep Power
    120

    SIMS + SQL 2005?

    Has anyone tried SIMs with SQL 2005? Does it work? I did ask Capita but they said it was unsupported

    Reason I ask is, I've ordered a new SIMS server and a full version of SQL to go with it. I did ask for SQL 2000 media but they sent me 2005. When I set it up, shall I try it with 2005 or should I badger Ramesys to send me the SQL 2000 disk?

  2. #2
    eejit's Avatar
    Join Date
    Jun 2005
    Location
    Ireland
    Posts
    606
    Thank Post
    52
    Thanked 12 Times in 12 Posts
    Rep Power
    22

    Re: SIMS + SQL 2005?

    I haven't tried it - but no real surprise there. I have to rebuild an XP64 bit OS with 32 bit shortly as SIMS Finance won't work on 64bit :x

  3. #3
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,384
    Thank Post
    54
    Thanked 315 Times in 245 Posts
    Blog Entries
    6
    Rep Power
    120

    Re: SIMS + SQL 2005?

    One day, Capita will get rid of all the legacy 16 bit crap in SIMS. Probably won't happen any time soon though :\

  4. #4

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,619
    Thank Post
    1,499
    Thanked 1,053 Times in 922 Posts
    Rep Power
    304

    Re: SIMS + SQL 2005?

    I would badger them for the 2000 disk FOC as you did ask for a 2000 copy, I am sure they will give you it FOC.

  5. #5

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS + SQL 2005?

    Yes you should demand the 2000 media because Capita have said on their website that they are unlikely to support 2005 for a while yet.

    I also remember that reading somewhere that Capita don't belive the preformance throttling on MSDE is a problem for around 30 odd clients.

  6. #6

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340

    Re: SIMS + SQL 2005?

    Also Capita still don't support SQL 2000 SP4, but only SP3a. I can't see why Sims shouldn't work with SQL 2005, as MS wants customers to migrate to the new product. As Capita don't currently support SQL 2005, I would definitely install SQL 2000

  7. #7
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,384
    Thank Post
    54
    Thanked 315 Times in 245 Posts
    Blog Entries
    6
    Rep Power
    120

    Re: SIMS + SQL 2005?

    Quote Originally Posted by NetworkGeezer
    I also remember that reading somewhere that Capita don't belive the preformance throttling on MSDE is a problem for around 30 odd clients.
    Yes, I read the same thing. I'm not convinced however as whenever someone runs a report on Attendance or Assessment Manager or even does timetabling information, the server goes to 100% CPU usage with the SQL process taking it all. It prevents people from logging in and stops people who are in from working. I'm pretty sure its throttling so I thought since I'm building a new SIMS server, a proper version of SQL might as well go on there.

  8. #8
    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: SIMS + SQL 2005?

    We have the full version of SQL 2000 and running Attendance or Assessment Manager still grinds SIMS to a halt with 100% CPU usage.

  9. #9
    metalmonkey
    Guest

    Re: SIMS + SQL 2005?

    It's probably not related but worthy of note nonetheless.

    If the Exams officer at your school is runnig Submissions, the whole of SIMS SQL will grind to a halt. It's a known 'querk'.

    We also thought it was our SIMS server or MSSQL 2000.

    Our Exams officer has now agreed to only do submissions after school.

  10. #10

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS + SQL 2005?

    Quote Originally Posted by steve
    We have the full version of SQL 2000 and running Attendance or Assessment Manager still grinds SIMS to a halt with 100% CPU usage.
    It all depends on server spec. Something as important as an MIS should go a dedicated server hardware. Lots of GHz, lots of memory, lots of disk space, RAID etc. etc.

  11. #11

    Join Date
    Mar 2007
    Location
    Eastbourne
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS + SQL 2005?

    i think capita are saying that as of 1 August you will HAVE to be on sql2005. this update, and all future updates, will only support sql2005. so any practice that you can get on sql2005 will be invaluable come the summer. however, if your requirement is urgent then the current release, of sims, will work on sql2005 but it is NOT fully compatible and capita will not support this environment.

    my understanding of licensing, which i admit is sadly lacking, is that if you've paid your money then you can install any version that you want. so you may have to pay again for the sql2000 media but i would definitely keep hold of the sql2005 media as you will need it very shortly. obviously, you will have to purchase additional sql licenses depending on what you have already purchased.

  12. #12

    Join Date
    Mar 2007
    Location
    Eastbourne
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS + SQL 2005?

    i think capita are saying that as of 1 August you will HAVE to be on sql2005. this update, and all future updates, will only support sql2005. so any practice that you can get on sql2005 will be invaluable come the summer. however, if your requirement is urgent then the current release, of sims, will work on sql2005 but it is NOT fully compatible and capita will not support this environment.

    my understanding of licensing, which i admit is sadly lacking, is that if you've paid your money then you can install any version that you want. so you may have to pay again for the sql2000 media but i would definitely keep hold of the sql2005 media as you will need it very shortly. obviously, you will have to purchase additional sql licenses depending on what you have already purchased.

  13. #13
    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: SIMS + SQL 2005?

    Quote Originally Posted by animalboy1968
    i think capita are saying that as of 1 August you will HAVE to be on sql2005. this update, and all future updates, will only support sql2005.
    The August release will work on both SQL 2000 AND 2005 (and the free versions). This will be the only release supported on both. Releases after August will only work on SQL 2005 / Express.

    So in theory you could work with the august release on sql 2000 for sometime after - but everyone needs to upgrade eventually, due to school census changes. These updates will only work on sql 2005 / express.

    Migration tools are being created to move from MSDE to Express. Full SQL 2000 users need to assess whether to move to Express and save on licencing, or go to full SQL 2005. Advice and instructions will no doubt be available nearer to the august release.

  14. #14
    projector1's Avatar
    Join Date
    Nov 2005
    Posts
    461
    Thank Post
    70
    Thanked 1 Time in 1 Post
    Rep Power
    18

    Re: SIMS + SQL 2005?

    the sql 2005 lite version of sql is far more powerful than 2000 msde. It is also free aswell and does not have the governor. I read all this an a technet mag a year or so back and was told by our sims support team that 2005 is not supported, looks like thats still the case!

  15. #15
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,056
    Thank Post
    69
    Thanked 77 Times in 61 Posts
    Rep Power
    35

    Re: SIMS + SQL 2005?

    Same boat here. I have recently put SIMS on a new server and ordered "full" SQL 2005. I asked for 2000 but was told that the supplier (Ramesys) could not get the 2000 media any more.

    I was unsure about putting Backup Exec 11d on this server since it uses 2005 express and I didn't know how SIMS/MSDE 2000 would react so used remote agent to back it up. WOrks fine.

    HBJB

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

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. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 PM
  5. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 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
  •