See if What permissions/role needed for ignition to insert data to MSSQL table? - #4 by Transistor helps.