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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Raheel-Khan 1,371 on at

Like (0)

Report
Copy link

Link copied!

Salam!

Dear Akbar,

Trust you are fine!

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

Was this reply helpful? Yes No
Akbarpasha on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Raheel-Khan 1,371 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

udaY-ch 5,173 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

1 people found this reply helpful.

Was this reply helpful? Yes No
Nuxavia 49 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No