When you first install SQL Server 2012 and try to open Management Studio, it can take up to a minute to open. Why? The answer is, Management Studio has to contact crl.microsoft.com to check for certificate revocations. It can take longer if it can't make that connection, because of no internet access. To get around this, do the following:
1. Close SSMS
2. Open Internet Explorer
3. Go to Tools->Internet Options (or Internet Options from the control panel)
4. Go to the Security node and uncheck "Check publisher's certificate revocation"
5. Click OK and close Internet Explorer
SSMS should now open much faster. However, be cautious using this as any application that uses managed code may be at some risk. In the past, there were some fake MS certificates floating around.
1. Close SSMS
2. Open Internet Explorer
3. Go to Tools->Internet Options (or Internet Options from the control panel)
4. Go to the Security node and uncheck "Check publisher's certificate revocation"
5. Click OK and close Internet Explorer
SSMS should now open much faster. However, be cautious using this as any application that uses managed code may be at some risk. In the past, there were some fake MS certificates floating around.
No comments:
Post a Comment