Multiple SQL Server instances on same server ?

Question

Hello, currently one of our teams has free version SQL Server Express instance on a server (believe it was automatically installed/bundled with 3rd party software).

They've reached the maximum 10 GBs limit and is thinking about installing paid SQL Server 2019 Standard on same server.

Sounds like they'll probably need to shutdown SQL Express and then install SQL 2019 Standard so only one SQL Server instance is running to minimize complications.

Heard usually rule of thumb is installing only one SQL Server instance on a server...is this still correct?

And if they do above like I describe (1 active SQL Standard instance & 1 stopped SQL Express instance) what are the concerns, risks, things to be aware of?

Thanks in advance.

Answer 1

a server can run multiple instances of sqlserver. the only issue is sharing resources. it would be best if they used different drives.

but you could just upgrade the edition. this just adds any missing software features and updates the license file. one of the selling points of sql express is the ability to update in place to a higher edition

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver16

this probably the best solution.

Answer 2

I see no reason in this case to install a second instance and having to deal with connection strings etc. Simply just to an edition upgrades; Express to Standard is a supported upgrade, see https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2019.

The only possible drawback is that if the instance name is SQLEXPRESS, it will remain SQLEXPRESS after the edition upgrade. This could possibly cause some confusion.

Answer 3

Also another consideration...is it possible to do an in place upgrade of existing SQL Express to SQL 2019 Standard and if yes what are the risks/concerns?

Thanks.

Answer 4

Hi @techresearch7777777 ,

Also, whether you choose to create a new instance or upgrade in-place, I'd like to remind you to make a backup of your data in case something happens. For detailed information about the license issue, you can 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. Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 5

Thanks bunch everyone for the quick supportive replies.

All were great helpful in brainstorming scenarios.