Kath Pelletti
kp at sdsonline.net
Tue Jul 4 18:52:34 CDT 2006
That's a huge help - thanks William. Kath ----- Original Message ----- From: William Hindman To: Access Developers discussion and problem solving Sent: Tuesday, July 04, 2006 11:09 PM Subject: Re: [AccessD] Cost SQl Server Kath ...I asked what their Server OS was and you replied Windows XP Pro which implies that they are networked using the workgroup features of Windows XP Pro and thus don't have a Server in the classic sense. SQL Server is very CPU and resource intensive and needs to be placed on a real network server, not a shared workstation. ...in that light I recommend Windows Small Business Server Premium as configured below: Windows Small Business Server 2003 R2 Premium ONLSA w5 CAL 1 each P/N T75-00144 $1950 (Open New License with Software Assurance) 5-pack CAL ONLSA 2 each P/N T74-00186 (User) $690 Total: 1950 + 690 + 690 = $3330 ...the part numbers are essential to getting the right version ...I included Software Assurance pricing so that your client will get the Windows Server 2007/8 release without having to pay for it all over again ...the R2 spec is essential to get the SQL Server 2005 version rather than the SQL Server 2000 included in the original and R1 releases. ...the 5 CALs are included w/SBS ...additional CALs are sold in 5 or 20 CAL packs ...they are sold as Device or User CALs ...device cals being useful in shift work where 2 or more workers use the same workstation at different times ...device cals are user name specific but can be installed on every device, the most common being a user with an office workstation, a home workstation, and a laptop ...a single user cal covers all three client installs for the same user. __________________________________________________________ ...if you require ONLY SQL Server itself, it comes in two applicable editions now as follows: SQL Server Workgroup Edition w/Server CAL $730 Workgroup User Cal 15 each $146 Total: 730 + 2190 = $2920 __________________________________________________________ SQL Server Standard Edition w/Server CAL $885 Workgroup User Cal 15 each $162 Total: 885 + 2430 = $3315 ...the major difference for your size customer lies in the additional reliability features of the Standard edition vs. the pure db features of the Workgroup edition ...you'll have to look at the comparison charts to determine which you feel comfortable with ...the SBS at the top comes with the Standard edition ...as you can see, the pricing of the SBS Premium edition is virtually identical to that of SQL Server Standard by itself ...which is one reason why all of my clients are on SBS. ...the prices cited are from the MS site and are MSRP ...you can certainly do better but be careful who and what you buy ...OEM versions are cheaper but get zero support from MS (and you WILL need it) ...Open License pricing is more expensive but more than pays for itself the first time you get a version upgrade ...e-bay has hundreds of items in this category for sale at much better prices but you can get badly burned if you're not very careful ...probably 60% of them are illegal and MS claims its as high as 80% ...they can get away with this by pirating enterprise license numbers and selling you copies ...it installs and upgrades fine until MS finds that the license number has been pirated and then shuts your client down ...if your client decides to go with a new server, I use Dell because it simplifies my life and my clients' ...you get better pricing and Dell will provide your software support ...and Dell won't try to take your client away as some MS Open License Dealers are wont to do. ...note that this is my opinion and my experience ...others may certainly differ :) ...hth William ----- Original Message ----- From: "Kath Pelletti" <kp at sdsonline.net> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Tuesday, July 04, 2006 2:06 AM Subject: Re: [AccessD] Cost SQl Server > The no. of users is between 5 and 15. They are currently using Windows XP > Pro. > > I understand that Express is an option but I want to know the cost of full > MS SQL as well. > > Kath > ----- Original Message ----- > From: William Hindman > To: Access Developers discussion and problem solving > Sent: Tuesday, July 04, 2006 3:01 PM > Subject: Re: [AccessD] Cost SQl Server > > > ...what specific Server OS are they currently using and how many > concurrent > users? > > ...SQL Server Express is quite capable of serving as a be to an Access fe > in > many environments but you have to understand its limits ...but its free > if > those limitations don't limit your application. > > ...SQL Server 2005 comes packaged or stand alone ...if you purchase Small > Business Server 2003 Premium, its included at a very steep discount to > the > stand alone price. > > ...the costs mount in either route as you add user licenses. > > ...server processor and memory specs are much more important in a > client/server app w/SQL Server be than it is with an Access file/server > be. > > ...Windows 2000 or XP will work fine but support for earlier versions is > difficult at best ...the benefits of XP are, imnsho, more than sufficient > to > drive an upgrade ...unless they want to wait for Vista which will almost > certainly require workstation hardware upgrades as well. > > ...hth > > William > > ----- Original Message ----- > From: "Kath Pelletti" <kp at sdsonline.net> > To: "Access D Normal List" <accessd at databaseadvisors.com>; "Access D SQl > Server List" <dba-sqlserver at databaseadvisors.com> > Sent: Monday, July 03, 2006 11:20 PM > Subject: [AccessD] Cost SQl Server > > > > Can someone help me with some costs which I find confusing on the MS > site. > > > > I need to let a client know the costs of developing an app with SQL > Server > > as the BE as opposed to Access BE. > > > > I have all the development side clear but I need to quote them the cost > of > > them purchasing a license for SQL Server 2005, so that the users can > > access it across the network. > > > > And do they need to use a specific Windows version with SQL Server > 2005? > > > > TIA > > > > ______________________________________ > > Kath Pelletti > > Software Design and Solutions Pty Ltd. > > Ph: 9505-6714 > > Fax: 9505-6430 > > Email: KP at SDSOnline.net > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com