Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't edit/add step on SQL Server 2008 R2 RTM Jobs Expand / Collapse
Author
Message
Posted Monday, October 28, 2013 7:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 28, 2014 12:01 AM
Points: 29, Visits: 121
Hi,

I am unable to edit existing Step and unable to add new step to SQL Server 2008 R2 RTM version, getting the msg "creating an instance of the com component with clsid from the iclassfactory failed". I tried to Restart the Service & disconnected and then reconnected SSMS, still experiencing the same issue.

Please do the needful, as I need to make it happen ASAP.
Post #1508884
Posted Monday, October 28, 2013 8:36 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, December 18, 2014 10:53 AM
Points: 597, Visits: 937
Usually you can just restart SSMS and it works, but this is a known issue:
http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps

And depending on which version you are on (the name of the question and the forum don't match) here are the fixes:
SQL Server 2008 R2 SP1
or
SQL Server 2008 SP3





Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1508919
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse