Unable to Connect to Azure SQL Server using ODBC Driver 18 for SQL Server with a "@" in my user name

[shadiqurrahaman]

I am encountering an issue when attempting to connect to my Azure SQL Server database using pyodbc and the ODBC Driver 18 for SQL Server on Ubuntu. Below are the details:

Environment

OS: Ubuntu
ODBC Driver: ODBC Driver 18 for SQL Server
pyodbc Version: 5.2.0
Python Version: Python 3.12.3

Connection Details:

Server: martins.database.windows.net
Database: Stage-MartinsPoint
Username: insightin-martinpoint@martins-point
Password: matins123

Issue

I am getting the error message

Connection failed: ('42000', "[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot open server 'martins-point' requested by the login.

I have tried to double cote like "insightin-martinpoint@martins-point" and also "insightin-martinpoint//@martins-point"

is there any way to fix this?

[WhiteWolf1776]

Is this a sql login or a microsoft "entra" account?

[shadiqurrahaman]

This is a SQL login