MSSQL MCP: SQL Authentication in Node

[lionel-addvanto]

Is there a way to enable the SQL Authentication in the Node version for the MSSQL MCP? Instead of Over Entra?

[niklaskallander]

I had Github Copilot fix it for me, which worked great! However, I now have to put my sql authentication credentials in the mcp server config file, which is sub-optimal.

My prompt:
This is an MCP server that provides tools for connecting to an MS SQL Server database and perform various actions on it. It currently only seem to support azure entra and azure sql db. Can we modify it to support a local database server instead?

This removed the current support for Azure Entra and Azure Sql, not quite what I wanted but it works for me as I don't use any of that anyways. YMMV.