BCM and SQL connection issues " can not connect to database"



  • 1. Re-install BCM
    I had to un-install and then re-install BCM. Most of my contacts from BCM were there when I opened it up again. About 10% are missing. Is there any way to get them back? Where are they residing?? Any help would be appreciated. XXXX@XXXXX.COM SteveR
  • 2. Outlook should let me add drop down lists in user defined fields
    user defined fields should be able to have drop down lists to select from and the ability to edit any drop down list
  • 3. Outlook should let me schedule a series of tasks
    ACT allows you to build a series of related tasks (i.e. tasks when you sign a contract)
  • 4. Outlook should allow me to "complete" appointments & meetings
    So they can be tracked as history by contact and get crossed off when completed or missed or cancelled.
  • 5. How to use Outlook with Business Contact Manager
    I've installed Outlook with BCM, but have been unable to use the BCM. Upon starting Outlook, a message displays that asks if I want to use BCM. I click Yes, and a couple of seconds later I receive an error message that states: Database creation has failed. I've been unable to uncover helpful info to resolve this issue until now, and would like to utilize BCM for my business marketing and prospecting. Thanks in advance, Victoria D'Cotledge

BCM and SQL connection issues " can not connect to database"

Postby R3JlZyBE » Fri, 02 Jun 2006 05:49:02 GMT

I am using Outlook 2003 with BCM.   A few days ago I was unable to log into 
my business contacts.  a meesage popped up that said Business Contact Manager 
cannot access the database.  SQL server does not exsist or access denied.

I have admin rights to my PC.

I open my services and noticed that MSSQL$MICROSOFTSMLBIZ was not running.  
Nor was MSSQLServerADHelper.  I started 'MLBIZ but am unable to start 
'ADHELPER.   I tried loading my contact manager again, but it still could not 
connect to the database and when I went back to services 'MLBIZ had stopped.  
 I am guesing that my problem resides with MSSQL.  How do I trouble shoot 

RE: BCM and SQL connection issues " can not connect to database"

Postby R3JlZyBE » Fri, 02 Jun 2006 23:20:01 GMT

I ended up removing Microsoft SQL Server Desktop edition thru Add/Remove 
software.  Next rebooting,  then reinstalling BCMV2UPD.  This reinstalled the 
SQL server.    My SQL services are starting porperly and I am able to connect 
to my database.

Similar Threads:

1.MSO OL sp2 for BCM broke SQL Database connection

Two days ago an MS update for MSO OL sp2 for BCM wanted to be installed so I 
left it get installed. After the installation I noticed that my data 
connection to the BCM database was broken.

I am using MSSQLSERVER instance name for SQL Server Developer Edition 
instead of MSSQL instance name which is for SQLEXPRESS. I have been usine SQL 
Server Developer edition with BCM for quite awhile without any problem but 
now after sp2 was installed I cannot connect to the database as it cannot 
find it.

I ran the database Admin tool to share it and everything ran successfully 
with a pretty instruction page that opened in IE to walk one through 
connecting to the database in OL. The initial connection failed when I 
selected the connect to an existing databse as it wanted to connect to the 
default SQLEXPRESS instance, then I typed in the computer name 
localhost\MSSQLSERVER,1433 and it cannot find the database to connect.

Has anyone else had this ridiculous issue and how can I solve it?



2.Outlook with BCM installed on SQL server cant connect to database

Can BCM 2007 client access a shared database hosted on SQL2005 on the same 
machine client installed on?

I know this should not normally be done, but have new client who has one 
remote user who is the MD who uses an RDP session to thier SBS 2003 box to 
work.  He does not want to have an extra desktop PC for his sole remote 
access, or a Terminal Server when he's the only remote user.

The BCM database is on a custom instance/database on the SQL, but when 
trying to connect to shared database, using the same details which work on 
the workstations, it can connect and shows the database name.
But when we click Next we recive
"Business Contact Manager for Outlook could not complete your last action or 
actions. Please try again."

In the event viewer we recive :
Event ID 17207
FCB::Open: Operating system error 32(error not found) occurred while 
creating or opening file 'C:\Documents and Settings\%username%\Local 
Settings\Application Data\Microsoft\Business Contact 
Manager\MSSmallBusiness.mdf'. Diagnose and correct the operating system 
error, and retry the operation.


Event ID 17204
FCB::Open failed: Could not open file C:\Documents and 
Settings\%username%\Local Settings\Application Data\Microsoft\Business 
Contact Manager\MSSmallBusiness.mdf for file number 0.  OS error: 32(error 
not found). 

3.BCM Database and SQL Server Issues?


This is a follow-up question to one that I wrote last night concerning using 
the .mdf and .ldf files from a previous installation of BCM to get most of my 
data back.

I have received an error which states "Unable to open the physical file.... 
.mdf. Operating system error 5: "5(Access is denied)" when I attempt to 
troubleshoot the problem from within Outlook.

I remember when I logged on the backup image file to mount the backup on the 
external hard drive, and then copy the two files above from the image file to 
a location on the local hard drive, a window pops up that states that I will 
need to provide administrator permission to copy each file. I click continue, 
and it is copied.

If I look at the security section of the properties window for each file, I 
see that there is an entry for 
"SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which 
are part of the image backup file. But, when I copy the files over to my 
current boot drive, there is no longer a reference to that group or user 
name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE", 
"Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".

I am trying to muddle my way through this... so pardon my thought process if 
it is wrong. Based upon the fact that SQL is not referenced in the copied 
group or user names, should I be doing something with SQL to add it to get 
these files to work on this system? (It is the same system, I just restored 
the boot drive from a much older backup image. The computer name and the 
permissions should all be the same.)

Thanks in advance for any help that can be offered.


4.BCM SQL database file not recognized

I had to move my SQL file from my laptop drive to my desktop drive due toa 
unit failure. However, BCM will not recognize the database even though it is 
located in the same folder as the default database and has the same 
extension. I have tried all of the available restore and database rebuild 
options that I can find but noe of them will allw me access to the file. I 
am wondering if it has something to do with permissions. At any rate I am 
hamstrung if I can't get this file to open. Anyone out there who might be 
able to help with this? 

5.Connecting BCM 2007 to a shared BCM 2003 Database

6. BCM for Outlook 2007 not connecting with database on server

7. Connection with an SQL Server 2005 database

8. Unable to connect to local SQL 2005 Database



Who is online

Users browsing this forum: No registered users and 18 guest