Unable to preview the report , Install Business Intelligence Development Studio feature of Microsoft SQL server

(0) Share

Report

Posted on by Akbarpasha

Hi All,

We have installed AX 2012 R3 and Visual studio 2010 in one machine and SQL server 2016 in another machine , when we are trying to edit the SSRS report in visual studio getting the error "Unable to preview the report , Install Business Intelligence Development Studio feature of Microsoft SQL server" , we have installed "SQL server data tools" from SQL server 2016 setup, still the same error is appearing while editing the SSRS report.

Kindly advise us how to procced in this scenario.

Regards,

Akbar

*This post is locked for comments

All responses (6)

Answers (0)

Nuxavia 45 on at

Like (0)

Report

RE: Unable to preview the report , Install Business Intelligence Development Studio feature of Microsoft SQL server

Hi,

Please see the link below. I think you need to upgrade your MS SQL Server as a result of this

" This content has been retired and may not be updated in the future. The product, service, or technology mentioned in this content is no longer supported."

docs.microsoft.com/.../ms173767(v=sql.105)

Hope it helps?
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Unable to preview the report , Install Business Intelligence Development Studio feature of Microsoft SQL server

To fix this error you need to install SQL Server 2008 R2 Business Intelligence Development Studio (BIDS). Even if you're using SQL Server 2012 for your database, you need this component of SQL 2008 to edit reports in the AOT of AX 2012 R2.

Download here: https://www.microsoft.com/en-us/download/details.aspx?id=30438 Make sure you select "SQLEXPRADV_x64_ENU.exe" from the download options.

Then install SQL Express Advanced 2008 R2 on the AOS or machine you're running your AX session on with only the BIDS option selected.

Hope this helps.
Suggested answer

udaY-ch 4,624 on at

Like (0)

Report

RE: Unable to preview the report , Install Business Intelligence Development Studio feature of Microsoft SQL server

Only Visual Studio 2013 is supported for development for AX 2012 R3 CU8.
Suggested answer

Raheel-Khan 1,371 on at

Like (0)

Report

RE: Unable to preview the report , Install Business Intelligence Development Studio feature of Microsoft SQL server

I guess Visual studio 2010 is not compatible with SQL server 2016. please visit the link mentioned below "Installing Integration Services Versions Side by Side"

docs.microsoft.com/.../installing-integration-services-versions-side-by-side
Akbarpasha on at

Like (0)

Report

RE: Unable to preview the report , Install Business Intelligence Development Studio feature of Microsoft SQL server

Thanks Raheel,

We have already installed "Visual Studio Tools" in AX machine , and installed "Business Intelligence Development Studio feature of Microsoft SQL server" in SQL machine, we have tried uninstalling "Visual Studio Tools" in AX and installed it again , restarted both machines as well, still the same error appearing , we are not able to edit the SSRS report ,

Is there any option to rectify this issue. Please advise us.

Even we have tried with installing business Intelligence Development Studio feature of Microsoft SQL server in AX machine as well. but no luck.

Regards,

Akbar
Suggested answer

Raheel-Khan 1,371 on at

Like (0)

Report

RE: Unable to preview the report , Install Business Intelligence Development Studio feature of Microsoft SQL server

Salam!

Dear Akbar,

Trust you are fine!

Please install Development Tools - Visual Studio tools from AX setup on the AOS server and restart it.