I am running MCMS 2002 on a Win2k server and using a separate SQL 2000
server for the database(s).

I have multiple independent websites, each has their own IP.  I would
like for each website to use their own independent SQL database.  Is
this possible?

When I have set the new website up with its own database, I am not
able to get into the first website because that database is no longer
selected.  Am I missing something here?

I hope someone can answer this question for me and how to go about it
correctly.  I do not want all the websites using the same database as
they are different entities altogether.

TIA

[ Post a follow-up to this message ]

Hi,

a MCMS server can only connect to one single database. So it is not possible
to store different sites in different databases.

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


"ettropics" <edy.ting@sbcglobal.net> wrote in message
news:99d9d4a8.0408251548.6282f6d4@posting.google.com...
> I am running MCMS 2002 on a Win2k server and using a separate SQL 2000
> server for the database(s).
>
> I have multiple independent websites, each has their own IP.  I would
> like for each website to use their own independent SQL database.  Is
> this possible?
>
> When I have set the new website up with its own database, I am not
> able to get into the first website because that database is no longer
> selected.  Am I missing something here?
>
> I hope someone can answer this question for me and how to go about it
> correctly.  I do not want all the websites using the same database as
> they are different entities altogether.
>
> TIA

[ Post a follow-up to this message ]

Hi,

The relationship between MCMS's Server Components + Database is many-to-one.

The DCA is 'website' independent and will store the connection string in the
registry keys.

You shouldn't have a problem if you use 1 database and create seperate
channels under /Channels

Regards


--
 ________________________________________


Angus Logan  (MCAD/MCDBA/MCP)
Lead Software Developer
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
 ________________________________________


"ettropics" <edy.ting@sbcglobal.net> wrote in message
news:99d9d4a8.0408251548.6282f6d4@posting.google.com...
> I am running MCMS 2002 on a Win2k server and using a separate SQL 2000
> server for the database(s).
>
> I have multiple independent websites, each has their own IP.  I would
> like for each website to use their own independent SQL database.  Is
> this possible?
>
> When I have set the new website up with its own database, I am not
> able to get into the first website because that database is no longer
> selected.  Am I missing something here?
>
> I hope someone can answer this question for me and how to go about it
> correctly.  I do not want all the websites using the same database as
> they are different entities altogether.
>
> TIA

[ Post a follow-up to this message ]

Thank you both for the answers you provided. Our organization's
security policy requires that each independent CMS project is to have
it's own dedicated database.  From what you both have said, this is
not possible.

I was under the impression from a book source that you could create
multiple CMS sites on one server, each using an Indpendent Dedicated
Database.  I tried it again after hours and it does not work, as one
database is switched to another to set up for a new CMS site, it shuts
the other website down even after the IIS services have been
restarted.  The DBA is a tool to switch between DBA's, of what use is
the DBA if you can only use one running database at a time?  In what
scenario would you be able to use multiple databases, where each would
function simultaneously?

Thank you for any and all feedback regarding these questions.

"Angus Logan" <angus_logan@data3.com.au> wrote in message news:<#aJmVKwiEHA.396@TK2MSFTNGP12
.phx.gbl>...[vbcol=seagreen]
> Hi,
>
> The relationship between MCMS's Server Components + Database is many-to-on
e.
>
> The DCA is 'website' independent and will store the connection string in t
he
> registry keys.
>
> You shouldn't have a problem if you use 1 database and create seperate
> channels under /Channels
>
> Regards
>
>
> --
>  ________________________________________

>
> Angus Logan  (MCAD/MCDBA/MCP)
> Lead Software Developer
> Microsoft Application Solutions
> Data#3 Limited
> E angus_logan@data3.com.au
> BLOG www.anguslogan.com
>  ________________________________________

>
> "ettropics" <edy.ting@sbcglobal.net> wrote in message
> news:99d9d4a8.0408251548.6282f6d4@posting.google.com... 

[ Post a follow-up to this message ]

Quite simple:
If each project is hosted on a different MCMS server connected to a
different MCMS database.

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


"ettropics" <edy.ting@sbcglobal.net> wrote in message
news:99d9d4a8.0408260715.62bbfe3@posting.google.com...
> Thank you both for the answers you provided. Our organization's
> security policy requires that each independent CMS project is to have
> it's own dedicated database.  From what you both have said, this is
> not possible.
>
> I was under the impression from a book source that you could create
> multiple CMS sites on one server, each using an Indpendent Dedicated
> Database.  I tried it again after hours and it does not work, as one
> database is switched to another to set up for a new CMS site, it shuts
> the other website down even after the IIS services have been
> restarted.  The DBA is a tool to switch between DBA's, of what use is
> the DBA if you can only use one running database at a time?  In what
> scenario would you be able to use multiple databases, where each would
> function simultaneously?
>
> Thank you for any and all feedback regarding these questions.
>
> "Angus Logan" <angus_logan@data3.com.au> wrote in message
news:<#aJmVKwiEHA.396@TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen] 
many-to-one.[vbcol=seagreen] 
the[vbcol=seagreen] 

[ Post a follow-up to this message ]

Hi

Another option is to host all the content in a single database and use MCMS
user roles to decide the access given to users. If this is not acceptable,
then Stefan's solution is the only way that works for multiple databases.

Mei Ying

"Stefan [MSFT]" <stefang@online.microsoft.com> wrote in message
news:edwjGF4iEHA.704@TK2MSFTNGP09.phx.gbl...
> Quite simple:
> If each project is hosted on a different MCMS server connected to a
> different MCMS database.
>
> Cheers,
> Stefan.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> MCMS FAQ:
>

> MCMS Blog: [url]http://blogs.msdn.com/stefan_gossner/category/4983.aspx" target="_blank">http://download.microsoft.com/downl...egory/4983.aspx
> MCMS Sample Code:
>
http://www.gotdotnet.com/community/...
+Server
> MCMS Whitepapers and other docs:
> http://blogs.msdn.com/stefan_gossne...2/07/41859.aspx
> --------------------------------
>
>
> "ettropics" <edy.ting@sbcglobal.net> wrote in message
> news:99d9d4a8.0408260715.62bbfe3@posting.google.com... 
> news:<#aJmVKwiEHA.396@TK2MSFTNGP12.phx.gbl>... 
> many-to-one. 
in[vbcol=seagreen]
> the 
2000[vbcol=seagreen] 
would[vbcol=seagreen] 
longer[vbcol=seagreen] 
it[vbcol=seagreen] 
as[vbcol=seagreen] 
>
>

[ Post a follow-up to this message ]