Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2008 Workstation R2, use or not

Posted on 2012-04-11
1
Medium Priority
?
427 Views
Last Modified: 2012-08-14
Hi!

I am developing a software with SQL Server as backend.

I am currently looking at the Workstation version of the 2008 R2 series.

When i am reading articles, they say it is for remote users? Is this version not suitable for local users on the network?

Why I choose this product is that it does contain all the neccesary items for my software and does not cost a fortune. They are only 15 users and they do not have loads of data to store.

The express edition is not an option since i need to use the Full Text serach etc and the size of the database could be large.

Any thoughts, etc are most welcome.

Regards
Martin
0
Comment
Question by:MrHswede
1 Comment
 
LVL 5

Accepted Solution

by:
Daryl Bamforth earned 2000 total points
ID: 37833044
Hi Martin,

This is a basic breakdown of the different SQL 2008 R2 editions
http://www.sqlmag.com/article/sql-server-2005-express/sql-server-2008-r2-editions

As long as you are happy that it does what you need it to then by all means use the workgroup edition.  There is no point paying for features that you are not going to need.

You will need to purchase additional CALs to go with it.

Forgot to mention.  The workgroup edition has been retired in the new 2012 version so you may have difficulty getting licenses for since it was released on the 1st of April.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
Suggested Courses

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question