question

ITtechy25-6810 avatar image
0 Votes"
ITtechy25-6810 asked AmeliaGu-msft commented

SQL Server Management Studio Download

Hello!

I'm new to SQL Server and is trying to download SQL Server Management Studio, is currently faced with some technical issues when trying to load the software.

When i tried to open the studio app, i will get prompt with MSCVR120.dll error Image:
80501-error-part-4.png

I have tried to search online for some solutions and all, but been stuck with this issue for a long while, can someone please advice :(

80494-system32-part-3.png

I did tried to copy and paste MSCVR120.dll into System32, but was prompted with the error above. I then tried some solutions suggested by online by using run command to "resmon.exe" and cmd with the following code

80430-cmd-part-2.png

But none of these seem to be able to solve the problem of missing MSCVR120.dll


sql-server-generalazure-sql-database
error-part-4.png (114.6 KiB)
system32-part-3.png (34.5 KiB)
cmd-part-2.png (42.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ITtechy25-6810,
Was your issue resolved?
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·
KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered

@ITtechy25-6810 Thank you for reaching out.

This issue usually occurs because of missing Visual C++ Redistributable Packages on your machine.

You can download and install the package from here
Please ensure you are downloading the right version.
If you are running a 64bit version of Windows, download vcredist_x64.exe, for 32bit version download vcredist_x86.exe

After the installation, try installing SSMS again.


If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @ITtechy25-6810,
Are there any updates on this issue?
As KalyanChanumolu mentioned, MSVCR120.DLL is part of Microsoft Visual C++ 2013 Redistributable package. Please make sure you have installed it.
In addition, if the “the action cannot be completed because the folder or a file in it is open in another program” occurs again, you can go to Resource Monitor ->CPU tab, than search folder or file name in Associated Handles.
80924-01.jpg
You can identify the process by looking at the Image or PID column and then kill it if it is not necessary.
Please refer to this article which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread



01.jpg (98.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ITtechy25-6810 avatar image
0 Votes"
ITtechy25-6810 answered ErlandSommarskog commented

Hi Kalyan and Amelia, thank you for your prompt responses! Still didnt managed to resolve the installation issue, though its no longer MSCVP120.dll error. It's now "The application was unable to start correctly (0xc000007b)."

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you get this when you try to run SSMS? Or is that the Setup?

What OS do you have=

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @ITtechy25-6810,

The application was unable to start correctly (0xc000007b).

Could you please try to download and install 32-bit version of the Microsoft Visual C++ 2013 Redistributable? The SSMS the application on certain 32-bit DLLs. Please refer to this similar thread which might help.
Best Regards,
Amelia


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.