I had this problem and I tried everything anyone told me, but it still didn't work. I tried uninstalling X3 along with deleting the reg entries, I tried the resetting and rescanning of my VSTs and that didn't work. The only way I did get it to work was to go into my VST plugins folder (C:\Program Files\Cakewalk\VSTPlugins) and delete the folder named Session Drummer 3. Then I installed Sonar X2 and only selecting the Session Drummer 3 VST plugin to be installed. I unchecked everything else. When I did that and let X3 rescan, Session Drummer works. I don't know if you have X2 or not, but if you do, it may work for you.
Surely, there is another way to fix this, but I couldn't find it. It seems that the overwhelming majority don't have this problem, but some of us are.
By the way, the Session Drummer that X2 installs is not the same file size as the one X3 installs and I have never found out what the difference is. Anyone know ?
I hope this may be of help to you and would be interested to know if it works for you.
Ron