I am currently trying to install Cognos analytics for 2019 R2. I am using the answer file and running the power shell script but get an error that "Cognos Analytics server requires a SQL Server". I have the file pointing towards the database server and even validate the file was similar to our dev environment. Any help is appreciated.
Jan 16, 2020 04:39 PM
Can you post a screenshot or log file showing the error?
That may help to identify exactly what part of the system & process the error is coming from, and hence what can be done about it.
Jan 16, 2020 05:15 PM
How have you configured the CognosConfigProperties.xml file to identify the location of the SQL Server? The server location with an HTTP URL does not look correct to connect to your SQL Server instance. The address should look like the following within the ConfigProperties:
<property name="ContentStoreDatabaseLocation" value="MDCOAP103500:1433"/>
Jan 17, 2020 08:11 AM
OK, then next we need to look at your network/configuration settings:
From your SQL Server DBA, have them verify the following about the SQL Server instance:
1) The TCP/IP Network Protocol is enabled
2) Is it running on the default port of 1433 or a different port
3) It is using the default SQL Server Instance Name, or is it running on a difference instance?
Verify that internally you have no firewalls/proxy servers that would block SQL Server connections between the Cognos Server and the SQL Server
Verify that on the Cognos Server you have the required SQL Server Client Connectivity tools installed
Jan 17, 2020 08:21 AM