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

SSMS Job Creation/Editing Error Expand / Collapse
Author
Message
Posted Sunday, November 18, 2012 9:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:48 AM
Points: 18, Visits: 167
My SQL Server Version is given below (Production Environment).

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Web Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack

Issue:

When I create or Edit Job I am getting a error Message like
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)

so I cannot edit or Create Job. Please give me a solution for this. and Let me know why this is happend.
Post #1386140
Posted Monday, November 19, 2012 3:28 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:43 AM
Points: 709, Visits: 1,411
Has this always happened or just recently started? I have seem COM errors popup in SSMS before and the only work-around I have found is to close and reopen SSMS to resolve the error. It is like it gets an error instantiating a class so every time after that it will fail as well, so closing and reopening the app seems to be the only way to clear it.

Joie Andrew
"Since 1982"
Post #1386270
Posted Monday, November 19, 2012 4:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:48 AM
Points: 18, Visits: 167

It is happened recently... Before that i could able to create jobs and all...

now when i open the SSMS and in the 1st attempt i can edit/create job.. when i try for the next time editing/creating this error happens..
Post #1386287
Posted Monday, November 19, 2012 4:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:48 AM
Points: 18, Visits: 167

Is there any permanent solution for this issue?
Post #1386289
Posted Monday, November 19, 2012 4:58 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:43 AM
Points: 709, Visits: 1,411
Not that I have seen, but then again I do not see it THAT often. Curious, is the version of SSMS the same version/service pack as the SQL instance you are connecting to?

Joie Andrew
"Since 1982"
Post #1386308
Posted Monday, November 19, 2012 5:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:38 AM
Points: 1,869, Visits: 2,986
I used to get this a lot - same work around - close SSMS & reopen.
Patching SSMS to SP1 or 2 seemed to have stopped it happening.
Post #1386309
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse