💾
Install & Update SSMS
SSMS is no longer part of the SQL Server installer, and the update model changed. Where to actually get it and how updates work now.
👤
Open SSMS as a Different Domain User
Testing permissions for a new AD login, or connecting under a service account, without logging into Windows as that user.
🔒
Fix the Certificate Chain Trust Error
Newer SSMS versions default to encrypting connections and validating the server certificate. Here’s what actually broke and the real fix.
📋
Show Line Numbers
On by default in current SSMS, but worth knowing where the setting actually lives if it’s ever off.
✂️
Fix Truncated Results in SSMS
Results to Text silently cuts columns off at 256 characters by default. Raise the limit before you mistake a truncated value for the real one.
Which One You Need
- Fresh machine or SSMS won’t update: start with Install & Update.
- Suddenly can’t connect after an SSMS upgrade: it’s almost always the certificate chain trust error.
- Need to test as another account: Open as a Different Domain User.
- A query’s output looks cut off, or you can’t see something you expect in Results to Text: the 256-character limit.
Related
For connection-level encryption and protocol settings (not SSMS-specific), see Check SQL Server Connection Encryption and Protocol.
Leave a Reply