Unable to connect with the MSSQL Server

[jainam-patel-qa-ak]

Below is in my mcp.json file:

"sqlserver": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@executeautomation/database-server",
"/home/jainam/.nvm/versions/node/v22.19.0/lib/node_modules/mssql-mcp-server/dist/index.js",
"--sqlserver",
"--server", "localhost",
"--port", "number",
"--database", "dbname",
"--user", "username",
"--password", "PWD"
]
}

I am running statement "
Query all the details from the table and list it in tabular format" Agent GPT4.1 but it shows error
"Your MCP server configuration is correct, but the error "No connection string provided and no default connection string configured" still persists when running queries from VS Code/Copilot Chat."

Also note: It runs the server if I do on the terminal