Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL Server 2008 Workgroup - Do I Need a processor licence?

Posted on 2009-12-16
Medium Priority
Last Modified: 2012-05-08
I could run this question by Microsoft but I think they'll just tell me I need the full version, so I'd like an unbiased opinion.

I run a small SQL Sever 2005 Express database that has grown over the years and will shortly be used to store a lot of images of contracts that relate to the workorders it currently tracks. I could use the filestream option in 2008 express to tackle this, but filestream requires windows authentication and I KNOW my application does not work with windows authentication. I just didn't know what database security was about when it was written.

So.... to get past the 4GB limit I know I have to upgrade. Because this database is isolated on its own internal network security has never been much of a concern so the application signs in as the same generic user for all 50-75 people who use it.

Can I purchase a 5 user version of SQL Server 2008 Workgroup to upgrade since the only "users" signing into it are myself and the generic application user?

We will happily pay for a processor licence if that's the legitimate way to do it, it just seems to me that if I don't have a need to control the database security of everyone individually that I shouldn't have to pony up for the full processor version.

If someone could tell me 1) Would the 5 user thing even work and 2) Is attempting to use it that way legit, I'd appreciate the input.

Question by:DailyDilemma

Accepted Solution

BlackIce80 earned 2000 total points
ID: 26079727
According to Microsoft, you always need that number of licenses where there are "real" users.
So using only a 5 User license, because there is only one service user is a no-go for them.

I'm affraid you have to buy 50-75 CALs or a processor license for your server.

A little story to our licensing problematics:

Server A - collects data and builds a database and copies it to Server B.
Server B - is used in a website and users request data over the internet from the database.

They say we need a processor license for server B and A! because it's Database is indirectly used by an unlimited number of users when its copied over to server B.

Author Closing Comment

ID: 31667011
lol ya, if they say you need one for both they'd definitely have a fit if I used mine that way. Thanks.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

571 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