Wednesday, 16 December 2015

SQL CDC Error

When trying to enable the CDC on SQL database, the following error message displays:
  • Could not update the metadata that indicates database is enabled for Change Data Capture. The failure occurred when executing the command SetCDCTracked (Value = 1)

This error message comes when trying to enable CDC on a SQL Server 2008 database when the owner is not "sa".The fix for this is to change the database owner to "sa" by executing the below script:
  • USE <database-name>
  • GO
  • EXEC sp_changedbowner 'sa'



Analysis Service in Power BI Report Server

 We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly... link