Skip to main content
A Microsoft SQL Server account stores the credentials for one SQL Server login or Windows user. Members connect to the database through the Infisical CLI, and Infisical records every query they run.

​
Prerequisites

​
Create the account

1
Go to Privileged Access Management > Accounts and select Add Account.
2
Select the Folder and a Microsoft SQL Server Account Template, then select Next.
3
Enter a Name and the connection details:
4
Select the Auth Method and enter the credentials:
5
Select Create.

​
Connect

To open a session, follow Connect to an account. Microsoft SQL Server accounts don’t support the browser, so use the CLI. Start the local proxy:
The proxy keeps running in that terminal and prints its port. In a second terminal, connect your SQL Server client, such as sqlcmd or Azure Data Studio, to that port:
The proxy signs in for you, so the client doesn’t need a password.

​
Next steps

Microsoft SQL Server credential rotation

Rotate the passwords of Microsoft SQL Server accounts.

Sessions

Review and end the connections that people and agents make to your accounts.