Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to: Configure a Report Server Database on a Database Engine Upgraded from SQL Server 7.0 (Reporting Services Configuration)

SQL Server 2005

Before creating a report server database on a SQL Server Database Engine instance that has been upgraded from SQL Server 7.0, you must run a stored procedure to set the compatibility level. Setting the compatibility is necessary to avoid the following exception: "Incorrect syntax near 'COLLATE'. You may need to set the compatibility level of the current database to a higher value to enable this feature."

This error occurs when you try to create a report server database on a SQL Server instance that has been upgraded from version 7.0.

  1. Run exec sp_dbcmptlevel on the master database. For more information, see sp_dbcmptlevel (Transact-SQL).

  2. Start the Reporting Services Configuration tool and connect to the report server instance you want to configure.

  3. In Database setup, connect to the SQL Server Database Engine instance for which you ran the stored procedure.

  4. Click New to create the database.

  5. Specify the database name and the account used to create the database, and then click OK.

  6. Specify credentials for the report server database connection. For more information, see Configuring a Report Server Database Connection.

Community Additions

© 2015 Microsoft