For most SQL db servers, the "per processor" licensing is the appropriate choice - even though it is expensive. Otherwise, each of your users with EM will need a CAL. Initially, that's not bad, but it gets expensive pretty quickly. Plus the Web server needs enough CALs to cover concurrent connections - which can also be prohibitive.
-mk -----Original Message----- From: Peter Janett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 11:09 AM To: CF-Talk Subject: What SQL 2000 version do I need? I find Microsoft's licensing setup on MS SQL server 2000 VERY confusing. I just want to run SQL 2000 with CF MX Pro. I thought I could get a Standard Edition, with 5 CAL, but I'm not sure. The setup is 2 single processor Windows 2000 boxes, one for the DB, one for the web server. Currently this is for just the one client, but I can see moving to a dual processor box in the future, and having a lot of virtual hosts, who I'd want to have Enterprise Manager access. Do I need a different license if I move from single processor to dual processor? Is the 5 client license for users in the system that can connect via Enterprise Manager and/or for CF MX to connect? Is that 5 concurrent users, or 5 SQL 2000 users? What if I setup system accounts instead of SQL users? Any and all help, experience, or ideas very much appreciated. Thanks, Peter ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

