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

Status
Not open for further replies.
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

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
 
S

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
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
C Moving BCM Database to Server Share BCM (Business Contact Manager) 1
D can you share a bcm database with 2 different versions of windows? BCM (Business Contact Manager) 0
P Can I share or copy my Outlook/BCM Custom Views with another non-Exchange user? Using Outlook 1
P Outlook 2013 Word Share doc as Email Attachment now brings up Eudora. Using Outlook 1
S automate save the .xlxs file to share Network Using Outlook 1
R Can't Send calendar share invite Using Outlook 5
G Unable to dismiss reminders from share point list calendar shared in Outlook Using Outlook 2
Patrick van Berkel Best way to share (and keep up-to-date) Macro's in Outlook 2010 Outlook VBA and Custom Forms 6
R Making Outlook default client in share charm Using Outlook 4
Miquela I need to make a calendar to share here at work with 40 other people Using Outlook 1
Fozzie Bear Wishlist To be able to add a local folder or network share location in foldern view Outlook Wishlist 1
smokiibear Share Office 365 Tasks such that Other Users also Are Alerted with Reminder Using Outlook 1
T How to share Outlook SUBfolders Using Outlook 3
J Share calendar but don't share categories Exchange Server Administration 1
L Can't share email folders Exchange Server Administration 1
K Outlook keeps prompting for Microsoft username and password for share calendar Using Outlook 0
L Archive Shared Folders for all to Share Using Outlook 0
R Share mailbox issue Exchange Server Administration 0
B Is there a simple way to share email folders w/o exchange server? Using Outlook 0
C How do I share/post my calendar to public folders Exchange Server Administration 3
W Outlook 2010 Share calendar but keep color formatting Using Outlook 2
A Share recurrent events with others Using Outlook 2
P Created new profile, how do I share existing contacts/calendar? Using Outlook 1
S Can't share contacts in Outlook on MS Exchange Server??? Exchange Server Administration 1
S Share between 2000 and 2010 Using Outlook 3
R Disable request to share a calendar Using Outlook 1
S share Outlook folders with other old versions Using Outlook 1
H Cannot share calendar, global address book not updating Exchange Server Administration 1
P Share Outlook 2011 Calendar Using Outlook 2
R Best way to share outlook calendar with 10 laptops Using Outlook 9
R Share ost between connector and exchange cache mode = "everything everywhere" Using Outlook 3
L How to share contacts stored in Outlook 2007 for other user. Using Outlook 2
à Loss the file share witness of DAG Exchange Server Administration 4
G Share calendar between two Outlook 2010 OR 2007 without exchange where both users can make appointme Using Outlook 1
M Share or Copy Calendar from one user to the other Using Outlook 1
M download emails and share with multiple users on Outlook 2003 while holding read and flagged status Using Outlook 2
M Share my Calender is not available in my Outlook 2007 Using Outlook 3
F Error preparing to share contacts Using Outlook 1
T How do you share an address book from a mac with a PC? Using Outlook 4
S Can't share calendar out Using Outlook 3
S Me and my big mouth...I said to my customer a district nursing organization down here in New Zealand, that 2 ipaqs should be able to share the same Co Using Outlook 1
B Use POP3 for mail, but share Exhange calendar - not personal folder calendar Using Outlook 3
M Share Contacts greyed out in Outlook 2010. Using Outlook 1
C How to share only out-of-office appointments from my calendar to a group's shared calendar. Using Outlook 1
H Share calendars without Microsoft Exchange Using Outlook 6
P Cannot save new Outlook 2007 message as a Word template to share Building Blocks/Quick Parts Using Outlook 2
D Outlook PST file on DFS share Using Outlook 4
A share one record for autodiscover between exch 2007 and exch 2010 Exchange Server Administration 4
R DAG File Share Witness Permissions Exchange Server Administration 5
A Alternate file share witness - creation of... Exchange Server Administration 4
Similar threads


















































Top