CANNOT ACCES DATABASE BCM 2007

[Pachimke]

while trying to move the database(MDF & IDF) from my pc to my laptop i have
some problems.
I'm using bcm2007 on my PC(xppro) but wan to move it to my laptop(xphome).
I was searching for a quick way to move al my contacts & tasks. Also because
when i import a BCM file, the FULL NAME fields are all mixed up.
(i heard on the forum this is a bug). So i copy'd my database, 2 files
mssmalbusiness.mdf & idf to correct directory of BCM.(the files names are
identical like the new database i made) Everything like i read in the forum
on how to do this.
Here is my problem : when starting BCM i get a message that its not possible
to LOG ON, the pasword is not correct.(I never used a pasword on both
computers to log on)
I shut down outlook, after trying 2 time's i get a other error :
BCM cannot be loaded. This action cannot be completed because BCM cannot
acces the database. An error has occured while establishing a connection to
the server. When connecting to sql server 2007, this failure may be caused by
the fact that under the default setting sql server does not allow remote
connections.(provider:TCP provider, error : 0 - Host is unknown.)
Do you whant to change the database configuration ? --> no
So i placed back the "original" mdf and idf(with no data), trying to get
outlook started with no error message but i get the same error again.

The sqlserver is started, i checked that.
Maybee there is a problem because the 2 pc's has a differant logon(Computer
, Laptop) there is no network...

PLEASE help me... How can i move the MDF & IDF file and get al my contacts
and tasks back. I searched the complete forum, did not find a sollution.

Thanks !!!!!
Pachimke

 

[Luther]

while trying to move the database(MDF & IDF) from my pc to my laptop i have
some problems.
I'm using bcm2007 on my PC(xppro) but wan to move it to my laptop(xphome).
I was searching for a quick way to move al my contacts & tasks. Also because
when i import a BCM file, the FULL NAME fields are all mixed up.
(i heard on the forum this is a bug). So i copy'd my database, 2 files
mssmalbusiness.mdf & idf to correct directory of BCM.(the files names are
identical like the new database i made) Everything like i read in the forum
on how to do this.
Here is my problem : when starting BCM i get a message that its not possible
to LOG ON, the pasword is not correct.(I never used a pasword on both
computers to log on)
I shut down outlook, after trying 2 time's i get a other error :
BCM cannot be loaded. This action cannot be completed because BCM cannot
acces the database. An error has occured while establishing a connection to
the server. When connecting to sql server 2007, this failure may be caused by
the fact that under the default setting sql server does not allow remote
connections.(provider:TCP provider, error : 0 - Host is unknown.)
Do you whant to change the database configuration ? --> no
So i placed back the "original" mdf and idf(with no data), trying to get
outlook started with no error message but i get the same error again.

The sqlserver is started, i checked that.
Maybee there is a problem because the 2 pc's has a differant logon(Computer
, Laptop) there is no network...

PLEASE help me... How can i move the MDF & IDF file and get al my contacts
and tasks back. I searched the complete forum, did not find a sollution.

Thanks !!!!!
Pachimke

I suspect the problem is about attaching the database files you moved
to the new machine to the Sql Server on that machine.

I would install Sql Server Express Studio on the new machine.

Run it and connect to: yourmachinename\MSSMLBIZ

Then see if your BCM database is in the databases folder. If not,
you'll need to Attach the database files to the server; right-click on
the Databases folder and select Attach...

Once attached, try selecting that database in BCM.

 

[Pachimke]

Hi Luther, tnx for answering.
At this moment there is only sql server 2005 on the pc & laptop.
I will install sql server express studio. I don't understand how to connect
to the database folder, how to attach,...do i have to do that on each file ?
IDF & MDF ? or the complete directory of the IDF & MDF named "BUSINESS
CONTACT MANAGER"?
I will first start with installing sql server express studio, maybee than i
have that function to attach with the right click,i don't see it at this
moment when i right click on each file in windows explorer...

regards,
Pachimke

 

[Luther]

Hi Luther, tnx for answering.
At this moment there is only sql server 2005 on the pc & laptop.
I will install sql server express studio. I don't understand how to connect
to the database folder, how to attach,...do i have to do that on each file ?
IDF & MDF ? or the complete directory of the IDF & MDF named "BUSINESS
CONTACT MANAGER"?
I will first start with installing sql server express studio, maybee than i
have that function to attach with the right click,i don't see it at this
moment when i right click on each file in windows explorer...

regards,
Pachimke










- Show quoted text -

Sorry for the confusion. By databases folder I mean inside of Sql
Studio. Once Studio is connected to a Sql Server instance, you should
see a folder of databases on that server in Studio. Attaching a
database file is an action you do inside of Studio.

Some background:
---------------------------

BCM uses database files indirectly, and this can be confusing to users
who are familiar with Word and Excel working on documents directly;
e.g. they have a mental model about how to open, save and copying
their documents. That model doesn't map well to "client-server"
applications that edit documents directly.

BCM uses databases as a service of provided by Sql Server, and BCM
never access the database files directly, Sql does that. This is what
allows BCM on several PCs to share the same database. BCM doesn't have
to know about accessing files, it connects to the Sql service and then
simply exchanges data (Contacts, Activties) with the service.