Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Error "8004005 Access Denied" occurs when running reports.
Description
There are known issues with the way Native Authentication is being passed between the IIS Servers and the SQL Servers. Usually there is no issue authenticating remotely when using the account that installed Spotlight On Exchange and also running the reports on the IIS server. It is recommend either to use Kerberos, SQL Authentication or installing both IIS & SQL on the same system. Due to security issues, it may not be desirable to install both IIS and SQL on the same server. It is suggested to use SQL Authentication because the environment has to be in Native Mode Win2K with other settings to be configured for Kerberos and Basic Authentication sends passwords in clear text across the network. Below is more information regarding the different authentication that can be used.
The following Microsoft KB Articles can assist with using Native Authentication:
Article ID 176379 - How to set up IIS and SQL Server on separate machines with a trusted connection http://support.microsoft.com/default.aspx?scid=kb;EN-US;176379
Article ID 176377 - Accessing SQL Server with Integrated Security from ASP http://support.microsoft.com/default.aspx?scid=kb;en-us;176377
Article ID 176380 - How To Use ASP with a SQL Trusted Connection with Guest Account http://support.microsoft.com/default.aspx?scid=kb;EN-US;176380
The following Microsoft KB Article can assist with enabling Kerberos Authentication:
How To: Implement Kerberos Delegation for Windows 2000 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT05.asp
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.