I used the official tutorial to create a default instance https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu
but now I want to create a named-instance and can't find how to do that
Open the SQL Server Configuration Manager, click on SQL Server Services and double click on SQL Server (MSSQLSERVER). Go to Service tab and you will get the instance name from here, as per below screenshot.
The following steps install the SQL Server command-line tools: sqlcmd and bcp. Import the public repository GPG keys. Register the Ubuntu repository. Update the sources list and run the installation command with the unixODBC developer package.
SQL Server on Linux doesn't support the notion of "multi-instance", so there are no named instances on Linux.
You can see that its Windows only feature here: https://docs.microsoft.com/en-us/sql/sql-server/install/work-with-multiple-versions-and-instances-of-sql-server?view=sql-server-ver15
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With