Builtin\administrators removed on SQL Server Ubuntu instance

Question

question

karthik.kulkarni asked Feb 18, '22

Hi ,

i happened to remove Builtin\administrators from a SQL Server ubuntu instance.

i have couple of issues i can notice, unable to read error log, cannot send email from sql server mail.

Is there any way we can add back this user? Thanks in advance for consideration.

Regards,

Karthik Kulkarni

sql security

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2022-02-19T07:40:08Z

anthony.green answered Feb 19, '22

Do you have any other account with sysadmin rights to SQL Server. Like the SA account or goven

If so you can add it back in quite easily.

Otherwise usually on windows you set the service to start with the -m switch and you then can add it back in and restart SQL removing the -m switch.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

karthik.kulkarni · Feb 21 at 11:10 AM

Hi Anthony,

Thank you for your advice. The user is dropped on a sql instance installed on ubuntu system not on windows.

So i am facing it difficult to add back the user.

Regards,

Karthik Kulkarni

0 ·

anthony.green karthik.kulkarni · Feb 22 at 07:49 AM

Appreciate you’re in Linux but the first part of my answer remains.

If you have the SA login or some other sysadmin login you can re-add the BUILTIN\Administrators simply by re-creating it.

If not you should still be able to add the -m switch to the systemctl command to manually start SQL on Linux

systemctl start mssql-server -m

0 ·