SSMS-Schema-Folders
SSMS-Schema-Folders copied to clipboard
nicholas-ross
Install problem
Hi, I installed your extension in SSMS 2017. Also applied the registry fix, but nothing happens. There is a Schema Folders option under SQL SERver Object Explorer, but it gives: An error occurred loading this property page.
How can I debug this ?
Bas
Microsoft SQL Server Management Studio 14.0.17213.0 Microsoft Analysis Services Client Tools 14.0.1016.232 Microsoft Data Access Components (MDAC) 6.3.9600.17415 Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 9.11.9600.18921 Microsoft .NET Framework 4.0.30319.42000 Operating System 6.3.9600
This is usually caused by windows security blocking dll files downloaded from the internet.
After downloading, you need to right click on the zip file and go to properties. You should then see a button or tick box to unblock.
After unblocking you can then extract the files.
You can also unblock the individual dll files that you have already extracted. You can't unblock multiple files at once and need to do them individually, which is why I recommend unblocking the zip instead.
If this doesn't solve the issue then we will need to get the ssms log file.
I had this issue, too, and this fixed it. The relevant part of the installation instructions:
Depending on your web browser, you may need to unblock the zip file before extracting. Right click on the zip file and select Properties. If you see an Unblock button or checkbox then click it.
was confusing, because my browser (Chrome) also blocked the download, and I thought that kind of block was what this referred to. I suggest making it more clear that this should be done in Windows Explorer, after the file has been downloaded, something like:
You may need to unblock the zip file before extracting. Right click on the zip file in Windows Explorer and select Properties. If you see an Unblock button or checkbox then click it.
@cmullican Thank you for your feedback. I have updated the documentation with your suggestion. I am leaving the issue open because this is the most common issue.
I had the same issue. unblocking the zip file did not work for me. I had to unblock each file one by one. Since there are not that many files, I unblocked all of them one by one.
Deployed in two places (Win7 x86 and Win7 x64), and encountering the issue with one of the deployments. All files have been unblocked, but the issue still exists (on the x64 implementation). Schema nodes do not appear nor does the "Schema Folders" option appear (at all - not even a blank placeholder under "SQL Server Object Explorer")
UPDATE:
Nevermind - because my SSMS is x64, I needed to place the extension (folder) in:
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions ... instead of ... C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions
Leaving this note since it may help someone else.
Hi, I installed your extension in SSMS 2017. Also applied the registry fix, but nothing happens. There is a Schema Folders option under SQL SERver Object Explorer, but it gives: An error occurred loading this property page.
How can I debug this ?
Bas
Microsoft SQL Server Management Studio 14.0.17213.0 Microsoft Analysis Services Client Tools 14.0.1016.232 Microsoft Data Access Components (MDAC) 6.3.9600.17415 Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 9.11.9600.18921 Microsoft .NET Framework 4.0.30319.42000 Operating System 6.3.9600
Bas did youfind a fix for this issue? Think the other are a bit confused about the problem. Problem is not related to the download of the file. File was downloaded and extracted to the right filder, but somehow the option is not appearing in SSMS... Any idea how to solve this?
Hi, I just tried it again and the mistake I made was extracting the source code zip into the extensions folder. You should get the compiled version -> unblock -> exe .reg and then it works.
https://github.com/nicholas-ross/SSMS-Schema-Folders/releases