AWS MSSQL Access from ClickHouse: Is Explicit Username and Password Required?

**Environment:**
clickhouse version: 25.3.3.42
clickhouse-odbc-bridge version: 25.1.5.31

**Config:**
(base) [root@us-test ~]# cat /etc/odbc.ini
[test]
Description=Test Database
Driver=ODBC Driver 17 for SQL Server
Server=ec2-42-113-145-151.us-west-2.compute.amazonaws.com
Port=1433
Database=test
UID=ck_reader
PWD=xxxx
Encrypt=no
Timeout=60
(base) [root@us-test ~]# cat /etc/odbcinst.ini
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.6.1
UsageCount=1

**Problem:**
When I specify the username and password, the query executes successfully.
us-test :) SELECT lastSyncTime FROM odbc('DSN=test;Uid=amazon-api;Pwd={m1K%Uz=8i5Ky%MRy}','dbo', 'btm') limit 1

SELECT lastTime
FROM odbc('DSN=test;Uid=ck_reader;Pwd={xxx}', 'dbo', 'btm')
LIMIT 1

Query id: c8300b67-f23a-4ad3-aa7b-000b8ab3e05f

┌────────lastTime─┐
1. │ 2025-10-15 17:09:59 │
└─────────────────────┘

1 row in set. Elapsed: 8.454 sec.

us-test :)

**But, When I execute the SQL query without specifying the username and password, an error occurs.**
us-test :) SELECT lastTime FROM odbc('DSN=test','test', 'btm') limit 1

SELECT lastTime
FROM odbc('DSN=test', 'test', 'btm')
LIMIT 1

Query id: c3bceb54-6816-41e8-9b95-9012da9a7a30

Elapsed: 9.620 sec.

Received exception from server (version 25.3.5):
Code: 86. DB::Exception: Received from localhost:9000. DB::HTTPException. DB::HTTPException: Received error from remote server http://127.0.0.1:9018/columns_info?use_connection_pooling=1&version=1&connection_string=DSN%test&schema=test&table=btm&external_table_functions_use_nulls=1. HTTP status code: 500 'Internal Server Error', body length: 271 bytes, body: 'Error getting columns from ODBC 'std::exception. Code: 1001, type: nanodbc::database_error, e.what() = contrib/nanodbc/nanodbc/nanodbc.cpp:1275: 28000: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user ''. (version 25.1.5.31 (official build))'
'. (RECEIVED_ERROR_FROM_REMOTE_IO_SERVER)

**Finally, thank you everyone!**