SQL Server and Secret Server

Secret Server utilizes Microsoft SQL Server as its backend database to store and manage all its data securely and efficiently. SQL Server provides a robust and scalable platform for handling the extensive data operations required by Secret Server, including storing secrets, audit logs, user information, and configuration settings. The database is configured to use the SQL_Latin1_General_CP1_CI_AS collation to ensure compatibility and optimal performance. Secret Server supports various editions of SQL Server, including Express, Standard, and Enterprise, allowing organizations to choose the edition that best fits their needs. For high availability and disaster recovery, Secret Server can leverage SQL Server's advanced features such as mirroring, clustering, and AlwaysOn Availability Groups. Additionally, Secret Server can be configured to use Integrated Windows Authentication (IWA) for secure and seamless access to the SQL Server database.