Cannot Connect to BCM Database

[Chris Guimbellot]

Hello,

Outlook 2007 with Business Contact Manager

I have lost connection to my BCM database and am trying to reestablish, but
am having problems.

When I open Outlook, I receive the following message:

"This action cannot be completed because Business Contact Manager cannot
access the database. Service MSSQL$MSSMLBIZ was not found on computer."

I installed SQL Server Express 2005 and restored my original BCM database to
it. It is under [COMPUTERNAME]\SQLEXPRESS. The database and service are
running and I can see the tables, etc. in the database. When I try to change
the data file under Account Settings in Outlook, I choose Select an existing
database. I then enter [COMPUTERNAME]\SQLEXPRESS and click Connect. The
drop-down box finds the database. The problem is that when I click Next, I
get the following message:

"Cannot connect to the database. Please click Retry. If the issue recurs,
click Help."

I have done some research and it seems that this issue occurs when
connecting to a remote database on a computer that is not online. The
problem is that I am attempting to connect to a database on my local PC,
which is online.

At this point, I am not sure what to do. I haven't been able to get into BCM
in over a week now. I would appreciate any help. Thanks.

Chris

 

[Luther Blissett]

Hello,

Outlook 2007 with Business Contact Manager

I have lost connection to my BCM database and am trying to reestablish, but
am having problems.

When I open Outlook, I receive the following message:

"This action cannot be completed because Business Contact Manager cannot
access the database. Service MSSQL$MSSMLBIZ was not found on computer."

I installed SQL Server Express 2005 and restored my original BCM databaseto
it. It is under [COMPUTERNAME]\SQLEXPRESS. The database and service are
running and I can see the tables, etc. in the database. When I try to change
the data file under Account Settings in Outlook, I choose Select an existing
database. I then enter [COMPUTERNAME]\SQLEXPRESS and click Connect. The
drop-down box finds the database. The problem is that when I click Next, I
get the following message:

"Cannot connect to the database. Please click Retry. If the issue recurs,
click Help."

I have done some research and it seems that this issue occurs when
connecting to a remote database on a computer that is not online. The
problem is that I am attempting to connect to a database on my local PC,
which is online.

At this point, I am not sure what to do. I haven't been able to get into BCM
in over a week now. I would appreciate any help. Thanks.

Chris

The database needs to be on an instance called MSSMLBIZ, not the
default SQLEXPRESS instance.

You could try changing BCM's instance in the Registry to SQLEXPRESS.
http://beyng.blogspot.com/2006/06/how-bcm-finds-database.html

 

[Chris Guimbellot]

Luther,

Thanks for the reply. I had tried before to install another instance, but
relized i had the wrong name. I installed another called MSSMLBIZ and
re-attached the database. It's now working great. Thanks a lot.

Chris

Hello,

Outlook 2007 with Business Contact Manager

I have lost connection to my BCM database and am trying to reestablish,
but
am having problems.

When I open Outlook, I receive the following message:

"This action cannot be completed because Business Contact Manager cannot
access the database. Service MSSQL$MSSMLBIZ was not found on computer."

I installed SQL Server Express 2005 and restored my original BCM database
to
it. It is under [COMPUTERNAME]\SQLEXPRESS. The database and service are
running and I can see the tables, etc. in the database. When I try to
change
the data file under Account Settings in Outlook, I choose Select an
existing
database. I then enter [COMPUTERNAME]\SQLEXPRESS and click Connect. The
drop-down box finds the database. The problem is that when I click Next, I
get the following message:

"Cannot connect to the database. Please click Retry. If the issue recurs,
click Help."

I have done some research and it seems that this issue occurs when
connecting to a remote database on a computer that is not online. The
problem is that I am attempting to connect to a database on my local PC,
which is online.

At this point, I am not sure what to do. I haven't been able to get into
BCM
in over a week now. I would appreciate any help. Thanks.

Chris

The database needs to be on an instance called MSSMLBIZ, not the
default SQLEXPRESS instance.

You could try changing BCM's instance in the Registry to SQLEXPRESS.
http://beyng.blogspot.com/2006/06/how-bcm-finds-database.html

 

[NMOP]

I am having trouble with the inititial connection to the shared database.
Got any idea what the problem is? Email me at (e-mail address removed) with
suggestions. Thanks!

Luther,

Thanks for the reply. I had tried before to install another instance, but
relized i had the wrong name. I installed another called MSSMLBIZ and
re-attached the database. It's now working great. Thanks a lot.

Chris

Hello,

Outlook 2007 with Business Contact Manager

I have lost connection to my BCM database and am trying to reestablish,
but
am having problems.

When I open Outlook, I receive the following message:

"This action cannot be completed because Business Contact Manager cannot
access the database. Service MSSQL$MSSMLBIZ was not found on computer."

I installed SQL Server Express 2005 and restored my original BCM database
to
it. It is under [COMPUTERNAME]\SQLEXPRESS. The database and service are
running and I can see the tables, etc. in the database. When I try to
change
the data file under Account Settings in Outlook, I choose Select an
existing
database. I then enter [COMPUTERNAME]\SQLEXPRESS and click Connect. The
drop-down box finds the database. The problem is that when I click Next, I
get the following message:

