Category Archives: SQL Server

SQL Server 2008 R2 builds released after SQL Server 2008 R2 was released

See the Microsoft Support article http://support.microsoft.com/kb/981356 for an overview of all SQL Server 2008 R2 builds – including links to the cumulative update packages – that were released after SQL Server 2008 R2 was released.

SQLserver.jpg

Since it contains an overview of all SQL Server 2008 R2 cumulative update build numbers this may come in handy one day too.

Advertisements

SQL Server job step problem – Creating an instance of the COM component with CLSID

While creating a SQL Server Agent job I ran into this error message during the creation of the 2nd or 3rd step.

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

This issue is already been fixed since Cumulative Update 3 – see “FIX: You cannot create, add, or edit steps for an SQL Server Agent job in SQL Server Management Studio 2008 R2, http://support.microsoft.com/kb/2315727.

In the meantime Cumulative Update Pack 10 has been released. I installed it – http://support.microsoft.com/kb/2591746 – and this indeed fixed the issue.