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.