You cannot create, add, or edit steps for a SQL Server Agent Job in SQL Server Management Studio 2008 R2

Views 2501

While on a client site I received an email indicating that when using SQL Server Management Studio 2008 R2 on a new instance of SQL Server 2008 R2 which has been recently built, they were receiving an odd error. The error could be reproduced however there was no consistency to the error as it was very sporadic, not limited to accessing a local instance or a remote instance.

The Error message being received was “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 is a known bug and Microsoft have put out a Cumulative Update 3 to resolve the issue. To read more about what is covered in this Cumulative Update click SQL Server 2008 R2 Cumulative Update 3.

Being skeptical, I did not want to apply SQL Server 2008 R2 CU3 onto the 3 nodes of the production cluster. The client does have 2 Terminal Services machines that are used to run SSMS and connect to the production instances of SQL Server 2008 R2. After ensuring that there were no connections and the running of SSMS to avoid needing to undertake are reboot of the server, the Cumulative Update was installed without any issues. After the Cumulative update was applied updating the client tools, testing was undertaken against the SQL Agent jobs to ensure that the error above was no longer received.

Success. Another happy client after an obscure error popping up in production.

If you are experiencing the error listed above, have a read of the contents of what is covered in the Cumulative Update and ensure that it does meet your particular issue before installing the Cumulative Update. Ensure that you test after the installation, and do not install it straight into production without testing.

Happy hunting with your SQL Server 2008 R2 environments.

Leave a Reply

Your email address will not be published. Required fields are marked *

Warwick

I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.

Search