"Cannot connect to the database. Please click Retry. If the issue recurs,
click Help."

I have done some research and it seems that this issue occurs when
connecting to a remote database on a computer that is not online. The
problem is that I am attempting to connect to a database on my local PC,
which is online.

At this point, I am not sure what to do. I haven't been able to get into
BCM
in over a week now. I would appreciate any help. Thanks.

Chris

The database needs to be on an instance called MSSMLBIZ, not the
default SQLEXPRESS instance.

You could try changing BCM's instance in the Registry to SQLEXPRESS.
http://beyng.blogspot.com/2006/06/how-bcm-finds-database.html

 

[NMOP]

We have setup the database remotely, ran the connection wizard and used the
temporary password. We tried connecting to the remote database using the
temporary password but it still says it can't change the password on the
remote machine to connect.

I am having trouble with the inititial connection to the shared database.
Got any idea what the problem is? Email me at (e-mail address removed) with
suggestions. Thanks!

Luther,

Thanks for the reply. I had tried before to install another instance, but
relized i had the wrong name. I installed another called MSSMLBIZ and
re-attached the database. It's now working great. Thanks a lot.

Chris

Hello,

Outlook 2007 with Business Contact Manager

I have lost connection to my BCM database and am trying to reestablish,
but
am having problems.

When I open Outlook, I receive the following message:

"This action cannot be completed because Business Contact Manager cannot
access the database. Service MSSQL$MSSMLBIZ was not found on computer."

I installed SQL Server Express 2005 and restored my original BCM database
to
it. It is under [COMPUTERNAME]\SQLEXPRESS. The database and service are
running and I can see the tables, etc. in the database. When I try to
change
the data file under Account Settings in Outlook, I choose Select an
existing
database. I then enter [COMPUTERNAME]\SQLEXPRESS and click Connect. The
drop-down box finds the database. The problem is that when I click Next, I
get the following message:

"Cannot connect to the database. Please click Retry. If the issue recurs,
click Help."

I have done some research and it seems that this issue occurs when
connecting to a remote database on a computer that is not online. The
problem is that I am attempting to connect to a database on my local PC,
which is online.

At this point, I am not sure what to do. I haven't been able to get into
BCM
in over a week now. I would appreciate any help. Thanks.

Chris

The database needs to be on an instance called MSSMLBIZ, not the
default SQLEXPRESS instance.

You could try changing BCM's instance in the Registry to SQLEXPRESS.
http://beyng.blogspot.com/2006/06/how-bcm-finds-database.html

 

[Luther Blissett]

We have setup the database remotely, ran the connection wizard and used the
temporary password.  We tried connecting to the remote database using the
temporary password but it still says it can't change the password on the
remote machine to connect.  

I am having trouble with the inititial connection to the shared database.  
Got any idea what the problem is?  Email me at (e-mail address removed) with
suggestions.  Thanks!

Luther,
Thanks for the reply. I had tried before to install another instance,but
relized i had the wrong name. I installed another called MSSMLBIZ and
re-attached the database. It's now working great. Thanks a lot.
Chris
On May 28, 8:03 am, "Chris Guimbellot"
Hello,
Outlook 2007 with Business Contact Manager
I have lost connection to my BCM database and am trying to reestablish,
but
am having problems.
When I open Outlook, I receive the following message:
"This action cannot be completed because Business Contact Manager cannot
access the database. Service MSSQL$MSSMLBIZ was not found on computer."
I installed SQL Server Express 2005 and restored my original BCM database
to
it. It is under [COMPUTERNAME]\SQLEXPRESS. The database and serviceare
running and I can see the tables, etc. in the database. When I try to
change
the data file under Account Settings in Outlook, I choose Select an
existing
database. I then enter [COMPUTERNAME]\SQLEXPRESS and click Connect.The
drop-down box finds the database. The problem is that when I click Next, I
get the following message:
"Cannot connect to the database. Please click Retry. If the issue recurs,
click Help."
I have done some research and it seems that this issue occurs when
connecting to a remote database on a computer that is not online. The
problem is that I am attempting to connect to a database on my local PC,
which is online.
At this point, I am not sure what to do. I haven't been able to getinto
BCM
in over a week now. I would appreciate any help. Thanks.
Chris
The database needs to be on an instance called MSSMLBIZ, not the
default SQLEXPRESS instance.
You could try changing BCM's instance in the Registry to SQLEXPRESS.
http://beyng.blogspot.com/2006/06/how-bcm-finds-database.html- Hide quoted text -

- Show quoted text -

If BCM's UI for setting the temporary password isn't working, set the
password pair manually using Window's own UI. The important factor is
that the user/password pairs need to be identical on both machines.

 

[litsco]

For some reason we cannot connect to a shared database.
How can i do 1 of 2 options, or both:

1) Delete shared user list?
2) Change password info to retry?

I downloaded SQL Server Management Studio Express but have been unable to locate these values. Could be due to not being familiar with SQL....