Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This is not the answer to all occurences of the issue but try the following;
Now try SSMS again, was it faster? Either way re-check the setting to be safe.
Ok so here is what is happening. SSMS has a high percentage of managed code, all of this code is signed when we ship it. At start up (if this setting is checked) the .Net Runtime tries to contact crl.microsoft.com to ensure that the cert is valid(there were some fake certs issued in Microsoft's name a while back so this is a very valid concern). If there is no internet connection or there is a problem contacting the certificate revocation list server then this will delay SSMS startup.
Now this problem is not unique to SSMS, it actually applies to all managed code and flipping the switch switches off this check for ALL managed code on the machine which may not be a good idea, but at this time I don't know of a way to switch off the check on a per app basis, there are some folks looking however.
There have been several internal discussions on this and some external ones as well.
Anonymous
July 12, 2006
That helped. That really did. Thx a lot, Euan
Anonymous
July 13, 2006
Does anyone know the location of this setting in IE7? I couldn't find any options with that wording.
Anonymous
July 16, 2006
In IE7 it is under the Internet Options Advanced tab. Scroll down to the Security section.
It is still listed as “Check publisher’s certificate revocation”.
Anonymous
July 19, 2006
The comment has been removed
Anonymous
July 19, 2006
Quick fix that works...
add to your host file the following lines
# entry to get around diabolical Microsoft certificate checks
# which slow down non internet connected computers
127.0.0.1 crl.microsoft.com
Anonymous
September 10, 2006
The comment has been removed
Anonymous
November 13, 2006
It works!!! great!
Anonymous
January 31, 2007
I just bumped into an interesting article on Euan Garden's blog on how to boost the startup of SSMS.
Anonymous
July 28, 2007
This issue is covered pretty well by blogs in the context of SSMS ( Dan Jones and Euan Garden ) and in
Anonymous
July 28, 2007
This issue is covered pretty well by blogs in the context of SSMS ( Dan Jones and Euan Garden ) and in
Anonymous
September 20, 2007
PingBack from http://maassql.wordpress.com/2007/09/20/sql-server-management-studio-slow/
Anonymous
October 01, 2007
If you miss Query Analyzer you can still vote on the Connect site for this tool: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=297428&wa=wsignin1.0
Anonymous
March 07, 2008
PingBack from http://furrukhbaig.wordpress.com/2008/03/07/ssms-slow-startup/
Anonymous
September 27, 2008
Like many of you, I find that working in SSMS is a joy, compared to Query Analyzer. Like many of you, I miss things like CTRL B to move the splitter bar between the query window and the results pane, and I've moved on to just using CTRL R to get rid of
Anonymous
October 27, 2008
As part of my work I have to manage quite a few SQL Server 2005 installations. Some servers I was able
Anonymous
November 13, 2008
PingBack from http://michaelellerbeck.com/2008/11/13/sql-2005-managment-console-is-really-really-slow-fix/
Anonymous
January 18, 2009
PingBack from http://www.keyongtech.com/2243897-slow-browsing-to-select-file
Anonymous
May 20, 2009
FAQ,WhydoesSSMStake45stostartup?终于找到原因了,该描述来自EuanGarden的Blog(FAQ,WhydoesSSMStake45s...
Anonymous
May 29, 2009
PingBack from http://paidsurveyshub.info/story.php?title=euan-garden-s-blog-faq-why-does-ssms-take-45s-to-start-up
Anonymous
May 31, 2009
PingBack from http://hammockstandsite.info/story.php?id=380
Anonymous
April 06, 2016
That helped. That really did. Thx a lot, Euan
Anonymous
September 12, 2018
I can boot and log into my Surface Pro 4 faster that SSMS will take to get to the log on screen, highly irritating and time consuming for anyone who spends a lot of time managing SQL instances!
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in