cannot start the planning server after installing cognos planning 8.4

[coutinsa123]

Hi All,

I am trying to install cognos planning 8.4 on my local windows machine as a proof of concept before i can try on the server.
I am using MSSQL as a content store i have tested i can successfully connect to it through cognos configuration.
But when i try to start the planning server i get the below error.

Have installed in the same order as below.
Planning server. 8.4
Planning administration 8.4
Planning Client 8.4

All component on single machine just poc, do not have any other BI installed on it.

Can connect to content manager…just cannot start the planning server.

The error is:

[ ERROR ] Failed HRESULT [0x80004005] :The service failed to start because it could not successfully open a database connection with the Planning Store or the Content Store configured in Cognos Configuration. Details:
Database Errors:  Source: Microsoft OLE DB Provider for SQL Server Description: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error. Number: -2147467259 SQLState: 08001 NativeError: 18

Kindly assist.
Regards,
SAndra.

[sreddyy]

Hi,

Use SQL Native Driver installed on server and when you are creating data store in CAC use SQLNCLI driver instead of SQLOLEDB. Hope you have created Planning_Store as wel or may be you are trying to use same database for Content and Planning.

Thanks,
Sreenivas

[rbuhrt]

You should never have to use the native client with a default installation of both SQL 2005 and EP 8.4

Have you defined your planning store connection to be the same as a content store connection?
Are you using SQL authentication or Windows authentication against the datastore?
Do you have named pipes enabled as a connection type on SQL?