Community
Showing results for 
Search instead for 
Do you mean 
Reply

Error with SQL Server Management Studio after ACT 11.0 install

New Member
Posts: 7
Country: United States

Error with SQL Server Management Studio after ACT 11.0 install

After installing ACT 11.0 Premium for Web, when I try to launch SQL Server Management Studio, I get "Could not load file or assembly 'EnvDTE, Version=8.0.0.0, Culture=neutral, PublicKeyToken=...' or one of its dependencies.  The system cannot find the file specified."  Is there an easy workaround?
Moderator
Posts: 4,395
Country: USA

Re: Error with SQL Server Management Studio after ACT 11.0 install

Try the steps below:

 

- Search the computer for envdte.dll. 

- Once found, verify the version is 8.0.* 

- Then open the assembly folder (Start -> Run -> assembly). 

- Drag and drop envdte.dll into the assembly folder. 

- Verify that EnvDTE 8.0.0.0 is in the assemblies.

- Open SQL Server Management Studio

 

New Member
Posts: 7
Country: United States

Re: Error with SQL Server Management Studio after ACT 11.0 install

When I searched, I did not find envdte.dll on my computer.  Looks like reinstalling (or repairing, if that's an option) SQL Server is the way to go.  Will that cause problems with the ACT installation?

 

Paul

Nickel Elite Contributor
Posts: 567
Country: USA

Re: Error with SQL Server Management Studio after ACT 11.0 install

What version of SQL Server Management Studio are you using?

 

ACT! Premium for Web installs with SQL Express or SQL 2005 Standard, depending on the version you purchased.

 

You would need to use the SQL Express Management Studio else the Management tools that come with SQL 2005 Standard edition, I don't believe older versions of Management Studio are not compatible with the newer SQL products.

 

You will NOT be able to access the ACT7 instance however as it is intentionally locked down. 

 

Hope this helps,

-Matt

 

Matthew McFadden
Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: Error with SQL Server Management Studio after ACT 11.0 install

New Member
Posts: 7
Country: United States

Re: Error with SQL Server Management Studio after ACT 11.0 install

I think I had the Standard Edition of the Management Studio installed.  I'll try to see if someone else in the company has the DLL and try your initial suggestion before re-installing.  Thanks for your help!

 

Paul

New Member
Posts: 1
Country: United States

Re: Error with SQL Server Management Studio after ACT 11.0 install

I know this is an old thread, but I am posting the fix for those that need.

 

search for envdte.dll on your system.  you will find it in the .net 1.1 common folder.

 

You need to drag and drop this file into your assembly folder.

 

To get to the assemply folder go to START\RUN and type assembly

 

just drag and drop the file in there.  Make sure it is envdte.dll and not envdte8.dll

cvs
New Member
Posts: 1
Country: Belgium

Re: Error with SQL Server Management Studio after ACT 11.0 install

Thank you David; your solution works very fine!