question

HeathRoberts-3255 avatar image
0 Votes"
HeathRoberts-3255 asked CarrinWu-MSFT commented

Upgrade path from small business server 2008 & what licenses do I need?

I have a small business with ~15 users who are using a "desktop" style PC as a server. It's running "small business server 2008" and is acting as a file server and a (Microsoft) SQL server. There's no domain controller. The SQL database is just over 8GB and is growing. We've been told there's a 10GB limitation on database size with this edition of SQL server and that we need to switch to standard before the database gets that large.

I'd like to move to Windows Server 2019 and SQL server 2019, but I'm having some difficulty figuring out which editions I need, how many CALs, and which licenses. The likely target hardware is a "server" type machine with two six-core processors.

I've been advised by the company who supplies the software that uses the SQL database that I should run the database on one virtual machine and the file server on a second one. If we do that, there's another desktop PC I'd also like to virtualize and run on the new server (it's access using RDP by a few people).

sql-server-generalwindows-serversmall-basic
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

Sounds like you'll need a Server 2019 Standard edition. If you plan to run hyper-v then Standard Edition provides rights for up to 2 Operating System Environments or Windows Servers containers with Hyper-V isolation when all physical cores in the server are licensed. For each additional 1 or 2 VMs, all the physical cores in the server must be licensed again.

As to SQL you can check some options here in case you can get by with SQL Express
https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-ver15

Windows CALs are for either user or device server access. Some info here on windows CALS
https://www.microsoft.com/en-us/licensing/product-licensing/client-access-license

For the desktop virtualization
Windows Virtualization rights
Windows Virtualization Rights allow for a licensed device or user to access virtual Windows desktops
either remotely and/or locally, depending on how the device or user is licensed. You can license
devices or users for Windows Virtualization rights in the following ways:
- License devices with Software Assurance for the Windows desktop operating system or Windows
VDA subscription on a per device basis via one of the following programs: Open License,
Select/Select Plus, Microsoft Products and Services Agreement, Open Value, Enterprise
Agreement, or Enrollment for Education Solutions.
- License users with Windows Enterprise E3/E5 subscription licenses or Windows VDA E3/E5
subscription on a per user basis via one of the following programs: Open License, Select/Select
Plus, Microsoft Products and Services Agreement, Open Value, Enterprise Agreement, or
Enrollment for Education Solutions.

I'd suggest discussing these options with your resellers trained licensing specialist or contact a Microsoft Partner
https://www.microsoft.com/en-us/solution-providers/home

--please don't forget to Accept as answer if the reply is helpful--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

For detailed information about the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @HeathRoberts-3255,

For SQL Server 2019 Edition, maybe you could chose Standard Server + CAL. Please refer to below illustration to chose SQL Server 2019 Edition:
83066-sql-server-2019-edition.png

There have 2 SQL Server 2019 licensing models, core-based licensing and Server+CAL licensing. It seems like you could chose Server+CAL licensing:
83029-licensing.png

Please download the Microsoft SQL Server 2019 Licensing guide from attachment to get more information. For License issue, we suggest that you can consult professionals in this area. Please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations. Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web. People there will help you more effectively.

83153-sql-server-2019-licensing-guide.pdf


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered CarrinWu-MSFT commented

Any progress or updates?

--please don't forget to Accept as answer if the reply is helpful--

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks--yes, some useful information here, and I will probably call MS for help determining which license products I need, but I still don't know if I can reasonably expect to pop in media for Server 2019 to upgrade the O/S, and media for SQL Server 2019 to update the database.

0 Votes 0 ·
CarrinWu-MSFT avatar image CarrinWu-MSFT HeathRoberts-3255 ·

Hi @HeathRoberts-3255, please get the STEPs of upgrading Windows Server 2008 R2 to Windows Server 2019 from this blog. And which version of SQL server do you used currently?

0 Votes 0 ·
DSPatrick avatar image
0 Votes"
DSPatrick answered

An in-place upgrade is never recommended and would be extremely risky. You couldn't upgrade directly any way which also adds another risk level.
https://docs.microsoft.com/en-us/windows-server/upgrade/upgrade-overview#which-version-of-windows-server-should-i-upgrade-to

I'd ask confirm here and with manufacturer about support for Server 2019
https://www.windowsservercatalog.com/

--please don't forget to Accept as answer if the reply is helpful--





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.