SQL Server 2008 R2 - "Specified Module cannot be Found. (MS Visual Database Tools)"

Question

Hi,

I recently installed and then uninstalled Visual Studio 11 Developer Preview, and afterwards when I attempt to create or edit a database diagram in SQL Server Management Studio, I receive the above error (In the title).  I have tried uninstalling and reinstalling SQL Server 2008 R2 with no joy.  Any ideas and solutions would be appreciated.

 

Thanks, Nathan Manning

---

W. Nathan Manning Space City, USA (Huntsville, AL)

Answer 1

Hi Nathan,

The error seems to be related to Visual Database Tools in Visual Studio which can be used to Design Database Diagrams. Could you please try to reinstall the Visual Studio to see it works or not?  In case of something wrong with .NET Framework, please download and install it from this site: Windows SDK for Windows Server 2008 and .NET Framework 3.5.

Best Regards,
Stephanie Lv

If you have feedback for TechNet Subscriber Support, contact [e-mail].

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi Stephanie,

I have since tried repairing Visual Studio 2010 Ultimate Ed. with no change in the error. What are you saying about the SDK?

I have an incident open with SQL Server Technical Support, and they are researching the problem now.

Thanks for the reply.

Nathan

---

W. Nathan Manning Space City, USA (Huntsville, AL)

Answer 3

I have the same issue and have,

1. installed Windows SDK for Windows Server 2008 and .NET Framework 3.5.
2. reinstalled SQL Server 2008 R2
3. reapplied VS2010 SP1

Any ideas would be great appreciated my only other option is to repave my PC

---

See my blog C# Bits | Twitter @sjnaughton Always seeking an elegant solution.

Answer 4

Don't know if this would help, but you may also want to apply SQL Server 2008 R2 SP1.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 5

H Naomi, I found that VS11 did not uninstall the 'Denali' bits so I have removed them and am trying to reapply SQL Server Managment tools and we'll see what happens.

---

See my blog C# Bits | Twitter @sjnaughton Always seeking an elegant solution.

Answer 6

Still no joy I may have to repave my machine :(

---

See my blog C# Bits | Twitter @sjnaughton Always seeking an elegant solution.

Answer 7

I have an incident open with Microsoft Support on this issue. Maybe you should wait until I can post thier fix in this thread (If they come up with one...)

 

Nathan

---

W. Nathan Manning Space City, USA (Huntsville, AL)

Answer 8

Any news about your opened incident?

Answer 9

They weren't getting anywhere. I bought a new PC and reinstalled everything there. Repaving old PC to run Windows Server 2008 R2.  Got my ticket refunded.  Gave an ear full to the technician boss when he asked.

---

W. Nathan Manning Space City, USA (Huntsville, AL)

Answer 10

Fun because I'm in the same situation now. I may need to reinstall too? Damn... if I find a fix, I'll post it here for posterity.

Answer 11

hey guys.

I've also encountered this problem at last night. Finally I found this problem due to missing 'msvcr11.dll', which comes with vs2011 developer preview.

After I install the package 'packages\vcRuntimeMinimum_x86\vcRuntimeMinimum_x86.msi' from vs2011 developer preview install disc, diagram editing in sql server management studio works again.

Hope this information could help you, and I didn't came too late.
I've already post a blog to describe this problem (in chinese).

 

========HOW TO INSTALL THE PACKAGE MANUALLY=======

Sorry for I didn't realized that package can't be installed directly. Try following steps:

1. Press 'Win+R' to run 'cmd.exe', open a command prompt.
2. Extract the ackage 'vcRuntimeMinimum_x86.msi' with following command line:
   msiexec.exe /a <path-to-msi>\vcRunTimeMinimum_x86.msi TARGETDIR=<extract-folder>
   the variable '<path-to-msi>' was the full directory path of the package. '<extract-folder>' was the folder path where you want to put the files extracted.
3. After command run complete, DLLs could be found under the folder '<extract-folder>', copy them to your '%systemroot%' (normally 'windows\system32') directory. If you own a 64bit os, you may also need to extract the 64bit version package, and put the DLLs into the right directory('system32' for 64bit DLLs, 'SysWow64' for 32bit DLLs).
4. Wish your problem solved :-)

 

BTW, the package extraction process can also be done with Universal Extractor.

 

--OR--

You can copy and paste following codes to your notepad and save them as a bat file:

REM MSI extraction script;
set outpath=%~dp0\%~n1
set src=%~dpf1
msiexec /a "%src%" TARGETDIR=%outpath%

