Home > .net 1.1, MCMS 2002, SQL > MCMS 2002 SP2 & SQL Server 2005 Provider Timeout Fix

MCMS 2002 SP2 & SQL Server 2005 Provider Timeout Fix

November 28, 2006

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.

Until today.

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.

Categories: .net 1.1, MCMS 2002, SQL
  1. Derek
    February 18, 2007 at 5:58 pm

    Can you please tell me where you got the hotfix files from? I am having the same problem and cannot seem to find the hotfix files.

    Look forward to hearing from you ASAP

    Regards,
    Derek

  2. February 18, 2007 at 6:18 pm

    Derek-

    Contact Microsoft Support and reference Article #913401. The call and hotfix are free.

    http://support.microsoft.com/oas/default.aspx?ln=en-us&c1=508&x=15&y=9&prid=4655&gprid=34909

    The developer number is what you’re looking for.

    Good luck!

    -dl

  3. Derek
    March 5, 2007 at 4:53 pm

    thanks David, that worked out well.

    Cheers,
    Derek

  1. No trackbacks yet.
Comments are closed.
%d bloggers like this: