The Environment:
- Windows Server 2019 Standard
- SQL Server 2019 Standard
- SQL CMDLINE Utitlies V15 for x64
- ODBC Driver 17 for x64
The Problem:
I am trying to run the sqlcmd command in Powershell and Command Prompt. When I run it in PowerShell such as sqlcmd -? nothing happens, it just returns to c:\Windows\system32\. When I run sqlcmd -? in Command Prompt it throws the following error:
The application was unable to start correctly (0xc000007b). Click OK to close the application.
I am not sure why I am getting this error. This is nothing in the system logs. I did find this fix on here but I have Visual C++ Redistributables from 2005, 2008, 2012, 2013, 2015-2019 for the software I have running on the server. Many of those running both x86 an x64 versions.
The Question:
What is causing the 0xc000007b error from allowing me to run my sqlcmd command? And if it is an issue with the Visual C++ version, do I need all the previous year versions or can I remove all of those and just use the 2015-2019 versions (x64 & x86) as they are the latest? And to fix this issue would I do a repair of those Redistributables or uninstall or reinstall?
UPDATE Uninstalled the CMDLINE tools for 32 bit and installed 64bit tools and still can't get sqlcmd -? to show anything. If I invoke the .exe and use the commands nothing happens. Does anyone have any other ideas?