Solved

Visual Studio or Windows Server conflict

Posted on 2013-06-18
6
569 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
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…

810 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