[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL Server 2008 Workstation R2, use or not

Posted on 2012-04-11
1
Medium Priority
?
430 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 6

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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
I’m willing to make a bet that your organization stores sensitive data in your Windows File Servers; files and folders that you really don’t want making it into the wrong hands.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Suggested Courses

590 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