This section lists known issues encountered when installing the repository on Microsoft SQL Server v2005 and higher.
Optimizing Repository Reads with Snapshots
To ensure that all users reading data will get access to a snapshot and not be blocked by concurrent transactions, we recommend that you enable the following SQL Server options:
- ALLOW_SNAPSHOT_ISOLATION
- READ_COMMITTED_SNAPSHOT
Note: No users should be connected to the repository when you enable these options.
Connection Profile: "Error converting characters into server's character set"
If you receive such a conversion error when working with a connection profile, click the ellipsis button to the right of the Connection parameters field on the Connection Profile Definition dialog, add the CharSet parameter, and enter the appropriate charset value to match your repository database.