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
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
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.
Imported Document ID: TECH115293
Subscribing will provide email updates when this Article is updated. Login is required.