Here is what Seth said on the Steam forums:
"There are 2 ways:
1. You'll need to install Cakewalk Sound Center application through Steam. Products purchased on Steam are only available to download through the Steam Client.
You can point SONAR's VST scanner to '[steamlibrary]\common\Cakewalk\Vstplugins\' location and they should work fine.
2. Alternatively, if you wanted to use the direct installer, you'll need to copy and backup the multisamples under:
'[steamlibrary]\common\Cakewalk\Vstplugins\Cakewalk Sound Center'
and the Programs under:
'[steamlibrary]\common\Cakewalk\Cakewalk Content\Cakewalk Sound Center\' from the Steam locations
Then copy them into the direct locations:
%appdata%\cakewalk\cakewalk sound center - for programs
Program Files(x86)\Cakewalk\Vstplugins - for multisamples"
The problem is that I wiped and reloaded my PC when I switched to the non-steam version. My OS was really wonky due to having so many versions of Cakewalk software installed. I posted this and will let you know how he replies.