Azure SQL DB connection string is not working unless logged in to azure account

I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:

Driver={ODBC Driver 13 for SQL Server};,1433;Database=erp_system;Uid=ahmed_ayman@01electronics;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

however, my app can't connect to the database until I login into my azure account from Microsoft SSMS, this seems too irrelevant for me as my app is intended to be used by 100 employees in my firm, and it is unpractical to obligate them to create an azure account and to login every time before using the app. Am I missing something here?

0 answers