Skip to content

SQL Server

SQL Server Driver

Use the SQL Server driver when you want T-SQL querying, schema browsing, and DBeagle’s shared results workflow against Microsoft SQL Server.

Default connection fields

FieldDefaultDescription
HostRequiredSQL Server host
Port1433Standard SQL Server port
DatabaseOptional but recommendedDefault database
SchemaOptionalDefault schema, commonly dbo
UserOptionalSQL Server user name
PasswordOptionalStored in VS Code SecretStorage
Use encrypted / TLS connectionfalseTurn on when required by your server
Trust server certificatefalseDevelopment fallback for untrusted TLS chains
Max pooled connectionsDriver defaultOptional pool cap
TimeoutInherits global defaultPer-connection timeout override in seconds
  • Set the default database and schema so table preview and autocomplete open in the right place.
  • Turn on TLS for normal secured environments.
  • Only turn on Trust server certificate when you explicitly trust the endpoint but cannot validate its certificate chain locally.

How SQL Server appears in DBeagle

SQL Server maps neatly into the shared DBeagle metadata model:

  • database
  • schema
  • table or view
  • column

Notes

  • DBeagle supports SQL Server-specific preview syntax under the hood.
  • You can work in mssql, tsql, or generic sql editors.

SQL Server connection form