| Trevor Grant 2004-02-25, 9:44 am |
| Hi
The DCA shows a list of databases for which you have at
least ddladmin, db_datareader, db_datawriter rights. And
if it's a brand new database, MCMS needs you to give the
user at least dbo permissions to run the scripts.
So, for trusted connections, ensure that the MCMS System
account has the necessary rights. The same applies for SQL
users.
Trevor
>-----Original Message-----
>Hi, I have been working with the DCA for long, yesterday
i wanted to
>change the CMS database from CMS-Old to CMS-New.
>i created the database on the SQL server, it is a local
server and i
>am the administrator on the machine and the database
server.
>when i ran the DCA and wanted to selec the CMS-New as the
database,
>i couldnt find it in the list
>the only databases available in the list is the default
that used to
>come with SQL and the CMS-Old only
>i tried to create more databases, give the NT account
more power,
>i even stoped the SQL service, and also restarted Windows
>but with no use :'(
>i dont know what got wrong
>i have made this many times that day
>changed alot of databases on that day
>but at the end of the day that was my situation
>
>thanks in advance guys
>.
>
|