RRD 2.0.1 Installation SQL 2008 R2 Windows Server 2008 R2
![]()
JJ Baird (19●1●8●12)
| asked Nov 12 '13, 8:12 a.m.
retagged Nov 12 '13, 10:45 a.m. by Francesco Chiossi (5.7k●1●11●19)
I have searched every possible question relating to this issue and have not yet found the issue:
I am installing RRDI 2.0.1 on Windows 2008 R2 with SQL Server 2008 R2 (on a different server). I have created a service account on the domain and added the service account to SQL Server as instructed. In the "Configure Data Warehouse" step, "Step 2" I enter this user in the Report User Name in the format: "Domain\UserName", however I get an error: CRRRD4785E: The report user <Domain\UserName> does not exist. When I enter an SQL account and password the validation does continue, when validating. However when continuing with the SQL Server account I get an error on the 'Build and Deploy Reporting Components' step: CRRRA3018E: The RIDW data source connection in Cognos failed to connect. Check if the database client is installed correctly or additional configurations are needed.I have installed the JDBC driver and in the first step (Configure Database Management System) I point it to this location: C:\sqljdbc_4.0\enu\auth\x86\ - because the server requires a 32-bit version. Also... Not sure if this is relevant, but when trying to connect to the database with Integrated security, an error is shown: "SQL ERROR: This driver is not configured for integrated authentication"
|
2 answers
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
I have managed to sort out the issues with the integrated authentication error. I had to copy add the jdbc driver to the Windows path variable, however... even with Windows authentication I still get the error:
CRRRA3018E: The RIDW data source connection in Cognos failed to connect. Check if the database client is installed correctly or additional configurations are needed.