Can I share BCM V2 Database on 2003 by using BCM Data Admin Tool

[Icy]

I created a BCM database in my local machine and I would like to move it to

the server so other machines on the network can have access to it as well. I

used osql -E -S command to stop the BCM database from my machine and moved it

to the server, and I re-attached BCM database from the server.

EXEC sp_attach_db @dbname = N'STS_Config', @filename1 =

N'C:\new_database_location\STS_Config.mdf', @filename2 =

N'C:\new_database_location\STS_Config_log.ldf'

Can I have other machine attach to the Database in the server the same way?

Since I am the owner, I still have to give permission to user to access it.

But I would rather perfer to have Admin on the server have the total control

of DB. It seems MS2007 BCM Data Admin Tool is the way to go, but does it work

on the database created by BCM V2 on MS2003?

I installed the BCM Data Admin Tool + SQL 2005 Express, when I launch the

Admin Tool it did not find the BCM Instance, is there a special way to

configure that?

Any help will be greatly appreciated.

Thanks!

 

[Sun Embraser]

On Feb 22, 7:21 am, Icy <I...> wrote:
> I created a BCM database in my local machine and I would like to move it to
> the server so other machines on the network can have access to it as well.. I
> used osql -E -S command to stop the BCM database from my machine and moved it
> to the server, and I re-attached BCM database from the server.

> EXEC sp_attach_db @dbname = N'STS_Config', @filename1 =
> N'C:\new_database_location\STS_Config.mdf', @filename2 =
> N'C:\new_database_location\STS_Config_log.ldf'

> Can I have other machine attach to the Database in the server the same way?
> Since I am the owner, I still have to give permission to user to access it.
> But I would rather perfer to have Admin on the server have the total control
> of DB. It seems MS2007 BCM Data Admin Tool is the way to go, but does it work
> on the database created by BCM V2 on MS2003?

> I installed the BCM Data Admin Tool + SQL 2005 Express, when I launch the
> Admin Tool it did not find the BCM Instance, is there a special way to
> configure that?

> Any help will be greatly appreciated.
> Thanks!

Hi Icy,

The Admin Tool for BCM 2007 only works with BCM 2007 databases and

does not work with BCM 2003 databases.

There might be ways for moving V2 database to a server but I don't

have an answer for you yet.

John

 

[Sun Embraser]

On Feb 23, 4:52 am, Sun Embraser <sunembraser2...@hotmail.com> wrote:
> On Feb 22, 7:21 am, Icy <I...> wrote:

>
> > I created a BCM database in my local machine and I would like to move it to
> > the server so other machines on the network can have access to it as well. I
> > used osql -E -S command to stop the BCM database from my machine and moved it
> > to the server, and I re-attached BCM database from the server.
>
> > EXEC sp_attach_db @dbname = N'STS_Config', @filename1 =
> > N'C:\new_database_location\STS_Config.mdf', @filename2 =
> > N'C:\new_database_location\STS_Config_log.ldf'
>
> > Can I have other machine attach to the Database in the server the same way?
> > Since I am the owner, I still have to give permission to user to accessit.
> > But I would rather perfer to have Admin on the server have the total control
> > of DB. It seems MS2007 BCM Data Admin Tool is the way to go, but does it work
> > on the database created by BCM V2 on MS2003?
>
> > I installed the BCM Data Admin Tool + SQL 2005 Express, when I launch the
> > Admin Tool it did not find the BCM Instance, is there a special way to
> > configure that?
>
> > Any help will be greatly appreciated.
> > Thanks!

> Hi Icy,
> The Admin Tool for BCM 2007 only works with BCM 2007 databases and
> does not work with BCM 2003 databases.
> There might be ways for moving V2 database to a server but I don't
> have an answer for you yet.
> John-



I heard that there are white papers on support.microsoft.com that

talks about how to do this in BCM 2003. You should give that a try.

John