Can we install MSSQL(2019) on linux with different user and group?

Hello @Mj Taseen & @Taseen, Mohammad ,

Unfortunately this requirement is not currently supported.

Can I change the ownership of SQL Server files and directories from the installed mssql account and group?

We do not support changing the ownership of SQL Server directory and files from the default installation. The mssql account and group is specifically used for SQL Server and has no interactive login access.

More details please refer to SQL Server on Linux Frequently Asked Questions (FAQ).
https://video2.skills-academy.com/en-us/sql/linux/sql-server-linux-faq?view=sql-server-ver15

Best Regards,
Cris

Hello CrisZhan,

Yes, I have followed the same document to install MSSQL on Linux. Let me rephrase my question.

Once after installation I could see by default all the files go under /var/opt/mssql. And could see there OS level user and group permissions by default comes as mssql(user) and mssql(group).

Now my question, Is there any option to change user and group name before installation or after installation of MSSQL on Linux?.

As we wanted to have change user and group information to fit to our standards.

[ mssql]# ls -ltr
total 16
-rw-r--r--. 1 mssql mssql 51 Oct 22 08:16 mssql.conf
drwx------. 2 mssql mssql 25 Oct 22 08:16 secrets
drwxr-xr-x. 2 mssql mssql 4096 Oct 30 10:09 data
drwxr-xr-x. 3 mssql mssql 4096 Nov 30 11:56 log

Regards,
Md. Taseen

Thanks for the info.

Hello Team,

When I did do MSSQL installation on linux. I could see we have another group with same id 989 on linux (Red Hat Enterprise Linux release 8.3).

Can you please provide us document or steps to have the group id changed during the installation process or after the installation process.

root@hosting :/# grep 989 /etc/group
<anothergroup>:x:989:
mssql:x:989:
root@hosting :/#
root@hosting :/#
root@hosting :/# cat /etc/red*
cat: /etc/redhat-access-insights: Is a directory
cat: /etc/redhat-lsb: Is a directory
Red Hat Enterprise Linux release 8.3 (Ootpa)

We could see the group name is showing different. Haven't shared the actual group name though here.

drwx------ 2 mssql <anothergroup> 25 Nov 6 05:35 secrets
-rw-r--r-- 1 mssql <anothergroup> 50 Nov 13 17:37 mssql.conf
drwxr-xr-x 2 mssql <anothergroup> 4096 Nov 17 18:17 data
drwxr-xr-x 2 mssql <anothergroup> 4096 Dec 1 13:11 log

Regards,
Md. Taseen

Yes, I do need to change the MSSQL group ID, I wanted to know if I change the group ID does it will have any consequences on MSSQL?