Solved

Visual Studio or Windows Server conflict

Posted on 2013-06-18
6
572 Views
Last Modified: 2016-02-11
We have Visual Studio 2008, version 9.0.30729.4462 QFE installed on serveral
Windows Server 2008R2, Enterprise servers.  .NET Framework version 3.5 SP1

We have numerous SSIS packages on these boxes, all have been working beautifully for a year+.  As of Friday of last week, any attempt to open a package within Visual Studio fails with this message:

Microsoft Visual Studio is  unable to load this document:
Retrieving the COM class factory for component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC97SBA2} failed due to the following error: 8007007e.

The packages are running fine, it's just that they cannot be opened (or edited).
I am not sure which direction to go with this.  

Any tips?
0
Comment
Question by:dbaSQL
  • 4
  • 2
6 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 500 total points
ID: 39256036
It sounds like you have some damage to one or more of the files needed to run VS. Does this happen on every single server, or have you got only one VS installation? If the latter, back up all your package sources, remove VS, and install it again.

BTW, why are you developing on your server machines?

hth

Mike
0
 
LVL 17

Author Comment

by:dbaSQL
ID: 39256056
Even further, I cannot open the SQL Server Configuration Mgr anymore on one of the servers that is having this problem.  Attempting to do so, fails with this:


MMC could not create the snap-in.  The snap-in might not have been installed correctly.
Name: SQL Server Configuration Manager
CLSID:  {D52E5F54-75D9-4A93-2215EA5CBED2}


I copy the icons to the task bar for all of my SQL - related components, and use this to open the apps, as needed.  Have been doing this forever.  Attempting to open the config mg fails with the above error.

Any ideas?
0
 
LVL 17

Author Comment

by:dbaSQL
ID: 39256082
I removed the previous icon and created a new one via MMC/Add-remove snap-in.  That works now, but I still can't get into the SSIS pkgs without the COM error posted above.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 17

Author Comment

by:dbaSQL
ID: 39256191
It happened once last Friday.  Yesterday it happened a few times.   Today it is happening on every attempt to open any package.  It's just one server.  The same attempt to open the package remotely, from another server, works without the COM error.
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 39256425
Your last post reinforces my suspicion that you have something (software) broken on your server.

Your packages are all under something like Users\username\My Documents\VS2010\Projects\ with each in its own folder below Projects. Take a copy of one of these folders and copy it to a machine with a working SSIS, park it in the same (relative) place, and open the .sln file. You will probably have to fix a few links but it should open ok. Doing that demonstrates that the problem is with the VS installation on the server.

As I said before, why are you developing on your server machine? You should develop either on the desktop or on a virtualised desktop and then deploy to the server. After successful deployment, shift a backup copy of the (now deployed) solution to the server and also back it up off the machine.

hth

Mike
0
 
LVL 17

Author Closing Comment

by:dbaSQL
ID: 39265829
The problem is still unresolved.  I will work on the removal, and reinstallation.  Thank you for you input.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question