Hi,
I am trying to configure reporting services which I just added to an already existing installation of SQL Server 2005. When I am in the reporting services configuration manager and I am trying to create the reporting services database I get the following error:
Verifying Database Edition
The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services.
I have figured out so far that I have this currently installed:
SQL Server
Version: 8.00.2039
Level: Service Pack 4
Edition: Standard Edition
Database Engine
Version: 9.2.3042.00
Edition: Express Edition
Reporting Services
Version: 9.00.1399.06
Edition: Developer Edition
I did a google search on this error and found a lot of information about different versions and their compatibility with one another. However, it is confusing me a great deal. I am guessing from what I have read that the Reporting Services cannot use the Express Edition of the database engine.
But this confuses me because I would have thought that the SQL Server Standard Edition would have been installed with the Standard Edition of the Database Engine.
If anyone can point me in the right direction I would really appreciate it. I am guessing that I need to upgrade the database engine to either standard or developer edition, but I do not know if this is going to make the SQL Server stop working correctly; where I would find the upgrade (download or use one of my CDs), etc.
Thanks,
~ Franccesca