![]() This also might be a behaviour of some add-in, that got corrupted after upgrade. If not - delete newly generated "11.0" and rename "11.0_" back to "11.0". Now start SSMS - it will re-create clean settings and maybe your problem will be solved. Rename it to "11.0_", so you can always rename it back. There is a brutal way to "reset" user-defined settings of SSMS.Ĭlose SSMS, go to folder: C:\Users\YOURWINLOGINNAME\AppData\Roaming\Microsoft\SQL Server Management Studio\ It might have happened that SSMS has imported settings that can not be treated correctly anymore (like connections to some server or maybe some add-in settings). (See above mentioned blogs 1 and 2 for details) You can configure IE to no longer "Check publisher's certificate revocation" in the advanced settings. You can configure your (company's) firewall to send a timeout faster to your client for requests accessing Microsoft's CRL. ![]() You can reconfigure your personal antivirus/firewall to allow connections to the Microsoft CRL ![]() You can reconfigure your (company's) firewall to allow connections to Microsoft's CRL You can circumvent part of the issue, by downloading the certificate directly be entering the link into your browser and then importing the certificate to your certificate database Reference: SQL Server Management Studio Startup Time (MSDN Blog) Solutions Depending on what features are installed, this can add up to a minute of startup time for Management Studio. Each certificate check has a 15 second timeout in the. NET framework can’t access the website to verify that the digital signatures used to sign the binaries for managed applications are valid. One issue that can cause this problem is that if the server does not have access to the internet, then the. Reference: FAQ, Why does SSMS take 45s to start up? (MSDN Blog) If there is no internet connection or there is a problem contacting the certificate revocation list server then this will delay SSMS startup. Net Runtime tries to contact 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). At start up (if this setting is checked) the. SSMS has a high percentage of managed code, all of this code is signed when we ship it. This slows down the overall loading procedure. NET components of SSMS are trying to contact the Certificate Revocation List and SSMS is unable to do so. When Microsoft's SQL Server Management Studio (SSMS) starts it tries to connect the Certificate Revocation List (CRL) of Microsoft: ![]() I don't have the opportunity to install the SQL Server 2012 CU1 update because there seems to be some risk of errors installing hotfixes and I can't risk that right now. It looks like SSMS is waiting for something - I can operate other programs smoothly while this is happening. My hardware should definitely not be a problem. My computer should be more than fast enough, and I also have 16GB RAM.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |