troubleshooting Question

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

Avatar of DailyDilemma
DailyDilemma asked on
Microsoft SQL Server 2008
2 Comments1 Solution309 ViewsLast Modified:
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.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros