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

I

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

Sun Embraser

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
 
S

Sun Embraser

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top