Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Visual Studio Report Issue after installing SQLServer Update

Posted on by 1,720

Hi,

we're using Dynamics 365 on premise on a Windows Server 2012 R2 Datacenter with SQLServer 2014. Our development machine is a copy of this server with Visual Studio 2015. When I'm working on reports in VS, I use datasources pointing to the production server to see live data.

This morning there was an SQLServer update to the production server: Security Update for SQL Server 2014 Service Pack 3 GDR (KB4532095), that should resolve security problems with SQL Server Reporting services regarding remote access. Since then I get an error when I try to see the report preview in Visual Studio. Error message is: An error occurred during local report processing. Access denied. (Execption from HRESULT: 0x80030005 (STG_E_Accessdenied). Sounds to me like there was an 'Error' in Reporting Services that enabled me to see my report preview - is there an idea how to solve this?

Reports in Dynamics itself run fine, I can also access the SQL Server tables on the production server via SQL Server Management Studio on the development server.

Thx

Kat

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Visual Studio Report Issue after installing SQLServer Update

    Hi KatKat,

    Glad your issue was resolved.

  • Verified answer
    Kathrin Falsett Profile Picture
    Kathrin Falsett 1,720 on at
    RE: Visual Studio Report Issue after installing SQLServer Update

    Seemed to be a problem with the version control folder bin\debug, though I didn't change anything there. Found that some people had the same issue when this folder was under version control, so I gave it a trial and removed this folder from version control. It took a while and after a couple of tries the problem seemed to be gone. No idea what went wrong.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans