A reader hit Error 18456, Severity: 14, State: 6 while logging in. Here is what state 6 means and how to fix this login failed error.
Linked Server to PostgreSQL: Set It Up From SQL Server 2025
A linked server to PostgreSQL lets SQL Server read PostgreSQL tables through an ODBC driver. This post tests the PostgreSQL side on PostgreSQL 18.6, runs the SQL Server steps up to the missing driver, and shows the real error messages.
Exporting and Sharing Registered Server Groups in SSMS
One shared server list can save you from running a query on the wrong server. Here is how to build it, export it without passwords and use it.
Reading Connection Details in Code: APP_NAME, HOST_NAME and Logins
An audit row blamed the wrong machine because a label was treated as proof. Here is which connection values you can trust, and which you cannot.
Connection Retry Logic for Cloud Databases
Connection retry logic handles transient cloud database faults through bounded backoff, safe transaction retries, and driver connection resiliency.
Connect to MySQL From the Command Prompt: Host, Port, User
To connect to MySQL from the command prompt, you pass a host, a port, a user and a password to the mysql client. This post runs every switch, then shows the exact error that a wrong port, user, password or database produces.
Counting Current Connections by Login, Host and Application
Try counting current connections by login, host, application and database, then inspect sleeping transactions and save a baseline.