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!

On Feb 22, 7:21*am, Icy <I...@discussions.microsoft.com> 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

On Feb 23, 4:52*am, Sun Embraser <sunembraser2...@hotmail.com> wrote:
> On Feb 22, 7:21*am, Icy <I...@discussions.microsoft.com> 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- Hide quoted text -
>
> - Show quoted text -

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