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.

3 Responses to DCA and SQL login KB913400

  1. Anonymous says:

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

  2. William Cornwill says:

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

  3. Great site and interesting reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: