Error: " ... the user is not associated with a trusted SQL Server connection? Error code = 80004005" when installing CCS Reporting and Analytics

Products

• Control Compliance Suite Databases Oracle

Issue/Introduction

When installing CCS Reporting and Analytics, the following error message occurs during the install after providing the SQL Server Credentials:

Unable to establish a connection with Default SQL Server instance on target computer Error message: Unable to connect to SQL Server Reason: Unspecified error (login failed for user" . the user is not associated with a trusted SQL Server connection? Error code = 80004005
 

Cause

The account provided in the CCS Reporting and Analytics install does not have write access to the temp directory for the account that starts the SQL Server Agent Service

Resolution

Check permissions to the SQL Server Agent Service Account's temp location:

1. Connect to the SQL Server
2. Open the Services Applet (Start -> Run -> services.msc)
3. Open the properties of the SQL Server Agent
4. Click the 'Log On' tab and note the account that is used to start this service
5. Open Windows Explorer and locate the temp directory for this account

For example this might be:

C:\Documents and Settings\<Account Name>\Local Settings\Temp

6. Check the properties of this location, and ensure that it is not read only, and that the account that will be used during the Reporting and Analytics install will have access to write to this location


The error code 80004005 occurs due to a lack of permissions. If the above does not resolve the issue, other permissions issues may exist.