Connections by protocol tell you whether a client reaches SQL Server through shared memory, TCP or a named pipe, and from which address. This post reads the connection view for your own session, connects three ways to see each protocol, lists every connection with its host and program, and counts them by protocol.
Connection Strings Explained: Encrypt, TrustServerCertificate and Timeouts
Explain TrustServerCertificate, encryption modes, connection and command timeouts, listener failover, and server-side connection evidence.
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.
Listing Driver, Encryption and Auth Scheme for Every Connection
Inspect the auth scheme, encryption, driver interface, and protocol for current SQL Server connections, then group the results clearly.
Fix Error 3637: Backup Fails on a DAC Connection
To fix error 3637, find out why your backup runs on a dedicated administrator connection. This post reproduces the message with sqlcmd and its -A switch, shows the same backup working on a normal connection, and lists where a DAC hides in scripts and scheduled tasks.
SQL SERVER – FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop
SSMS on my laptop could not connect to SQL in Azure Virtual Machine, even though it worked fine on the VM itself. Here is how I fixed the connection.
SQL SERVER – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.
None of the maintenance plans worked, though the jobs ran fine. The error was failed to acquire connection “Local server connection”. Here is why.