Tuesday, April 10, 2012 3:31 PM
Is this problem from SQL 2008 not yet solved, and also a legacy in 2012?
I have in my enviroment...
1 DBMS for Sharepoint DBs and SSRS DBs
All of theese except the SSRS server have I upgraded from Eval. edition to SQL 2012 RTM Enterprise. The SSRS server have I upgraded to SQL 2012 Standard.
All of this working fine except when Im trying to access my reports on the SSRS server. Then I get this error:
"The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services."
When I look at every server they all have same SQL version, 11.0.2100.60 Enterprise Evaluation Edition but according to Wikipedia (http://en.wikipedia.org/wiki/SQL_Server_Management_Studio) that is the version for RTM so I guess everything is ok.
I tried to repair the SSRS but it didnt worked. What is the solution, delete the DBs and reinstall the SSRS?
I guess that an Eval. upgrade to RTM is supported.
- Edited by c0zzman Tuesday, April 10, 2012 3:34 PM
Friday, April 13, 2012 7:47 AMModerator
Friday, April 13, 2012 8:33 AM"All of theese except the SSRS server have I upgraded from Eval. edition to SQL 2012 RTM Enterprise. The SSRS server have I upgraded to SQL 2012 Standard"
Tuesday, April 17, 2012 5:17 PM
I have now tried to uninstall the SSRS server and deleted the databases.
When I now install and configure SSRS 2012 Std from the RTM media and tries to place the db on my DBMS server I instead get this error:
"Using other edition of SQL for report data sources and/or the report server database is not supported in this edition of reporting services"
Is it not possible to place SSRS 2012 Std db's on DBMS 2012 Ent.?
Tuesday, April 17, 2012 7:40 PMHmm...I actually found the problem.
The edition upgrade on the DBMS server holding the SSRS db's had failed. I haven't notice that. :(
After I did the edition upgrade again everything works fine.
- Marked As Answer by c0zzman Tuesday, April 17, 2012 7:40 PM