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