MCMS 2002 SP2 & SQL Server 2005 Provider Timeout Fix
Okay, so… annoying little bug. When attempting to export or import packages from MCMS 2002, I would constantly recieve an error that the SqlDataProvider has timed out and returned a (403) Forbidden HTTP error. The connect didn’t SEEM to time out–it was reading the channels in Site Manager just fine. The site itself worked just fine.
I’ve hunted for days to discover if it was a permission issue, a file location issue, or even a database issue. Nothing associated SP2 with time out issues–especially in regards to Site Manager.
KB913401 points out the EXACT error in “Content Management Server 2002 SP1a”. However, the text of the article refers to SP2, not SP1a. Meh.
After getting the hotfix, I installed, ran the DCA, had it ‘upgrade’ the database, and things work like a champ now!
A side note:
The instructions say to copy _dca.ini to the MCMS SQL Install folder. Copy BOTH files. The DCA will error out if the _sp1atosp2upgrade.sql file is not also present in that folder. I’m not sure why the MSFT article leaves that file out of the installation instructions.