BCM 2007 Can't find SS2012Express

Status
Not open for further replies.
M

Mel Jewett

Member
Outlook version
Email Account
POP3
Installed BCM for Outlook 2007 and tried to configure it. The error message is "Cannot retrieve the list of SQL Server instances..."

SQL Server Express 2012 is installed on the local machine (W7 Pro) and is running (used constantly as a back-end dbserver).

I have enabled TCP/IP on the SS Config. Manager.

We are a small business without a central server, but running on a domain server from a large hospital. I have administrative rights on my own computer.

Can this setup work? If so, what should I do next?

Thanks for any help.

Mel
 
It *should* work. I've used it with a remote server, but not with a local db.

I know if you are using the BCM Database Tool to set up a remote SQL Server 2012, you'll get this error if you logging on as Network Service: Cannot create a new database. The operation has been rolled back. Please make sure the database service is running.

The solution: Log on as a Local System instead.

I don't know if similar issues apply to the local install, but its worth checking the SQL accounts.
 
Thanks for the reply.




To clarify, I'm using the BCM Database Tool for Outlook 2007. Trying to connect to a SSExpress 2012 on the same machine. I log in to W7 with administrative rights. The SSExpress is a back-end database for Access 2007 which I use constantly. So, SS is always running, even when I'm not logged on to the computer.




Normally SSExpress is only configured using shared memory. BCM can't find it. When I added TCP/IP, BCM still can't find SSExpress. I have not tried named pipes yet.




Access 2007 and Excel 2007 find SSExpress without a problem. I'm also testing a couple of 3d party db tools for reporting and exporting from SSExpress, and they also have no problem finding it.




Any other thoughts?




Mel




Diane Poremsky said:
It *should* work. I've used it with a remote server, but not with a local db.




I know if you are using the BCM Database Tool to set up a remote SQL Server 2012, you'll get this error if you logging on as Network Service: Cannot create a new database. The operation has been rolled back. Please make sure the database service is running.




The solution: Log on as a Local System instead.




I don't know if similar issues apply to the local install, but its worth checking the SQL accounts.
Click to expand...
 
Status
Not open for further replies.
< Get Calendar back from iCloud | yahoo mail doesn't send or receive reliably >
Similar threads
Thread starter Title Forum Replies Date
M cant find my BCM 2007 disc BCM (Business Contact Manager) 1
A Outlook 2007 ca+n't find bcm BCM (Business Contact Manager) 1
J Missing BCM TAB Main Menu - 2007 BCM (Business Contact Manager) 2
T OL BCM 2007 - Possible to migrate SQL Server Express 2012 ? BCM (Business Contact Manager) 2
J No errors from BCM 2007 but can't see database BCM (Business Contact Manager) 0
S BCM 2007 to 2010 migration failure issue BCM (Business Contact Manager) 1
E BCM 2007 no reminder visible at client PC in workgroup BCM (Business Contact Manager) 5
U TABS MISSING OR DUPLICATED - BCM 2007 on Vista laptop BCM (Business Contact Manager) 5
T BCM 2007 to Outlook 2010 with no BCM - need contacts imported BCM (Business Contact Manager) 3
J Unable to view History items in BCM 2007 shared database BCM (Business Contact Manager) 3
C BCM 2007 to 2010 Migration BCM (Business Contact Manager) 1
M Adding BCM to Outlook 2007 BCM (Business Contact Manager) 1
F Technical Specifications for 2007 BCM BCM (Business Contact Manager) 1
T BCM 2007: Accounts creation or opening fails BCM (Business Contact Manager) 1
J BCM V.2007 BCM (Business Contact Manager) 1
T BCM Crashing during search - 2007 edition BCM (Business Contact Manager) 3
H Fail to install BCM 2007 (English) on Windows 7 64 bit (Danish) BCM (Business Contact Manager) 3
A BCM 2007 restoring database BCM (Business Contact Manager) 1
V Already have Office 2007 Prof Plus, want to get BCM BCM (Business Contact Manager) 4
F Outlook 2007 BCM Exporting Files BCM (Business Contact Manager) 2
I BCM install error on XP SP3 with Outlook 2007 - cant install Interop BCM (Business Contact Manager) 1
S Import Data from 2003 BCM to 2007 BCM (on Windows 7) BCM (Business Contact Manager) 1
D Connecting BCM 2007 to a shared BCM 2003 Database BCM (Business Contact Manager) 3
G bcm 2007 sub folders BCM (Business Contact Manager) 1
L How do you Recover from An Outlook 2007 & BCM Crash BCM (Business Contact Manager) 1
A Add BCM to outlook 2007 BCM (Business Contact Manager) 1
A BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain BCM (Business Contact Manager) 1
C Error when installing BCM for outlook 2007 from disk 2 BCM (Business Contact Manager) 3
B Outlook 2007 BCM will not recognize data files BCM (Business Contact Manager) 1
S BCM in Office Ultimate 2007 Won't Install on W7 Ultimate 32 BCM (Business Contact Manager) 1
D BCM 2010 and a shared BCM 2007 Database BCM (Business Contact Manager) 5
J BCM 2007 Shutting Down Outlook BCM (Business Contact Manager) 2
P Windows 7 / Outlook BCM 2007 Stability BCM (Business Contact Manager) 1
A What to do if BCM didn't install with 2007 Professional Trial? BCM (Business Contact Manager) 1
N Outlook 2007 w/BCM - Email issues BCM (Business Contact Manager) 5
N Email issues since installing BCM with Outlook 2007 BCM (Business Contact Manager) 1
M Outlook 2007 with BCM - Tasks being created automatically BCM (Business Contact Manager) 1
O BCM didn't install w small business outlook 2007 BCM (Business Contact Manager) 1
A Unresolved items, BCM 2007 with smartphone BCM (Business Contact Manager) 1
C All my projects and project tasks are gone - OL BCM 2007 BCM (Business Contact Manager) 2
J Moving BCM 2007 Database to a SQL 2005 Server BCM (Business Contact Manager) 2
D BCM 2007 errors BCM (Business Contact Manager) 5
D Outlook 2007 BCM - Win 7 BCM (Business Contact Manager) 1
W Recovering Data From BCM 2007 BCM (Business Contact Manager) 2
A ACT! 10.0 to BCM 2007 BCM (Business Contact Manager) 2
V Connecting BCM 2007 to SQL Server 2007 BCM (Business Contact Manager) 1
E Re:BCM failed to install in outlook 2007 due to SQL Server Express 20 BCM (Business Contact Manager) 1
B Marketing Campaign BCM 2007 – Word 2007 Merge Fails BCM (Business Contact Manager) 1
C How to configure BCM 2007 and Hosted Exchange BCM (Business Contact Manager) 4
D Networking BCM 2007 BCM (Business Contact Manager) 4

Similar threads

Back
Top