Hi, and welcome!
Which version of Championship Manager are you trying to run? It’s hard to troubleshoot without further information, but in general, you should just follow the error message. Run setsound.exe (use Magic Dosbox game profile to set it up as setup file, then run setup), set soundcard to Soundblaster Pro / 16, and see if it works.