Hi there,

I have an MCMS install on a Server. Due to problems with another MCMS
deployment we moved this server into a different domain (outside a DMZ) and
installed SQL 2005 on the machine. We then did a restore of the MCMS databas
e
on this machine.
When we try to configure the DCA tool, it sees the database and allows us to
connect to it but when we click OK it comes up with the error:

"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
priveleges: db_datareader, db_datawriter and db_ddladmin"

We have installed the DCA hotfix
We have added the logged in user (that is doing the configuration of DCA
tool) as part of sysadmin role in SQL 2005
The SQL Server is on the same machine as the MCMS.

The only problems i can think of are
1. the SQL Server 2005 does not have the service pack
2. the mcms is confused since we changed the domain which the server belongs
too?

What else can I do to troubleshoot? Is there a way to bypass the DCA tool as
I always have problems with it!

[ Post a follow-up to this message ]

Hi Matt,

when using integrated authentication you need to ensure that the user
running the DCA has dbo rights.
Please add this user to the logins of the SQL server (directly - not only in
a group as this will not work). Then run exec sp_changedbowner and change
the dbowner to the user to the user running the DCA.

That should od the job.

Cheers,
Stefan


"Matt Calhoon" <matt@community.nospam> wrote in message
news:6B26033B-5CCA-44C6-AD32-D794C3A5B899@microsoft.com...
> Hi there,
>
> I have an MCMS install on a Server. Due to problems with another MCMS
> deployment we moved this server into a different domain (outside a DMZ)
> and
> installed SQL 2005 on the machine. We then did a restore of the MCMS
> database
> on this machine.
> When we try to configure the DCA tool, it sees the database and allows us
> to
> connect to it but when we click OK it comes up with the error:
>
> "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
> priveleges: db_datareader, db_datawriter and db_ddladmin"
>
> We have installed the DCA hotfix
> We have added the logged in user (that is doing the configuration of DCA
> tool) as part of sysadmin role in SQL 2005
> The SQL Server is on the same machine as the MCMS.
>
> The only problems i can think of are
> 1. the SQL Server 2005 does not have the service pack
> 2. the mcms is confused since we changed the domain which the server
> belongs
> too?
>
> What else can I do to troubleshoot? Is there a way to bypass the DCA tool
> as
> I always have problems with it!
>
>

[ Post a follow-up to this message ]