[Bug]: My SQL Database project failed to connect SQL Server Database

[BobCF]

Description

I created a SQL database project in VS Code with the SQL Database projects and SQL Server extensions. I can connect and operate my SQL Server in the CONNECTIONS tab like the picture below, but I can't extract the object/schema from the database to my SQL database project or do the schema comparison. The error message is "login failed...". The login account is only in the Database scope, not in the master.

I'm not sure if this issue is the extension bug or how I can resolve it. Thanks.

Steps to Reproduce

1. Add a new connection in the CONNECTIONS tab.
2. Right-click the new connection and select the "Create Project from Database"
3. Get notification "login failed for user xxxxx"

Affected Area

• Connection dialog (SQL Server | Azure browse/Fabric browse)
• Query editor
• Query results panel
• Object Explorer
• GitHub Copilot integration
• Preview/Edit data
• Table Designer
• Schema Designer
• Schema Compare
• Local SQL Server Container provisioning
• SQL database in Fabric provisioning
• DACPAC/BACPAC export/import
• SQL Database projects
• Query Plan Visualizer
• Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

VS Code Version: 1.107
SQL Server(mssql) extension Version: 1.38.0
SQL Database Projects Version: 1.5.5
Operating System: win11
Connection Type: SQL Server 2019

Confirmation

• I have searched existing issues and couldn't find a match
• I want to work on this issue

[BobCF]

I tried to use SQL Database Project in Visual Studio 2019, it works fine.
So I think this should be the VS code extension bug.