SQL Management Studio: Connect and Queries take so long

Robert Meyer 16 Apr 2018 Long Running Queries SQL Management Studio SQL Operations Studio Timeout permalink

When I connect to my local SQL Server using SQL Management Studio or SQL Operations Studio and want to execute queries, it sometimes takes several minutes to execute.

This setting in Internet Explorer’s Internet Options solved my problem:

  • Open Internet Explorer
  • Go to Tools -> Internet option
  • Open the “Advanced” tab
  • Uncheck “Check for server certificate revocation (requires restart)”