DCA and SQL login KB913400


When configuring an MCMS in the production environment I did not have access to an Active Directory. I therefore used an SQL logon to access the database with the DCA. Unfortunately I received the following message regardless of granting the SQL login DBO access to the database.

Error verifying rights: Using a SQL Login to access the database requires that this Login have DBO rights because it is used by this application to configure the database. Using Trusted Authentication to access the database only requires that the previously defined MCMS system account have the following database privileges: db_datareader, db_datawriter and db_ddladmin.

I found that Microsoft have release a hotfix KB913400 on 26 July, 2006 that resolves this issue. You will need to log a support call with Microsoft.

Comments (2)

  1. williamcornwill says:

    Anonymous Says:

    November 23, 2006 at 9:08 am

    if get the hot fix & solve your issue please let us know, we are facing the same issue.

  2. williamcornwill says:

    William Cornwill Says:

    November 23, 2006 at 9:10 am

    The hotfix I mentioned in this article fixes the issue, this is why I posted this entry.

Skip to main content