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

FieldDescription
NameA descriptive name (e.g., analytics-db)
HostDatabase hostname or IP
PortSQL Server port (default: 1433)
DatabaseDatabase name (default: master)
SSL EnabledEnable SSL for the connection
Reject UnauthorizedReject connections with invalid certificates (only if SSL enabled)
SSL CertificateCustom CA certificate (only if SSL enabled)
4

Choose authentication method

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

Save

Click Create.

​
Connecting

The CLI starts a local proxy that you connect to with your preferred SQL Server client. 
infisical pam access my-folder/analytics-db
The command outputs the local port to connect to. Then use sqlcmd, Azure Data Studio, or any SQL Server client: 
sqlcmd -S localhost,<port> -d analytics
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.