Solved

Visual Studio or Windows Server conflict

Posted on 2013-06-18
6
566 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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
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…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now