Skip to content

How to Speed up SQL Management Studio

If you have a SQL environment behind a locked down firewall, you may notice that it takes SQL Management studio a long time to open up. The reason for this is that SQL Management Studio performs a certificate check against a US certificate authority before loading the application interface.

A way to drastically speed up this load time is to disable this certificate check. You can do this by saving the following to a .vbs file, and running it on the system where you have SQL Management Studio installed;

const HKEY_USERS = &H80000003 
strComputer = "." 
Set objReg=GetObject("winmgmts:{impersonationLevel=impersonate}!" & strComputer & "rootdefault:StdRegProv") 
strKeyPath = "" 
objReg.EnumKey HKEY_USERS, strKeyPath, arrSubKeys 
strKeyPath = "SoftwareMicrosoftWindowsCurrentVersionWinTrustTrust ProvidersSoftware Publishing" 
For Each subkey In arrSubKeys 
objReg.SetDWORDValue HKEY_USERS, subkey & strKeyPath, "State", 146944