December 18, 2011 at 5:17 pm
Ever since I installed 2008 R2, I have been noticing that SSMS crashes sometimes when I go to view/edit jobs. The error message is
TITLE: Microsoft SQL Server Management Studio
------------------------------
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)
------------------------------
ADDITIONAL INFORMATION:
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)
Has anybody faced this situation before? Any idea how to resolve this?
December 18, 2011 at 8:19 pm
I think I have encountered this issue in sqlserver 2008 (Not R2).
My scenario is when I created a job in using t-sql scripts ( taken from a different server) .
The SSMS crashes when I want to edit the job. But the same job if i create in the server using GUI worked perfectly fine.
I did not pay much attention to solve the issue as such recreating is a easier that time.
May be if this is applicable to you, please try to recreate the job.
December 18, 2011 at 9:10 pm
Yes it is a know bug.
What you can do is open a new instance of SSMS in a new window and the edit the same job and it will work fine.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
December 19, 2011 at 8:08 am
No it works if i close out SSM and re open it..But its annyoing. Any idea when the fix is going to be in place for this?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply