+ Reply to Thread
Results 1 to 3 of 3

Checksum problem on system database

  1. Checksum problem on system database

    Hey there,

    we're having an issue with the SQL (MSDE) database that sharepoint uses.
    The service starts and immediately stops. In the logs (in dutch) there's
    an error: "Het checksumbestand van de systeemdatabase heeft een
    ongeldige ondertekening." freely translated it says "The checksumfile
    from the system database has a invalid signature".

    Anyone know how to solve this or where start searching? Does SQL have
    something like eseutil I might try to repair the database?

    TIA

  2. Re: Checksum problem on system database

    hi,
    Freaky wrote:
    > Hey there,
    >
    > we're having an issue with the SQL (MSDE) database that sharepoint
    > uses. The service starts and immediately stops. In the logs (in
    > dutch) there's an error: "Het checksumbestand van de systeemdatabase
    > heeft een ongeldige ondertekening." freely translated it says "The
    > checksumfile from the system database has a invalid signature".
    >
    > Anyone know how to solve this or where start searching? Does SQL have
    > something like eseutil I might try to repair the database?


    if you have a valid master database backup, you can restore it as indicated
    in http://msdn2.microsoft.com/en-us/lib...7(SQL.80).aspx and
    http://msdn2.microsoft.com/en-us/lib...9(SQL.80).aspx ... if you
    don't, you are in trouble, as MSDE does not provide the Rebuild utility
    (rebuildm.exe) and the scripts to re-generate it.. if this is the case, you
    have to uninstall and reinstall the MSDE instance.. you can or course keep
    your user's databases files an re-attach them once re-installed..
    regards
    --
    Andrea Montanari (Microsoft MVP - SQL Server)
    http://www.asql.biz http://italy.mvps.org
    DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
    --------- remove DMO to reply



  3. Re: Checksum problem on system database

    Hey Andrea,

    thx for the re. I was already afraid I would have to reinstall. It's the
    instance from sharepoint. We do maintenance at a lot of customers and
    some have full SQL versions so perhaps I could use the rebuildm tool
    there. But reinstalling sharepoint and replacing the database STS and
    STS_Config might be faster as I think those are the only ones that matter.

    Anyways thanks again :)

    Andrea Montanari wrote:
    > hi,
    > Freaky wrote:
    >> Hey there,
    >>
    >> we're having an issue with the SQL (MSDE) database that sharepoint
    >> uses. The service starts and immediately stops. In the logs (in
    >> dutch) there's an error: "Het checksumbestand van de systeemdatabase
    >> heeft een ongeldige ondertekening." freely translated it says "The
    >> checksumfile from the system database has a invalid signature".
    >>
    >> Anyone know how to solve this or where start searching? Does SQL have
    >> something like eseutil I might try to repair the database?

    >
    > if you have a valid master database backup, you can restore it as indicated
    > in http://msdn2.microsoft.com/en-us/lib...7(SQL.80).aspx and
    > http://msdn2.microsoft.com/en-us/lib...9(SQL.80).aspx ... if you
    > don't, you are in trouble, as MSDE does not provide the Rebuild utility
    > (rebuildm.exe) and the scripts to re-generate it.. if this is the case, you
    > have to uninstall and reinstall the MSDE instance.. you can or course keep
    > your user's databases files an re-attach them once re-installed..
    > regards


+ Reply to Thread