Click here to Skip to main content
15,896,063 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Dear ,

We are going to deploy one application in our client side which is mainly a .net Windows application and some part of it is web based application running on client intranet.

maximum users of application from windows based interface will be 20 and from web based interface , only 5 users will be accessing it.

We are buying first time SQL SERVER 2005 license so could you please guide me which version will be good (i believe 'SQL Server standard' will be ok) and what type of license we should buy?

thanks
Posted
Comments

1 solution

SQL Server licensing is really not easy. To be honest even Microsoft people tend to give different answers for the same scenario in some cases...
- You are giving money for 2005? Why?
- Depends also on the database size, what is the estimated maximal size? The free Express edition can be also a good option in some cases! Sql Express 2008 has a 10GiB limit. With 25 users this can be enough for years - well, depending on the application.
- To choose proper edition, you will need to compare editions and select the one that fits your needs: http://msdn.microsoft.com/en-us/library/ms143761(v=sql.90).aspx[^], but yes Std is good in most situations.
- The version is only one thing. Licensing is an other. You said you don't face the internet, only intranet. Than buying Server license and CALs is one option (you will need probably 25 CALs). Or you can buy processor based license. In case of fewer users, this is more expensive than buying CALs. Short overview: http://blog.sqlauthority.com/2008/02/23/sql-server-2005-understanding-licensing-model/[^]
 
Share this answer
 
v3
Comments
Maciej Los 26-May-13 14:26pm    
It's fair enough ;)
+5!
Zoltán Zörgő 26-May-13 15:15pm    
Thank you.
Maciej Los 26-May-13 15:39pm    
What you think about my comment?
Zoltán Zörgő 26-May-13 15:48pm    
That is why I also suggested Express edition. If the database size and cpu limit is no issue, and they don't need the agent, it is one fair alternative. But as versions 2008-2012 have 10GiB size limit, and not 4GiB as v2005, I see no actual use of the later one.
Maciej Los 26-May-13 16:11pm    
I think you need to underscore (or bold) this part of your answer because this is what OP looking for ;) (5 Web-users, 20 WinForms-users).
The best solution is a free solution ;)
That's why i gave you 5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900