Cannot Connect to BCM Database

Status
Not open for further replies.
C

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
 
L

Luther Blissett

On May 28, 8:03 am, "Chris Guimbellot"

<cguimbellotnos...@hifranchise.com> wrote:
> 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
 
C

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

"Luther Blissett" <enowning@gmail.com> wrote in message

news:f10492c6-e74d-4d24-b30d-0451da8e45b7@s21g2000vbb.googlegroups.com...

On May 28, 8:03 am, "Chris Guimbellot"

<cguimbellotnos...@hifranchise.com> wrote:
> 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
 
N

NMOP

I am having trouble with the inititial connection to the shared database.

Got any idea what the problem is? Email me at nmop@valornet.com with

suggestions. Thanks!

"Chris Guimbellot" wrote:


> 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

> "Luther Blissett" <enowning@gmail.com> wrote in message
> news:f10492c6-e74d-4d24-b30d-0451da8e45b7@s21g2000vbb.googlegroups.com...
> On May 28, 8:03 am, "Chris Guimbellot"
> <cguimbellotnos...@hifranchise.com> wrote:
> > 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

>
 
N

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.

"NMOP" wrote:


> I am having trouble with the inititial connection to the shared database.
> Got any idea what the problem is? Email me at nmop@valornet.com with
> suggestions. Thanks!

> "Chris Guimbellot" wrote:
>
> > 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
> > "Luther Blissett" <enowning@gmail.com> wrote in message
> > news:f10492c6-e74d-4d24-b30d-0451da8e45b7@s21g2000vbb.googlegroups.com...
> > On May 28, 8:03 am, "Chris Guimbellot"
> > <cguimbellotnos...@hifranchise.com> wrote:
> > > 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
> >
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
R BCM 2010 Problem with remote office (VPN) users cannot connect BCM (Business Contact Manager) 12
J BCM 2010 - New user cannot connect to remote DB BCM (Business Contact Manager) 5
M BCM 2010 Cannot Connect to Remote Database BCM (Business Contact Manager) 1
T Cannot connect to main BT email account, sub accts okay Using Outlook 0
T Outlook 2016 cannot connect after transition to Outlook Mail Using Outlook.com accounts in Outlook 4
E Outlook cannot connect to your incoming (POP3) e-mail server/Cannot send mess. Using Outlook 0
R Shared database greyed out and cannot connect BCM (Business Contact Manager) 10
E Cannot connect to database BCM (Business Contact Manager) 3
O Cannot expand the folder. The set of folders cannot be opened. You do not have permission to log on. Using Outlook 1
N Item cannot be saved because it was modified by another user or window, and, Item could not be moved... Using Outlook 0
D Cannot populate certain UserProperties in Outlook from Excel Outlook VBA and Custom Forms 2
D Outlook 2016 64bit, Cannot Save in 'HTML', format Using Outlook 1
D cannot view emails in View pane (in the right pane), I only see one line or nothing Using Outlook 21
M Cannot read the calendar Using Outlook 9
T The Linked Image Cannot Be Displayed in Outlook Using Outlook 7
D Outlook 2016 Outlook Error Msg "The operation cannot be performed ..." How to Stop it Using Outlook 3
S Custom Field Cannot Be Displayed In Views Outlook VBA and Custom Forms 2
G Cannot Move Autocomplete File to New Computer Using Outlook 15
rubaboo The vew cannot be found Outlook VBA and Custom Forms 0
A Cannot copy this folder because it may contain private items Using Outlook 0
L Cannot open PST file for first session each day Using Outlook 6
David in Mississippi New (Feb 2020) install of Outlook 365 - Cannot specify PST for different accounts Using Outlook 0
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
noshairwan Registry cannot be found, Outlook Security Using Outlook 2
Marc2019 Cannot input Vietnamese Characters on my MSOutlook 2016 in Windows 7 Using Outlook 0
T Cannot remove needless PST Using Outlook 1
Marc2019 Cannot setup Outlook Account on Mac Os 10.6.8 Using Outlook 3
N pst files are recreating automaticaly and cannot be deleted Using Outlook 5
Mark Foley Cannot enable add-in in outlook 2010 Using Outlook 0
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
A Created a new user account and the local account cannot see email Using Outlook 3
iwshim outlook 2013 - I cannot see the "Manage Add-ins" Using Outlook 2
O The page that you are trying to access cannot be loaded. Using Outlook 0
M Daily Task List Minimized Cannot Display Using Outlook 2
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
DariTrevino MIcrosoft Outlook PST file cannot repair Using Outlook 1
B One email cannot be sent or received (but leaves outbox!) Using Outlook 1
C Outlook 2016 cannot delete, email showing in root Exchange Server Administration 5
S Outlook.com cannot edit some contacts Using Outlook.com accounts in Outlook 5
B Search: Cannot find which Folder Contains a Message Using Outlook 3
C Outlook - cannot save subject line changes Using Outlook 2
M cannot change delivery folders with IMAP accounts Using Outlook 0
S Appointment-Cannot set Categories because ConversationID is not set Outlook VBA and Custom Forms 1
Fozzie Bear Cannot post "Sneaky URL"!! Using Outlook.com accounts in Outlook 2
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
S Outlook 2010 Cannot Open Attachments Using Outlook 14
A Cannot Figure Out This VBA Outlook VBA and Custom Forms 2
A Cannot Figure Out One Thing on VBA Outlook VBA and Custom Forms 2

Similar threads

Top