Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jon G
Starting Member
31 Posts |
 Posted - 2008-05-31 : 08:01:08
|
| Hi,I currently use SQL 2005 express advanced. I connect to it from approx 20 pc's simultaneously and all works well. Each "client" connects with the same user, therefore I have one user setup within SQL server and then all client pc's connect to the database with the same user and password. This works well.Owing to the database file size restriction of 4 gig, I now need to purchase full SQL 2005 Standard.My question is, if I buy SQL 2005 Standard with 5 CAL (client access licences) does that mean that I can no longer connect my 20 client pc's to the server at the same time, even though I am only actually logging in with 1 user only?Any help is greatly appreciated as I can't seem to get an answer to this question via microsoft at all, and a 20 user licence of full sql 2005 is beyond my budget.many thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-01 : 02:51:41
|
| You will need to purchase 20 user licenses in this scenario.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
Jon G
Starting Member
31 Posts |
Posted - 2008-06-01 : 10:19:36
|
| Thanks for your answer. I've just been doing some more research and actually a much cheaper alternative is Workgroup edition of SQL Server 2005 that enables unlimited database size and unlimited users. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-06-01 : 14:32:28
|
quote:
Originally posted by Jon G
Thanks for your answer. I've just been doing some more research and actually a much cheaper alternative is Workgroup edition of SQL Server 2005 that enables unlimited database size and unlimited users.
Workgroup Edition allows unlimited users, but you still need a CAL for user.Also, is had nothing to do with concurrent connections. Each user connecting needs a CAL.CODO ERGO SUM |
|
|
|
Jon G
Starting Member
31 Posts |
Posted - 2008-06-01 : 15:46:50
|
| Am I reading this wrong thenhttp://www.softwareselect.co.uk/Merchant2/merchant.mvc?Screen=PROD&Product_Code=101474&source=froogleQuoteWorkgroup Edition is the data management solution for small organizations that need a database with no limits on size or number of users. Workgroup Edition can serve as a front-end Web server or for departmental or branch office operations. It includes the core database features of the SQL Server product line and is easy to upgrade to Standard or Enterprise Edition. Organizations today face numerous data challenges, such as the need to make faster and more data-driven decisions, the need to increase the productivity and flexibility of development staff, and pressure to reduce overall information technology (IT) budgets while also scaling the infrastructure to meet ever-increasing demands. SQL Server 2005 is designed to help enterprises address these challenges. This next-generation data management and analysis solution delivers increased security, scalability, and availability to enterprise data and analytical applications, while making them easier to build, deploy, and manage. Extending the strengths of SQL Server 2000, SQL Server 2005 provides an integrated data management and analysis solution that can help organizations of any size to do the following: Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable. Maximize IT productivity by reducing the complexity of developing and supporting database applications. Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems. Control costs without sacrificing performance, availability, scalability, or security. SQL Server 2005 advances your data infrastructure in three key areas: enterprise data management, developer productivity, and business intelligence (BI). It also breaks new ground in affordable pricing and licensing, upgrade paths to SQL Server 2005, and the Microsoft Windows Server System. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-06-01 : 20:19:27
|
| Processor licensing is another option for SQL Server. However, that is only a license for a single processor, so if your server has two processor cores, you would need two licenses.For 20 users, it will probably be cheaper to buy a server license, and CAL licenses for the clients. If you decide to add another SQL Server, you will only need an additional server license. CAL licenses allow users to connect to an unlimited number of servers.CODO ERGO SUM |
|
|
|
Jon G
Starting Member
31 Posts |
Posted - 2008-06-02 : 02:57:27
|
| Thanks, this is starting to make more sense now. Very consusing to say the least.So, one further question.I have 3 separate applications running on the same client pc that all connect separately to the same SQL database.If one client pc is running all 3 applications at the same time, does this mean that the one client pc is now using 3 client access licences, or are the CAL's "per machine" and not "per connection for each application" ? |
|
|
|
|
|
|
|
|
SQL 2005 Standard with 5 CAL