+ Post New Thread
Page 3 of 3 FirstFirst 123
Results 31 to 42 of 42
MIS Systems Thread, Sims forced upgrade? in Technical; Originally Posted by Mcshammer_dj In all of this debate we only appear to be looking at Capita because they have ...
  1. #31

    Join Date
    Feb 2010
    Posts
    28
    Thank Post
    1
    Thanked 5 Times in 3 Posts
    Rep Power
    19
    Quote Originally Posted by Mcshammer_dj View Post
    In all of this debate we only appear to be looking at Capita because they have moved to SQL 2008. The other "main" products in the market also have a reliance on Microsoft and will also require the same updates in the future

    Bromcom
    "Bromcom MIS is a Microsoft .NET, predominantly web-based application that runs on the Microsoft Windows 2003 Server operating system with Microsoft SQL Server 2005"

    (and does this work as a true web app or do you need IE and the MS plugins?)

    "

    <Edited for unauthorised adverising - Dos_Box>
    Last edited by Dos_Box; 8th February 2010 at 06:26 PM.

  2. #32
    zag
    zag is online now
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,746
    Thank Post
    895
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85
    Won't make much of a difference in the future when all this stuff moves into the cloud.

    Also you can do the 2008 upgrade yourself, the last one was a 60 minute job from what I remember.

  3. #33
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    922
    Thank Post
    35
    Thanked 160 Times in 129 Posts
    Rep Power
    93
    [Quoting content that was <Edited for unauthorised adverising - Dos_Box> ]

    but am I still right in the assumption that when your database needs to be migrated the sites will need to purchase a new licence??

    Equally does bromcom work fully with FIrefox or chrome etc
    Last edited by vikpaw; 9th February 2010 at 06:16 AM. Reason: removing quote content that was unauthorised

  4. #34

    Join Date
    Feb 2010
    Posts
    28
    Thank Post
    1
    Thanked 5 Times in 3 Posts
    Rep Power
    19
    Quote Originally Posted by Mcshammer_dj View Post
    but am I still right in the assumption that when your database needs to be migrated the sites will need to purchase a new licence??

    Equally does bromcom work fully with FIrefox or chrome etc
    Yes, you will need to buy Microsoft SQL 2008 license. However CALS you need to buy is likely to be much less than in the case of non-browser MIS with thick based Windows solutions.

    Indeed, Bromcom teacher's client software for "in classroom use" work fully for IE 7&9, Firefox, Chrome, Safari and Opera with any operating system and with no emulation.

    Admin office parts/use is tested for only IE7&8.

  5. #35

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    115
    Quote Originally Posted by m25man View Post
    A 32-bit system can only directly access a maximum of 4 GB of memory.
    I'd say all current Windows x86's are arguably 36-bit systems, just with artificial physical memory addressing limits coded into different editions. Although it won't play with physical memory over 4GB, the XP running on this laptop is running with the OS support and the OS page table overheads to accommodate AWE and calls to the API will work. [XP SP2+ likes DEP on by default and that needs PAE]

    But, with all of the newly addressable memory and speedy databases how long before they fill it all with bloated modules and subroutines?
    I once worked on a very serious "MIS" (at least as complex as SIMS and definitely with more concurrent users) Server-side was in four logical parts and each one fitted in < 1MB RAM running on a DOS VM. Mid-late 90s everyone went "We must have our data in an 'open' database so we can access it", which of course they never do (or can't because of licence restrictions) and the bloat began. XML did a similar thing to comms bandwidth.

    The X64 is a very good point (it's the default for me for any new server): I don't know about this round, but there was a very significant memory increase for SIMS SQL2K->SQL2K5.

  6. #36
    SkywOrca's Avatar
    Join Date
    Sep 2008
    Posts
    79
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    47
    Quote Originally Posted by BromcomPublicRelations View Post
    Yes, you will need to buy Microsoft SQL 2008 license. However CALS you need to buy is likely to be much less than in the case of non-browser MIS with thick based Windows solutions.
    I seriously doubt this is actually the case, you need to buy SQL CALs for all users of the SQL database, no matter what method they use to connect with if they are performing write back operations. Certainly, the licensing model for the Serco ePortal product requires that you buy SQL CALs for each of the client (Facility Admin) users and for each teacher login to ePortal. The only ones that shouldn't requre CALs are parents and student logins to ePortal, since they don't have any ability to write data back to the database. This was confirmed with Microsoft UK themselves.

    I don't know how you conclude that an all-browser based MIS would therefore results in fewer CALs?

  7. #37

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,348
    Thank Post
    367
    Thanked 626 Times in 510 Posts
    Rep Power
    156
    Is Bromcom thinking of using the external connector?

    But then you couldn't use the SQL\Windows security???

  8. #38

    Join Date
    Feb 2010
    Posts
    28
    Thank Post
    1
    Thanked 5 Times in 3 Posts
    Rep Power
    19
    Quote Originally Posted by SkywOrca View Post
    I seriously doubt this is actually the case, you need to buy SQL CALs for all users of the SQL database, no matter what method they use to connect with if they are performing write back operations. Certainly, the licensing model for the Serco ePortal product requires that you buy SQL CALs for each of the client (Facility Admin) users and for each teacher login to ePortal. The only ones that shouldn't requre CALs are parents and student logins to ePortal, since they don't have any ability to write data back to the database. This was confirmed with Microsoft UK themselves.

    I don't know how you conclude that an all-browser based MIS would therefore results in fewer CALs?

    Bromcom is happy to be corrected but since Microsoft Windows Server 2003 internet users do not use up a windows CAL licence. In stating this, Bromcom relies on the following extract from Microft License information. However reader should check for themselves and not rely on this.


    In previous Windows Server licensing models, Windows Client Access Licenses were automatically triggered when particular server services were invoked (such as file, print, remote access, and terminal services, as well as authenticated access).

    With Windows Server 2003, CALs are no longer triggered based on the use of certain services but are instead based on access to and/or use of the server software. This holds true for all editions of Windows Server 2003 and Windows Server 2003 R2, except Web Edition. Windows CALs are not required for Web Edition.

    Note the following general exception to Windows CAL requirements: Windows CALs are not required when access to the server software is unauthenticated and conducted through the Internet. Authenticated access is defined as an exchange of user or application credentials between the server software and a user or device. An example of this exception would be if unidentified users browsed your public Web site. Windows CALs would not be required for those users.”



    If this is the case it means using a browser based MIS, in addition to the other benefits stated previously, will also bring further saving in Microsoft license cost for schools with large number of users.
    Last edited by BromcomPublicRelations; 2nd February 2010 at 06:57 PM. Reason: Typo

  9. #39
    garrysaddington's Avatar
    Join Date
    May 2007
    Location
    Hogsthorpe
    Posts
    89
    Thank Post
    3
    Thanked 25 Times in 16 Posts
    Rep Power
    38
    Quote Originally Posted by BromcomPublicRelations View Post


    If this si the case it means using a browser based MIS, in addition to the other benefits stated previously, will also bring further saving in Microsoft license cost for schools with large number of users.
    Not using any MS software would bring even greater savings

  10. #40

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,382 Times in 1,144 Posts
    Rep Power
    349
    i'm confused now Bromcom.

    I initially thought we were talking about SQL CALS, such that if you connected via a browser to a server and that server/software made the SQL calls then effectively there'd only be one SQL user. i think i was dreaming.

    Either way, Windows CALS would still be needed wouldn't they, even for web access, certainly if we are wanting authenticated access which i hope we all are.

    What are the issues around Server 2008 which is where we are headed?
    anyone?

  11. #41
    SkywOrca's Avatar
    Join Date
    Sep 2008
    Posts
    79
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    47
    I'm slightly confused as to which licences we're discussing now, too, but I believe that as far as SQL CALs are concerned, you need a separate SQL CAL for each user that has write access to the database, no matter how they achieve that access. So the presumption that because the web service connects to the database via a single server they only need one CAL isn't correct. There's fine print in the licensing documentation that states that any ability for users to log into a system that connects those users directly to an SQL database with write access, even if that's a custom login function, then they're considered separate users and require a CAL.

    I personally didn't liaise with Microsoft on this, but a colleague of mine did, and after explaining the access model used by the Serco ePortal product (which uses an internal login authentication model) we were told specifically that this is covered by the licensing agreement and explicitly requires an SQL CAL to be purchased.

    As to how many Server 2003/2008 CALs you'd need to purchase, I'm not so sure. We were only concerned with the SQL side of the equation when we were looking into upgrading our schools to SQL 2005. Others will doubtless have a better understanding of this aspect, and it might well turn out that Bromcom's interpretation of the Server CAL model is accurate.

    I am slightly surprised that Bromcom are adopting a model whereby they require each of their customers to purchase SQL CALs for their access to the product. Surely part of the net gains you get from hosted solutions is lowering overall infrastructure costs, so why not internalise the costs of the licensing and spread that cost out across your customer base. You would obviously then be purchasing the per-processor (which includes unlimited CALs) licensing model, which, as the userbase increases, clearly leads to significant savings on the overall licensing costs?

  12. #42

    Join Date
    Feb 2010
    Posts
    28
    Thank Post
    1
    Thanked 5 Times in 3 Posts
    Rep Power
    19

    CALs for Windows Server & SQL users

    Quote Originally Posted by SkywOrca View Post
    I'm slightly confused as to which licences we're discussing now, too, but I believe that as far as SQL CALs are concerned, you need a separate SQL CAL for each user that has write access to the database, no matter how they achieve that access. So the presumption that because the web service connects to the database via a single server they only need one CAL isn't correct. There's fine print in the licensing documentation that states that any ability for users to log into a system that connects those users directly to an SQL database with write access, even if that's a custom login function, then they're considered separate users and require a CAL.

    I personally didn't liaise with Microsoft on this, but a colleague of mine did, and after explaining the access model used by the Serco ePortal product (which uses an internal login authentication model) we were told specifically that this is covered by the licensing agreement and explicitly requires an SQL CAL to be purchased.

    As to how many Server 2003/2008 CALs you'd need to purchase, I'm not so sure. We were only concerned with the SQL side of the equation when we were looking into upgrading our schools to SQL 2005. Others will doubtless have a better understanding of this aspect, and it might well turn out that Bromcom's interpretation of the Server CAL model is accurate.

    I am slightly surprised that Bromcom are adopting a model whereby they require each of their customers to purchase SQL CALs for their access to the product. Surely part of the net gains you get from hosted solutions is lowering overall infrastructure costs, so why not internalise the costs of the licensing and spread that cost out across your customer base. You would obviously then be purchasing the per-processor (which includes unlimited CALs) licensing model, which, as the userbase increases, clearly leads to significant savings on the overall licensing costs?
    Yes, apologies. We seemed to have had crossed wires.

    Microsoft Windows Server CALs: Our understanding is as stated in our previous post.

    Microsoft SQL CALs: We beleive, SkywOrca's interpreation is correct. Each user needs an SQL CAL.

    However on the point of Bromcom's deployment model, main portal products are 'centrally hosted' and hence per-processor licensing model applies. These are MyChildAtSchool, Teacher'sWebFolder and Galaxy-VLE. For Hosted service for MIS per-processor based model is used. However we are finding that generally whilst primary schopols are OK, secondary schools are not keen to have their data off site. Speed and resilienece to broadband service level may also be consideration.

    The advantage of Bromcom MIS is that schools have a choice whether to have it on site or hosted. You may find that with the other browser based MIS software you do not have this choice.

    .

SHARE:
+ Post New Thread
Page 3 of 3 FirstFirst 123

Similar Threads

  1. SIMS Upgrade
    By laserblazer in forum MIS Systems
    Replies: 15
    Last Post: 9th December 2009, 03:10 PM
  2. [CLOSED] Layout Issue: Forced To Use 'Quick Reply'
    By DaveP in forum EduGeek.net Site Problems
    Replies: 5
    Last Post: 19th January 2009, 02:23 PM
  3. Forced Shutdown Schedular
    By Gatt in forum New Project Ideas
    Replies: 7
    Last Post: 11th June 2008, 12:20 PM
  4. SIMS August upgrade.
    By User3204 in forum MIS Systems
    Replies: 1
    Last Post: 20th August 2007, 08:14 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
  •