Cannot see BCM database in SQL Server Management Studio



  • 1. Outlook 2007 w/ BCM locks up
    Hello, I am supporting a customer who has a SBS 2003 R2 server, all Vista Business clients with Office 2007 Small Business Edition. The BCM database is installed on SBS and is running great for all but one client. This client's Outlook has been working fine, but now locks up upon starting, specifically when trying to connect to the BCM database on the server. There is high CPU utilization by Outlook.exe and it never connects and renders Outlook unuseable. I have removed connection to the BCM database, and Outlook works perfectly. Please help me troubleshoot this problem. I've un-installed then re-installed BCM with identical results. Firewall is controlled by group policy and does not affect the other users connection to BCM. What else could it be. Please help! Thanks, Zevon
  • 2. Business Contact Manager Crashes when Designing Forms
    I have attempted to design a new form for my Opportunities. Every time I try the systems crashes (twice.) It auto restarts and crashes again, and then auto restarts without crashing. I have XP SP3, and Office 2007 Compatibility SP. Any help would be greatly appreciated. ~Cheers
  • 3. Can't link past emails to business account manager.
    I cannot link past emails to business account manager, unless I link them one at a time. Is there a way to send all emails from one person to the account manager?? Using Outlook 2007 with contact manager.
  • 4. business contact manager mobile with Dell Axim 51V
    I have installed the mobile version of Business Contact Manager on my Dell Axim 51V. All the information has synchronised successfully but the formatting of the data and options on the screen of my Dell 51V are almost impossible to read. Is this because the 51V is a VGA resoltuion screen whereas most other PDA's are QVGA? If so what can be done about it?
  • 5. Migrating from ACT! 2007 (v9)
    We currently use a 2 user version of ACT! 2007 and Quickbooks 2004, with Outlook 2003 for email. It's not ideal because ACT! and QB are not integrated so there is duplication, and synchronisation of ACT with Outlook is not that straightforward. I am considering installing SBS2007 with Outlook BCM 2007 and MS Accounting. Has anyone here experience of switching? I would like to know what the pros and cons are. TIA Andrew

Cannot see BCM database in SQL Server Management Studio

Postby Um95IEI » Mon, 08 Sep 2008 08:57:01 GMT

I'd like to see the database structure of my personal BCM in the studio 
manager for SQL Server but cannot. I refuses to even attach it even though I 
am administrator on the box. 

Re: Cannot see BCM database in SQL Server Management Studio

Postby Luther » Thu, 11 Sep 2008 02:43:03 GMT

Have you tried including the port number?


Similar Threads:

1.Cannot seem to use BCM Database Tool on SQL Server 2008

I am trying to install BCM onto a sql 2008 server for shared usage.  The 
server is running Windows 2008 32 bit.

I have an instance "CSSSQL01\MSSMLBIZ" that I installed as a local admin 
account "CSSSQL01\sqlsmlbizadmin"  I can use SSME to connect to this 
instance, using Windows Authentication (logged in as this user).

However, when I use Business Contact Manager for Outlook 2007 Database Tool 
to try to Create a New Database, I receive this error message "Cannot 
retrieve the list of SQL Server instance.  Please make sure that SQL Server 
2005 or SQL Server 2005 Express is installed and that the service is 
running."  Clicking OK closes the program.

Any ideas?

I only saw one other thread about this and it ended in August 2008 without 
an answer.

Thank you,

2.Cannot attach database from Server management Studio

When I try to attach a local database file created with SQL Express 2008 / 
Visual Web Developer, I get following error

Cannot show requested dialog.
Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)

I have read that this has to do with user credentials, but I dont 
understand, I just find the local database instance using Windows 
Authentication and my user is local administrator.

Does anyone know how to get around this?

Best regards

3.Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED

Searching for help on this problem, I found a lot of stuff having to
do with server configuration, and other distractions, and having
figured out the solution (at the end of at least 4 hours of
thrashing), I wanted to share it for the benefit of others.

PROBLEM: A Windows 7 machine with SQL Server Management Studio 2005
can connect to the localhost SQL Server 2005 instance, a "regular"
remote SQL Server 2005 setup (CrystalTech's web hosting), and a SQL
Server 2000 instance on a server with a VPN connection.

I could NOT connect to the SQL Server 2005 instance on the VPN, UNLESS
I turned off the firewall for the "Public" profile..

The win7 firewall configuration had 2 pair of inbound rules for SQL
Server Management Studio, allowing any UDP and any TCP ports, for the
"Private" and "Domain" profiles. None of these was enabled.

I changed one pair to serve for all three profiles, enabled the pair
of rules, and I was able to connect.

4.BCM database on SQL Server 2000

Hello. We are investigating using BCM for some of our sales people. We would 
like to have the BCM database setup on our existing SQL Server 2000. When I 
setup the BCM client (Outlook 2007 with BCM) it asks if I want to connect to 
an existing database, which can be on another computer, but there is no 
option to create the database on a remote server. Is this possible? If so, 
can someone point me to documentation on this?

5.bcm 2007 database of an MS SQL-Server 2000

I have a problem with Outlook 2007 and BCM. I will use my MS SQL-Server2000
for holding the database. Can show me evereybodey the way please.

Greetings to all


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

7. Run the BCM database on a SQL server 2000

8. BCM Database on central SQL server?



Who is online

Users browsing this forum: No registered users and 13 guest