Skip to main content
MS SQL accounts let you manage access to your Microsoft SQL Server databases. Users connect through the CLI (a local proxy), and every session is recorded.

Creating an Account

1

Start adding an account

Go to Privileged Access Management → Accounts and click Add Account.
2

Select a folder and template

Choose which folder to add the account to, then select an MS SQL template.
3

Enter connection details

4

Choose authentication method

MS SQL supports three authentication methods:
Standard SQL Server login with username and password.
5

Save

Click Create.

Connecting

The CLI starts a local proxy that you connect to with your preferred SQL Server client.
The command outputs the local port to connect to. Then use sqlcmd, Azure Data Studio, or any SQL Server client:
No password needed since the proxy handles authentication. Flags:
  • --port <port> — use a specific local port (otherwise one is assigned automatically)
  • --reason <reason> — provide an access reason (if required by template)

Next Steps

PostgreSQL Accounts

Add PostgreSQL database accounts.

Sessions

View and manage sessions.