I got this and it wasn't a DMZ issue. Give your current
logon account (the account running the DCA) dbowner
privelege to the database in SQL and it should work

- Adam

>-----Original Message-----
>Hi all
>
>When creating an new MCMS database from the DCA, the
installation does not cause any problem and everything is
OK.  My SQL server and my MCMS server are on the same
domain.
>
>But if my MCMS installation is in a server wich is in
workgroup (DMZ) and my SQL Server Database is in the
domain, I receive this error:
>
>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 confgure 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.
>
>My local users (MCMS Server and SQL Server) have the
same credentials and they do have the rights mentionned
above.
>
>What are we doing wrong? Is it on the SQL Server side
that we have a problem?
>.
>

[ Post a follow-up to this message ]

Hi Luc,

I'm not a SQL expert and this is an SQL related question - MCMS uses ODBC.
I always used SQL auth in this scenario. The database access code did not
change between RTM and SP1 - means the same connection string settings and
impersonation code is used - so there should not be a difference between SP1
and RTM.
I would suggest to follow up on an ODBC/SQL related newsgroup as the guys
there should know better what to do.

The configuration dialog shown in DCA is a dialog from SQL DMO btw - so also
no MCMS dialog.

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
--------------------------------


"Luc" <Luc@discussions.microsoft.com> wrote in message
news:DEEC053B-8EFE-473F-B03C-92D8D5AE54C8@microsoft.com...
> Hi Stephan.  Thank's for your reply.
>
> Is that new since CMS SP1?  Because we installed CMS RTM using Windows
integrated and it worked fine.
>
> Do we have to work in mixed mode in SQL Server?  If so, do we have to fix
it in the SQL Server Group?[vbcol=seagreen]
>
> "Stefan [MSFT]" wrote:
> 
database.[vbcol=seagreen] 
rights.[vbcol=seagreen] 
http://download.microsoft.com/downl...
+Server[vbcol=seagreen] 
not[vbcol=seagreen] 
server[vbcol=seagreen] 
and[vbcol=seagreen] 
DBO[vbcol=seagreen] 
the[vbcol=seagreen] 
and[vbcol=seagreen] 

[ Post a follow-up to this message ]