ConfigMgr reporting of AD timestamps

I was helping out a fellow consultant with some less-than-obvious T-SQL for some custom reporting recently.  One of the needs was to get the Last Logon time for an Active Directory user. ConfigMgr Active Directory User Discovery was pulling in the correct attributes, but we hit a snag in getting a good report of the…

Microsoft partner of the year icon

SSRS Error 401.3 Access is denied

So, you’ve been denied!  It’s OK.  It happens to the best of us. If you are lucky enough be gifted with this message take a look at the NTFS rights of the SQL Server Reporting Services instance which will likely be a folder like C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting Services.  Granting the appropriate AD group read…