I was wondering if any one has encountered the following and as such found a solution.
- server 01 is in domain A (Windows 2003, MSSQL 2005).
- workstation 01 is in domain B (Windows XP, IE8... I know stop laughing).
- AD accounts come from domain B.
Previously our end-users would have to use a separate account from domain A to access SSRS, but recently we setup a one-way trust from domain A to domain B hoping that end-users would no longer have to use a separate account and with the right SSRS configuration of domain B users, the trust would kick in.
The problem is that it is not working, the error I am getting is "HTTP 500 Internal Server Error" in IE. To add to my confusion if I connect server 02 which is Windows 2008R2 with MSSQL 2012 it works perfectly.
Does anyone know what I am missing... I know that MSSQL 2005 uses IIS while MSSQL 2012 does not, but I am at a loss to know who to fix this... "help!!!". 🙁
Any help greatly appreciated.