I resolved this issue myself after getting no help from tech support and in this case, I would have felt even worse if I wasted their time, so I'm glad I got no help! This is a lesson in stupidity on my part. I found a knowledge base article that led me to the solution based on the error message I was getting when I started up Media Manager.
Basically in my overzealousness to conserve CPU cycles on wasted processes running in the background, months ago I had turned off several processes from the "Services" list in WinXP that I either couldn't identify as necessary or that I thought weren't necessary. Unfortunately, one of them was the Pinnacle process for the media manager which then also starts up other MS SQL Server processes when it starts, so none of them were running on my computer!
Naturally the ShowCenter 200 couldn't communicate with the PC nor could the Media Server software communicate with the underlying database, which is an MS SQL Server database.
After setting the appropriate services back to "Automatic" all problems resolved.
A good lesson learned on my part!
