COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: gohabsgo on 31 Jul 2017 09:13:22 AM

Title: Cognos 11.0.6 and SQL 2016 as Content Store
Post by: gohabsgo on 31 Jul 2017 09:13:22 AM
Hey Folks,
Does anyone have any experience with an 11.0.6 install pointing to SQL 2016 as the content store and / or reporting database?  We're about to start a project of upgrading our SQL servers and just wanted to see if there was any special considerations to be aware of from anyone that's been down the road already.

Thanks!
Title: Re: Cognos 11.0.6 and SQL 2016 as Content Store
Post by: MFGF on 31 Jul 2017 11:13:26 AM
Quote from: gohabsgo on 31 Jul 2017 09:13:22 AM
Hey Folks,
Does anyone have any experience with an 11.0.6 install pointing to SQL 2016 as the content store and / or reporting database?  We're about to start a project of upgrading our SQL servers and just wanted to see if there was any special considerations to be aware of from anyone that's been down the road already.

Thanks!

Hi,

It's on the list of supported content servers for 11.0.4 onwards, so as long as you are on release 4 or later, there shouldn't be any issues. Having said that, I haven't actually tried with SQL Server 2016, as I don't have it. :)

http://www-01.ibm.com/support/docview.wss?uid=swg27047186

Cheers!

MF.
Title: Re: Cognos 11.0.6 and SQL 2016 as Content Store
Post by: Cognos91 on 24 Aug 2017 01:34:05 PM
No specific consideration/ configuration changes needed. Our content store and reporting database is SQL Server 2016. No issues noticed thus far.
Title: Re: Cognos 11.0.6 and SQL 2016 as Content Store
Post by: TomCognos on 25 Aug 2017 12:01:22 AM
+1. Same no issues here. All running well. 2016 SQL Server. 11.0.3, 4, 5 & 6.