Modify the SQL Server Management Studio processes section: In the Hardening subfolder of the PSM installation folder, open the PSMConfigureAppLocker.xml configuration file and edit it as described in the next steps.Ĭonfigure the AppLocker to permit SQL Server Management Studio to run on the PSM server.Remove the read-only permissions from the PSMConfigureAppLocker.xml file.The PSM AppLocker configuration is saved in the PSMConfigureAppLocker.xml configuration file and must be edited manually before you run the configuration script. SQL Server Management Studio can be obtained from the Microsoft website. On the PSM machine, install the Microsoft SQL Server Database Administration Tool. Install Microsoft SQL Server Database Administration Tools It is recommended to configure and set appropriate access by using a local accounts or through external controls such as firewalls, domain separation and more.ĭo the following tasks to set up PSM for either a Microsoft database: Task

Using the SQL Server Management Studio with Windows Authentication connector with a domain account does not restrict the end user from accessing different databases and target resources in the domain with the same domain user.

This topic describes how to connect to SQL Server Management Studio with Windows authentication through PSM. SQL Server Management Studio with Windows Authentication

Sql server ma