Additional SQL Server features and topics not covered by specific categories
Hi @Shweta Mane ,
As soon as we know the DLLs was missing, we don’t know how many such more DLLs might be missing. Based on my search on the internet it comes from Visual Studio Shell (vc_red.msi). I asked them to install VS Shell from SQL media and meantime, copy that missing file from a working machine. As soon as file was copied, we were able to connect SQL using SQLCMD and then we start SQL server normally.
For more details , please see:
https://blog.sqlauthority.com/2017/05/11/sql-server-not-load-dll-xpstar-dll-one-dlls-references/
Best regards
Niko
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".