Wednesday, July 8, 2015

MS CRM 2013 could not print report after windows upgrade from 2008 to 2012

Recently, company upgraded RDP server from windows 2008 R2 to 2012 R2, and user reported one problem on MS CRM 2013.

After upgrade, our CRM system - Microsoft CRM 2013 on premises - could not print report. Normal users will pop up window for username and password. It looked simple: put in administrator's username and password could work. MS SQL Server reporting service needs administrator privilege to download and install ActiveX component for the printing feature.

In Windows 2008, it happened, and after input administrator username and password, everything's fine. But, in windows 2012, it will show "Printing is not available. Verify that ActiveX is enabled, or try using Internet Explorer for the desktop".

 Then, I logined RDP server as an administrator, BUT, I still got this error. After Internet search, I still could not fix it. Only useful info is about IE security setting for ActiveX. I confirmed all related ActiveX options are "Enabled", but not luck. I tried many ways, still not luck.

After a day, I thought that it works on windows 2008, but not 2012, it means, some security setting has changed on 2012. So, I tried RUN IE AS ADMINISTRATOR, then, it works. After installed the activeX component, all user could print reports from CRM system.