Accessing MSSQL database using SQL Management Studio
You can access MSSQL database using SQL Management Studio as follows. The session opens on the user machine in SQL Management Studio(SSMS) therefore, ensure that SSMS is already installed on the user device. You can then provide the path where SQL Management Studio(SSMS) is installed in the Launcher Settings.
Procedure:
Login to the system and select PC from the product navigator.
Under the Plugins and Connectors section → Access Types.
- Create SQL Management Studio Access Type → Configuration →Access Types.
- Click on Add Access Type→ Name : SQL Management Studio →Select Base Access Type : Thick Client → Specify Additional Ports if any → Upload xml file in Plugin Process.
- Click On User Profile → Settings → Launcher Settings.
- Select Access Type as : SQL Management Studio.
- In the Execution Path field provide the path where SSMS is installed.
- Login to the system and select PAM from the product navigator.
- Go to My Access page → locate the asset you want to connect to →click on its action button.
- Select Connect → SQL Server Management Studio.