If you create the repository in Microsoft SQL Server 2005, the repository database must have a database compatibility level of 80 or earlier. Data Analyzer uses non-ANSI SQL statements that Microsoft SQL Server supports only on a database with a compatibility level of 80 or earlier.
To set the database compatibility level to 80, run the following query against the database:
sp_dbcmptlevel ‘<DatabaseName>’, 80
Or open the Microsoft SQL Server Enterprise Manager, right-click the database, and select Properties > Options. Set the compatibility level to 80 and click OK.