Hi Ritesh,
Follow the steps mentioned by Krishna in his post. Further more I suggest you to download and install any terminal emulator like Teraterm, Putty, Mtty etc. and try the loop back test.
Just connect the cable, open the emulator, set the baud rate and all, in connect option give the same port number which you’ve seen in the device manager.
Now short pin2 and pin3 of db9 connector by any means. If you are getting the same letters in the emulator screen which you’ve typed, means your cable is 100% working.