And then you can drag-drop the specify msi package on the bat file, extraction will be started automatically. after dialog disappera, a new folder contains the files extracted will be found at the same place with the bat file.

Answer 12

Ted Kruger posted a new blog on a similar issue - may be helpful

SSMS Assembly Error - Microsoft.SqlServer.Sqm.dll

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 13

Hi,

I had same issue after remove Visual Studio 11 Developer Preview. but after reinstalling VS 11, I fixed this issue. I knw this wont help u but I cldnt find any other solution from microsoft at this movement.

So prob deff b'cas of vs 11 I guess.

Answer 14

How exactly do you install the package?  I get a prompt telling me I need to run setup.exe when I try to install the .msi file.  But I do not want to install Visual Studio 11.    I had previously uninstalled VS11 and now I'm unable to view/create database diagrams in either Visual Studio 2010 or SQL Server 2008.  I get the message that MS Visual Database Tools not found.   I had re-applied the service packs,  uninstalled and re-installed both Visual Studio 2010 and SQL Server 2008 and still the issue has not resolved itself.    I should have known better than to install Visual Studio 11 alongside the existing Visual Studio I had installed.  

Answer 15

Mount vs11 install disc to a virtual driver, or open the iso file with winrar, etc. Lookup the package ' vcRuntimeMinimum_x86.msi ' at  'packages\vcRuntimeMinimum_x86\' , and install it.

Answer 16

It seems you have not fully understood my previous post.   I had already mounted the VS11 iso to a virtual driver, browsed to the location 'packages\vcRuntimeMinimum_x86\', and right-click->Install on the 'vRuntimeMinimum_x86.msi'.  When I do that I get an error telling me I need to run the setup.exe to install this package.   So I cannot simply click on it and install the msi as you specified.   

Answer 17

Sorry for that, try this:

1. Press 'Win+R' to run 'cmd.exe', open a command prompt.
2. Extract the ackage 'vcRuntimeMinimum_x86.msi' with following command line:
   msiexec.exe /a <path-to-msi>\vcRunTimeMinimum_x86.msi TARGETDIR=<extract-folder>
   the variable '<path-to-msi>' was the full directory path of the package. '<extract-folder>' was the folder path where you want to put the files extracted.
3. After command run complete, DLLs could be found under the folder '<extract-folder>', copy them to your '%systemroot%' (normally 'windows\system32') directory. If you own a 64bit os, you may also need to extract the 64bit version package, and put the DLLs into the right directory('system32' for 64bit DLLs, 'SysWow64' for 32bit DLLs).
4. Wish your problem solved :-)

 

BTW, the package extraction process can also be done with Universal Extractor.

 

--OR--

You can copy and paste following codes to your notepad and save them as a bat file:

REM MSI extraction script;
set outpath=%~dp0\%~n1
set src=%~dpf1
msiexec /a "%src%" TARGETDIR=%outpath%

And then you can drag-drop the specify msi package on the bat file, extraction will be started automatically. after dialog disappera, a new folder contains the files extracted will be found at the same place with the bat file.

Answer 18

I live just above Microsoft. Each time Microsoft puts out something that creates havoc on users systems with no solutions to fix, I swear I will switch to another development platform. I ask for solutions from some of the folks at the Pro Club (where the "softies" pretend to work out) and the all just shrug and walk away.

At 75.00 an hour for lost development time doing bug chasing, I figure that Microsoft owes me about $80,000 dollars.

This is the last straw.

I have started the switch to Oracle, Java,  PHP and MYSQL!

With that, I can also switch to a Mac.

Answer 19

If we had fewer of the "Don't know if this would help, but...", maybe we wouldn't have to wade through 3 tons of crap to get at an ounce of goodness!

Answer 20

Could you provide some link to the above mentioned package? I have uninstalled and reinstalled visual studio ... cleaned up everything after i tried vs 2011 developer preview and of course i ran into this lovely problem.  As I have deleted the VS2011 ISO ... is there maybe a link on MSDN which provides the required package?

Thanking you for shedding light on the matter ...

Answer 21

Sorry for so late reply.

I've uploaded the vcruntime intall package(both x86 and x64) to skydrive.

Download then from this url:     https://skydrive.live.com/redir.aspx?cid=748a72eb6b9dea62&resid=748A72EB6B9DEA62!554&parid=748A72EB6B9DEA62!325

Answer 22

Thanks a lot. I saved lot time.