The repository database stores all the information about connections, transformations, packages, SQL scripts, reports and execution logging. This is where the results of ETL designer hard work is stored and obviously, no one wants to lose it.
This article provides information about configuring MS SQL Server Repository connection
All versions are supported including 2000, 2005, 2008, 2012, 2014, 2017, 2019, 2022 and Compact Edition.
To avoid issues with date fields always use English as the default language for repository user
Consider the following scenario. Administrator John installs the software everything is working fine. Developer Peter logs in, nothing is working, because the developer has no access to the repository database. Peter gets proper access and he can do his job. Over the weekend another administrator want to check execution status he logs in, the same problem happens again.
By default, MS SQL Server repository connection is using Microsoft OLE DB Provider for SQL Server, it is possible to use different OLE DB Provider by switching to OLE DB Repository connection type.