Description

I have connections that are defined at the workspace level, for two use cases:

1. Containerized, where the container is in the workspace,
2. Remote, where all developers share common settings for our shared databases

So, in two different projects, I would like to define connections at the workspace level.

Currently, I can't get this to work, and I believe the problem is the addition of the new mssql.connectionGroups setting, which seems to be ignored at the workspace level.

Steps to Reproduce

If I define a structure like this:

    "mssql.connectionGroups": [
        {
            "name": "Remote",
            "id": "2E7E979B-0158-4352-989F-79205680C156"
        }
    ],
    "mssql.connections": [
        {
            "server": "127.0.0.1,14002",
            "database": "CoreDevDcaldwell",
            "authenticationType": "SqlLogin",
            "user": "CoreDevDcaldwell",
            "password": "",
            "emptyPasswordInput": false,
            "savePassword": true,
            "profileName": "CoreDevDcaldwell",
            "encrypt": "Mandatory",
            "trustServerCertificate": true,
            "connectTimeout": 15,
            "commandTimeout": 30,
            "applicationName": "vscode-mssql",
            "groupId": "2E7E979B-0158-4352-989F-79205680C156",
            "id": "FE195C16-9F90-474D-BA7F-078804F74996"
        },

Then, even though the mssql.connectionGroups is defined right above it, and is not defined at the user level, I get messages in the log (with tracing Verbose) like:

[7:46:39 AM] [ConnectionConfig] [Warning]: Connection 'CoreDevDcaldwell' with ID 'FE195C16-9F90-474D-BA7F-078804F74996' has a group ID that does not exist (2E7E979B-0158-4352-989F-79205680C156) so it is being ignored.  Correct its group ID to keep using this connection.

Affected Area

• Connection dialog
• Query results panel
• Query editor
• Object Explorer
• Table Designer
• Schema Compare
• Schema Designer
• Local container
• GitHub Copilot integration
• Query Plan Visualizer
• Other (please describe below)

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

Cannot define connections at the workspace settinglevel, must be defined manually at the user level.

Environment Information

VSCode 1.102.0
MSSQL extension 1.33.0

Confirmation

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