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.
Similar threads
Thread starter Title 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
M Unable to share 2019 calendar Using Outlook 0
D How To Combine Share Task Folders in just one Folder Using Outlook 0
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
J Can multiple exchange users share same categories? Exchange Server Administration 4
N How do you share your business contact manager with coworkers BCM (Business Contact Manager) 1
B Post form into share calendar Outlook VBA and Custom Forms 1
S share business contact manager BCM (Business Contact Manager) 3
P Database User Share Disconnecting BCM (Business Contact Manager) 4
S can't share databse BCM (Business Contact Manager) 1
Q Opening email from a share breaks add-in Outlook VBA and Custom Forms 15
J Can't Share Database BCM (Business Contact Manager) 4
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
R Follow up button doesn't working neither the reminders in BCM BCM (Business Contact Manager) 0
P BCM conditional formatting BCM (Business Contact Manager) 5
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
D BCM 2013 not functioning as BCM 2010 Example no drop down for communications history Using Outlook 0
J No access to a Database BCM BCM (Business Contact Manager) 3
J Marketing task MS BCM BCM (Business Contact Manager) 10
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
A BCM does not work anymore! BCM (Business Contact Manager) 1
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4

Similar threads

Top