Answered by:
Reports not deployed properly in SSRS

-
Hi,
When i try to deploy in deployment server ,
am getting following error;
"An attempt has been made to use a data extension 'ODBC' that is either not registered for this report server or is not supported in this edition of Reporting Services."
How to avoid above error?
Question
Answers
-
- Proposed as answer by Charlie LiaoMicrosoft contingent staff, Moderator Tuesday, June 25, 2013 3:17 AM
- Marked as answer by RSamba Tuesday, June 25, 2013 9:01 AM
All replies
-
What edition are you using?
http://technet.microsoft.com/en-us/library/ms155086.aspx
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0c9722d4-8c14-49b4-9bbe-a8f9f1968c8a/an-attempt-has-been-made-to-use-a-data-extension-oledb-that-is-either-not-registered-for-this
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
-
-
Hello,
With SSRS Express Edition you can connect with the reports only the the SQL Server database engine of the same instance as SSRS; not to other SQL Server and not to other datasources like MySQL; that's a limitation of the free Express Edition.
See MSDN: Features Supported by Reporting Services in SQL Server Express
Olaf Helper
Blog Xing- Edited by Olaf HelperMVP Monday, June 24, 2013 1:10 PM MSDN link
- Proposed as answer by Charlie LiaoMicrosoft contingent staff, Moderator Tuesday, June 25, 2013 3:17 AM
-
-
- Proposed as answer by Charlie LiaoMicrosoft contingent staff, Moderator Tuesday, June 25, 2013 3:17 AM
- Marked as answer by RSamba Tuesday, June 25, 2013 9:01 AM