- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
08-27-2024 04:21 PM
Hi,
I'm using PSM version 14.2 and recently added connection component for SQL Management Studio (Windows Authentication). When adding the settings in PSMConfigureApplocker.xml file and running the script in PowerShell as administrator, the execution of PSMConfigureApplocker.ps1 script takes more than 20 minutes?
Any ideas?
These are the settings I added:
<!-- SQL Server Management Studio 2018 processes -->
<Application Name="SSMS2018" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" Method="Publisher" />
<!-- SQL Server Management Studio 2018 Profiler -->
<Application Name="SSMS2018-Profiler" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\PROFILER.EXE" Method="Publisher" />
<!-- SQL Server Management Studio 2018 Tunning Advisor -->
<Application Name="SSMS2018-DTAShell" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\DTASHELL.exe" Method="Publisher" />
-- ALlowed DLL:
<Libraries Name="mssqlnatives" Type="Dll" Path="C:\Windows\assembly\*" Method="Path" />
<Libraries Name="SHELLCOMPONENTS" Type="Dll" Path="%WINDIR%\SHELLCOMPONENTS\*" Method="Path" />
<Libraries Name="SHELLEXPERIENCES" Type="Dll" Path="%WINDIR%\SHELLEXPERIENCES\*" Method="Path" />
<Libraries Name="SQLServer" Type="Dll" Path="%PROGRAMFILES%\MICROSOFT SQL SERVER\*" Method="Path" />
<Libraries Name="MSShared" Type="Dll" Path="%PROGRAMFILES%\COMMON FILES\MICROSOFT SHARED\*" Method="Path" />
<Libraries Name="SSMS2018-Debugger" Type="Dll" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\Packages\Debugger\*" Method="Path" />
08-27-2024 04:32 PM
Hi @Dercel Gonzalez
It could be due to a few reasons,
Hope it helps !
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!

