I'm not able to connect (SQL authentication) to a sql server database in which the login suser_sname() and the database user user_name() is not the same. In my case the login is mapped to dbo user.
Error:
_duckdb.InvalidInputException: Invalid Input Error: MSSQL connection validation failed: Authentication failed for user 'xxx' - check username and password
I'm able to connect to another database in the same sql server instance. In that case login and user are the same.
I'm not able to connect (SQL authentication) to a sql server database in which the login
suser_sname()and the database useruser_name()is not the same. In my case the login is mapped todbouser.Error:
_duckdb.InvalidInputException: Invalid Input Error: MSSQL connection validation failed: Authentication failed for user 'xxx' - check username and passwordI'm able to connect to another database in the same sql server instance. In that case login and user are the same.