ms_sql_server resource with integrated auth
Hi, i just tried using integrated auth (not a sql login) against our SQL Server, and got this error: "ExecutionErr: execution error:
Error: Token error: 'Login failed for user ''.' on server <SERVERNAME> executing on line 1 (code: 18456, state: 1, class: 14) @mssql_executor.rs:198:43"
the windmill worker is already running under that service user account that should have access to SQL Server, but i guess we cannot have empty user/password when using ms_sql_server resource, am i right?
if that's not the case, then let me know what did i miss here... however, it works fine from a Python script using
Error: Token error: 'Login failed for user ''.' on server <SERVERNAME> executing on line 1 (code: 18456, state: 1, class: 14) @mssql_executor.rs:198:43"
the windmill worker is already running under that service user account that should have access to SQL Server, but i guess we cannot have empty user/password when using ms_sql_server resource, am i right?
if that's not the case, then let me know what did i miss here... however, it works fine from a Python script using
pyodbc
