Embedded SQL Server 2008 Workgroup license mobility

Peter Mikula
Peter Mikula used Ask the Experts™
on
We have an application (GoldMine 2014) that came with SQL 2008 Workgroup. We need to move this server to AWS EC2 instance. My understanding is that in general with standalone SQL license you can only to do it if you have Software Assurance. We of course don't have it as it came with the software. Have you guys seen situation where it was eligible to use embedded SQL DB in the cloud? Please don't ask me to call MS and ask them, as asking 3 diff MS reps may give me3 diff answers. I'm just asking what have you seen in real world scenarios

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
A few things:
  • GoldMine didn't bundle SQL with version 2014 -- the last time they bundled SQL was version 9, I think.
  • SQL 2008 is the oldest version of SQL listed as usable for GoldMIne 2014.  
  • If you're still under maintenance, you could speak to GoldMine support about your SQL license and potentially take it with you to your cloud server.
  • If your new server is Windows 2012 or newer, you may have trouble installing SQL 2008 (not R2)
  • You could always use SQL 2014 Express (free) on your new platform, unless your user/activity levels in GoldMine dictate otherwise.

Author

Commented:
Thanks!

My GM consultant (she's been doing GM for many years) said SQL 2008 came with their GoldMine 2014, would have to double check
SQL 2008 is officially supported on 2012 R2 but has to have SP3, but I can see there could be potential issues
The main DB is 25GB so SQL Express won't cut it

Thank you
I've been doing nothing but GoldMine since 1997 when I worked for GoldMine tech support and was later on the development team.

You're right, my mistake, 2008 w/sp3 is supported on windows 2012.  For some reason I was remembering that it required SQL 2008 R2.  

I believe GoldMine stopped shipping MSSQL licenses in October of 2013.  

My records show them shipping MSSQL 2008 R2 with version 9.0 and version 2013 of GoldMine.  

I don't believe they shipped SQL with any version of 2014.  

You'd want to dig up your original "Delivery Note and License Certificate" from Frontrange, however, to see what version you received.

I suspect you probably received SQL 2008 with GoldMine 8.0 (or 8.5) and subsequently updated your GoldMine version under maintenance.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Doug, thanks for your insight. That's my suspicion they had older version of GM then upgraded GM to 2014. Previous IT guys is gone and we trying to figure this out

Thx!
Check in with GoldMine/HEAT if they're still current on maintenance.  If the SQL license originally came from them, they may be able to supply  the serial so you can migrate it (along with your GoldMine) to the new server.

Author

Commented:
the client is not on support anymore, but the rep said the would not be able to provide a license key, we need to have our original CD, which we are looking for now :-)
If I'm not mistaken, they distributed the same original installation media to everyone.  Your GoldMine Partner ought to be able to supply a copy.

Author

Commented:
I will ask

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial