A lightweight Windows Forms utility for testing MS SQL Server connection strings — by hand or in bulk from an appsettings.json file — and running ad-hoc queries directly from the UI.
- Windows
- .NET 10 SDK
cd SQLConnCheck
dotnet runOr build a self-contained executable:
dotnet publish -c Release -r win-x64 --self-containedPaste any MS SQL Server connection string into the Connection String box and click Test Connection. The result appears immediately below.
Data Source=.\SQLEXPRESS;Initial Catalog=MyDB;User ID=sa;Password=secret;
Click Browse appsettings.json, select a file, then click Test All. Every entry under the "ConnectionStrings" section is tested in sequence; a live summary updates as each result arrives.
{
"ConnectionStrings": {
"Default": "Server=localhost;Database=App;Trusted_Connection=True;",
"Reporting": "Server=rep-srv;Database=Reports;User Id=sa;Password=pass;"
}
}Type any SQL in the Query box and click Execute Query. Results are rendered as plain text with a pipe-separated header row, a separator line, and a row count at the bottom — no connection to a separate database tool required.
Id | Name | CreatedAt
--------------------------
1 | Alice | 2024-01-15
2 | Bob | 2024-03-22
(2 row(s) returned)
| Color | Meaning |
|---|---|
| Dark green | Connection succeeded |
| Dark red | Connection failed (error detail shown) |