SQL Server connection string builder & parser
Build an ADO.NET connection string (and JDBC URL) from fields, or paste one to parse it back.
ADO.NET (Microsoft.Data.SqlClient)
Server=tcp:localhost,1433;Database=mydb;User ID=sa;Encrypt=True;
JDBC URL
jdbc:sqlserver://localhost:1433;databaseName=mydb;user=sa;encrypt=true;
Runs in your browser. Nothing you type is sent anywhere.
How this works
- ADO.NET (Microsoft.Data.SqlClient) uses semicolon-delimited Key=Value pairs: Server, Database, User ID, Password, Integrated Security, Encrypt. docs ↗
- JDBC form: jdbc:sqlserver://server[\instance][:port];property=value;... docs ↗
- A named instance is addressed as server\instanceName; a custom port takes precedence over an instance name if both are set.
Do this against your live database in Tablyne.
SQL Server GUI →FAQ
Should I use a username/password or Integrated Security? +
Microsoft recommends Integrated Security (Windows authentication) over embedding a password whenever it's available.
What's the default port? +
1433 for the default instance. A named instance without an explicit port resolves via the SQL Server Browser service instead.
Why does my password with special characters break the connection string? +
ADO.NET escapes values containing spaces, semicolons or quotes by wrapping them in braces, e.g. password={p;w}. This tool assumes passwords without those characters — wrap yours in braces manually if needed.