Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I create named-instance of Microsoft SQL Server on Ubuntu

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

like image 205
arielorvits Avatar asked Jan 17 '17 10:01

arielorvits


People also ask

How do I find my SQL Server name Ubuntu?

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.

How do I install Microsoft SQL Server on Ubuntu?

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.


1 Answers

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

like image 105
Sergey Avatar answered Oct 12 '22 20:10

Sergey