Keyword or statement option 'bulkadmin' is not supported on the 'Linux' platform


Question: I am getting SQL Server Error Keyword or statement option 'bulkadmin' is not supported on the 'Linux' platform.

Bulkadmin is not supported on Linux platform

TITLE: Microsoft SQL Server Management Studio
------------------------------

Add member failed for ServerRole 'bulkadmin'.  (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.46521.71+(SMO-master-A)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+member+ServerRole&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Keyword or statement option 'bulkadmin' is not supported on the 'Linux' platform. (Microsoft SQL Server, Error: 16202)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-16202-database-engine-error

------------------------------
BUTTONS:

OK
------------------------------


Login to See the Rest of the Answer

Answer: According to this Github Issue 4198, tejasaks commented that "Bulkadmin role is unsupported on Linux for the moment. Users require sysadmin privileges to perform bulk insert. If it is not documented today, we should document it."

In-conclusion, try granting sysadmin to the User you want the bulkadmin privilages to escalate to. I hope this helps you.







For peering opportunity Autonomouse System Number: AS401345 Custom Software Development at ErnesTech Email AddressContact: [email protected]