Hi,

I am trying to setup MCMS on a production environment.
When I run the DCA (Database Configuration Application) I am not able to
configure a trusted connection ('Use Trusted Connection' checked):

'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 the
previously defined MCMS system account have the following database
proviliges: db_datareader, db_datawriter and db_ddladmin'

I set up an account for MCMS to use as System Account, granted it a login to
the database and the db_datareader, db_datawriter and db_ddladmin roles.
Even if I try an Administrator (my own) account which has the db_owner and
the aforementioned roles, I still get the same error message.

This leads me to believe there is actually not a rights problem, but
something else must be going on.
What are 'DBO rights' anyway? I only know of the db_owner role and the dbo
user.

Can somebody shed some light on this?

Thx in Adv.,

Eric

[ Post a follow-up to this message ]

Hi

DBO are db_owner.

Is your DB on the same server than MCMS ? If not, you might have to use SQL
Server authentication and not Windows trusted authentication because your
system account will not be recognized on the db server.

Cédric

Eric van Wijk wrote:
> Hi,
>
> I am trying to setup MCMS on a production environment.
> When I run the DCA (Database Configuration Application) I am not able
> to configure a trusted connection ('Use Trusted Connection' checked):
>
> '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 the previously defined MCMS system account have the
> following database proviliges: db_datareader, db_datawriter and
> db_ddladmin'
>
> I set up an account for MCMS to use as System Account, granted it a
> login to the database and the db_datareader, db_datawriter and
> db_ddladmin roles. Even if I try an Administrator (my own) account
> which has the db_owner and the aforementioned roles, I still get the
> same error message.
>
> This leads me to believe there is actually not a rights problem, but
> something else must be going on.
> What are 'DBO rights' anyway? I only know of the db_owner role and
> the dbo user.
>
> Can somebody shed some light on this?
>
> Thx in Adv.,
>
> Eric

[ Post a follow-up to this message ]

Hi Eric,

if you are using SQL authentication you need to give the CMS system account
dbo rights. db_datareader, db_datawriter and db_ddladmin are only sufficient
for windows authentication. Then the user running the DCA requires DBO
rights.

This means: the user accessing the database when running the DCA requires to
have DBO rights.
In addition you need to assign this user directly as SQL user. It is not
sufficient to assign an AD group this user is a member of as the SQL script
running inside the DCA does not check this.

Cheers,
Stefan.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

MCMS FAQ:
http://download.microsoft.com/downl...>
MCMS+2002+-+(complete)+FAQ.htm
MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
MCMS Sample Code:
http://www.gotdotnet.com/community/...nagement+Server
MCMS Whitepapers and other docs:
http://blogs.msdn.com/stefan_gossne...2/07/41859.aspx
--------------------------------


"Eric van Wijk" <eric@van-wijc.kom> wrote in message
news:epQud13rEHA.3520@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I am trying to setup MCMS on a production environment.
> When I run the DCA (Database Configuration Application) I am not able to
> configure a trusted connection ('Use Trusted Connection' checked):
>
> '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 the
> previously defined MCMS system account have the following database
> proviliges: db_datareader, db_datawriter and db_ddladmin'
>
> I set up an account for MCMS to use as System Account, granted it a login
to
> the database and the db_datareader, db_datawriter and db_ddladmin roles.
> Even if I try an Administrator (my own) account which has the db_owner and
> the aforementioned roles, I still get the same error message.
>
> This leads me to believe there is actually not a rights problem, but
> something else must be going on.
> What are 'DBO rights' anyway? I only know of the db_owner role and the dbo
> user.
>
> Can somebody shed some light on this?
>
> Thx in Adv.,
>
> Eric
>
>

[ Post a follow-up to this message ]

Hi,

I solved the problem.
Instead of creating a login for the system account directly, I used an NT
group before (of which the account is a member). The login has the same
roles, and it works.

Thx All,

Eric


"Stefan [MSFT]" <stefang@online.microsoft.com> wrote in message
news:eKUl4A4rEHA.3848@TK2MSFTNGP14.phx.gbl...
> Hi Eric,
>
> if you are using SQL authentication you need to give the CMS system
> account
> dbo rights. db_datareader, db_datawriter and db_ddladmin are only
> sufficient
> for windows authentication. Then the user running the DCA requires DBO
> rights.
>
> This means: the user accessing the database when running the DCA requires
> to
> have DBO rights.
> In addition you need to assign this user directly as SQL user. It is not
> sufficient to assign an AD group this user is a member of as the SQL
> script
> running inside the DCA does not check this.
>
> Cheers,
> Stefan.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> MCMS FAQ:
> http://download.microsoft.com/downl...
a/MCMS+2002+-+(complete)+FAQ.htm
> MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> MCMS Sample Code:
> http://www.gotdotnet.com/community/...nagement+Server
> MCMS Whitepapers and other docs:
> http://blogs.msdn.com/stefan_gossne...2/07/41859.aspx
> --------------------------------
>
>
> "Eric van Wijk" <eric@van-wijc.kom> wrote in message
> news:epQud13rEHA.3520@TK2MSFTNGP11.phx.gbl... 
> to 
>
>

[ Post a follow-up to this message ]