Richard Swinbank tells a tale of woe:
Migration day went pretty smoothly – it even looked like we’d found and amended every connection string likely to disable a downstream system. The instance from which we were migrating was a bit of a food court, so before signing off I opened SSMS to check on some other system issue… and found I could no longer log in.
Read on to understand why, as well as what Richard did to fix this.