Nova IAM, home
Request a demo
Request a demo

Infrastructure & databases

Project integration

Microsoft SQL Server

As part of an integration project, Nova manages the logins, database users, and server and database roles of your SQL Server instances, using the same request and recertification process as for every other entitlement.

Request a demo Discuss the integration

Capabilities

What the Microsoft SQL Server project integration covers

  • Logins and users

    Creates logins and database users when access is needed and disables or removes them when it ends.

  • Server and database roles

    Grants and revokes server and database roles through Nova's request and approval workflows.

  • Roles in the catalog

    Lists your SQL Server roles in the entitlement catalog so they can be requested and recertified.

  • Target vs. actual

    Compares the actual state in SQL Server with the target state in Nova and surfaces any drift.

  • Audit evidence

    Records every account and role change for audit purposes.

Technology and process

Integration and identity lifecycle

Technical integration

The connector talks to SQL Server through its standard database interface and manages accounts and roles with regular T-SQL statements under a dedicated service account. It is built on Nova's connector SDK and tailored to your instances during the project.

In the identity lifecycle

Joiners receive database access through role assignments, movers have theirs adjusted, and leavers have them revoked with the account disabled or removed. Server and database roles pass through requests, approvals, and recertification like any other entitlement in Nova.

More in the catalog

Related integrations

All product names, logos and brands mentioned are property of their respective owners. They are referenced solely to describe compatibility and do not imply any partnership or endorsement.

Next step

Ask your questions live on the system.

30 minutes via video call on the demo system: you name your use cases, we show the relevant functions.

Request a demo

What happens next

  1. ReplyWe usually get back to you on the same working day and agree a date with you.
  2. PreparationWe prepare the demo around the topics you name.
  3. 30 minutes via video callLive on the demo system with fictitious data: you ask, we show the relevant views.