Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.