Outlook with BCM installed on SQL server cant connect to database

Programming and Web Development Forums - MS OFFICE OUTLOOK - Microsoft Office Outlook

Skip to content

Outlook with BCM installed on SQL server cant connect to database

MS OFFICE OUTLOOK
Post a reply

    Next

  • 1. Linking Business Contact history with multiple contacts
    Is there a way in BCM to link one history with multiple contacts. Here is scenario; I do a mass mailing but not to every single individual in all acconts. Can I add business note and link to other contacts?
  • 2. Connection to accounting
    I continually have to setup the connection to accounting. Everytime that I exit and restart Outlook w/ BCM and want to create a quote, I have to setup the connection again. Any ideas? By the way, I'm looking forward to the next version of BCM and SBA. John

Outlook with BCM installed on SQL server cant connect to database

Postby Kirk Conway (Nectar) » Fri, 27 Feb 2009 16:54:16 GMT 

Question:
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.

and

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).
Top

Re: Outlook with BCM installed on SQL server cant connect to database

Postby Joe » Sat, 28 Feb 2009 04:37:40 GMT 



I don't have a definite answer, but Outlook and Exchange should not be 
installed on the same machine as there is a conflicting dll issue, see 
 http://www.**--****.com/ 
I've no idea whether this may be involved in the problem.

Presumably SQL Server is configured to listen on localhost. Certainly a 
standalone BCM installation on a PC uses SQL Server and has no problem 
talking to it.

You are obviously aware of the risks of letting users near servers, and 
you may like to point out to the client that SBS is not licensed for 
remote access for any purpose except server administration, and that 
nobody should ever be running applications anywhere as a domain admin. 
Also, a cheap headless workstation will cost less than a server rebuild.

-- 
Joe
Top

Re: Outlook with BCM installed on SQL server cant connect to database

Postby Luther Blissett » Sat, 28 Feb 2009 08:27:31 GMT 





Ensure that the login sqlserver.exe is running with (typically
"Network Services") has permission to Read/Write folder 'C:\Documents
and Settings\%username%\Local
Settings\Application Data\Microsoft\Business Contact
Manager\ and the mdf file.
Top

Re: Outlook with BCM installed on SQL server cant connect to database

Postby Kirk Conway (Nectar) » Sat, 28 Feb 2009 18:50:28 GMT 






I think I need to provide some more details, as I notice I didnt include 
them in the original post

In BCM select an existing database we put the computer name as:

IEDGE\BCM2007,14327
we then click connect, and can see the database name - BCM1
It's when we then click next that we get the error.

I'm not sure why it's trying to link into local settings.
Top

Similar Threads:

1.Can BCM database be installed on a standard SQL Server 

Hello,

I am new to BCM, so my question may be a little be basic.

I am IT Manager for a mid-size company.  Couple of weeks ago, we moved
a desktop machine from a room to another and discovered, out of a
sudden, that people in the sales departement were not able to access
their BCM anymore.  We then understood that someone had instal the
software on this inapporpriate machine.

So last week, we decided to move BCM on one of our servers.  I first
tought that BCM was a standard client-server software, the SQL
database acting as the server part.  When I took a deeper look at the
desktop where the central database is located, I found that only a
small package of SQL Server was installed.

My questions are :

1. Is BCM a standard clients-server application (outlook = clients and
SQL = server) or a peer-to-peer application made of many outlook
instances ?
2. Can I install BCM database on a SQL Server instance and have this
instance deliver data to outlook clients
3. If so, do I need to install BCM on the "server" machine or can I
just mount the BCM database on the SQL Server?

Thank you for your help,
EBL

2.Cant install BCM becasue SQL won't install 

I've tried the tricks I found posted here (deleting all SQL programs, 
deleting folders and emptying trash, and even cleaning the registry), but my 
install of BCM won't install SQL. Any clued?

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

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 
this?

4.Installing SQL Server SP4 for MSDE installed with BCM 

Does anyone know how to do this? When I ran the security analyzer MBSA 1.2.1 
it mentioned that I needed to apply SP4, but when I looked through the 
readme.txt for applying SP4 to MSDE it doesn't mention the BCM case.
The readme implies there are many wrong turns.
Has anyone seen an MSDN article covering SP4 and BCM/MSDE?
Does Office update take care of it?

5.Installing SQL Server 2008 Express with BCM installed 

I've had BCM installed for a while now.  It is using the 2005 verion of 
SQL Server.

I want to download and install SQL Server 2008 Express to learn about 
SQL.  

Question: Do I need to install SQL Server 2008, or can I just create a 
new database in SQL Server 2005 that BCM installed?

Question: Will there be conflicts if I install SQL Server 2008 Express 
on the same machine as BCM?

Thanks

Dino

6. install BCM fails on installing SQL Server 2005 Express

7. Install problem w/SQL Server Desktop Engine when installing BCM up

8. BCM database on SQL Server 2000

Post a reply

Return to MS OFFICE OUTLOOK

 

Who is online

Users browsing this forum: No registered users and 4 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group