Error in configuring Content store DB

[snagaboina]

Hi,
I have installed cognos 10.1 and sql server 2008 on window 8 64 bit OS. Created new database for content store(CM) and while trying to configure the same to Cognos getting ' The Database connection failed' error. I tried with sql server 2012 as well. But no luck!.
TCP/IP is enabled and security is set to mixed mode. Can anyone help me in fixing the problem. Thanks !!

[sunosoft]

Can you let us know the exact error that you are facing.Will be great if you share error screenshot.

[snagaboina]

Hi,
Attached the error snapshot. please let me know for any other details.

[sdf]

double check your TCP/IP, make sure to restart your sql server.
It is best practice to use hostname or ipaddress for the database connection rather than using localhost.

It would be better if you can provide the server.log to have a clearer view of the problem.

[MFGF]

Hi,
I have installed cognos 10.1 and sql server 2008 on window 8 64 bit OS. Created new database for content store(CM) and while trying to configure the same to Cognos getting ' The Database connection failed' error. I tried with sql server 2012 as well. But no luck!.
TCP/IP is enabled and security is set to mixed mode. Can anyone help me in fixing the problem. Thanks !!

Hi,

Are you using SQL Server 2008 R2? If you have Cognos 10.1 with no fix packs, this is not a supported content store. You'd need to be on SQL Server 2005 or 2008 (not R2), or install 10.1.0.1.

If this isn't the case, check you are not using the Express version of SQL Server - this isn't supported for use as a Content Store.

Third thing to check - did you configure your database to use a unicode character set?

Cheers!

MF.

[snagaboina]

Thanks for your posts!
I will try and let you know the results.

[snagaboina]

Hi,
I have installed sql server 2008 standard edition and configured with cognos. It woked!

Thanks you so much!!