How to remove node-red-contrib-mssql

I suspect you have not ran npm in the correct directory.

Your node-red directory is typically c:\users\user\.node-red\

That is where you should run the npm command

If in doubt, look at the log output that node-red shows when you start it - you will see the user directory in the log output.