"No database found" but successful connection to SQL server.What am I missing?

Status
Not open for further replies.

Magnus_L77

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
Hi,

All clients can connect to the server but no database is found, cannot connect to database. I am stuck and cannot understand the problem. It cannot be firewalls or ports (5356) since I can connect to the server. Why isn't my database(s) visible. The screen just shows an empty list with the message saying "no database found". I haven't been able to find any information online that explains this problem. Most connectivity issues is about not getting access / not being able to log in to the SQL Server. I can login/connect just fine to the server but there is no database to connect to?????

Complete installations have proceeded without any errors.

Server side

SQL Server 2008 R2 SP2 Express (ADV). Installed and reinstalled (no change to problem)

BCM Outlook 2010 Database Tool 2010. Installed and reinstalled (no change to problem)

Successfull creation of database both by new name and by default database name (no difference to problem)

Tried to delete and create new databases (no change to problem)

Added users using the BCM Database tool without errors

Client side

Win 7 Pro 64 bit

BCM Outlook 2010

Office 2010 (Outlook 2010)

All clients can see/access and login to the SQL Server but during step 2 (chosing database) its just an empty screen saying "no database found".

Thanks for your support!

/Magnus
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

Magnus_L77

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
Re: "No database found" but successful connection to SQL server.What am I miss

I hate BCM connection errors. :( You checked the TCP settings too I assume - i guess you won't get into sql otherwise.

Have you seen How to troubleshoot a shared database in Outlook with Business Contact Manager Update ?

Thank you for your reply.

Yes, I have read the info on the link you suggest. I have also read the FAQ and 3rd party info scattered around the Internet, but with no luck.

I am probably missing something very simple here but I cannot see what?!

I have re-installed the SQL server software (2008 R2 SP2 Express) on a newly installed Win 7 32 bit pc but the problem is the same. I think its very strange. Using the BCM Database tool I have created a database, next i click share database and click on the "add"-button to add users. BCM tool reports all activities as completed with success.

On the client side I click the "connect to remote database" from the BCM Outlook 2010 add-on. The first prompt I get is to type the server name. If I type a random name (just for testing) it comes back with the error cannot connect to server. When I type in the name of the Server it connects and immediately takes med to the next prompt / dialogue screen where I am supposed to click which database to connect to. On this screen, however, there is no database listed. top of the screen it just says "cannot find any database".

This is megastrange to me! Going back to the SQL server and starting the SQL Server Configuration tool I can confirm TCP/IP is enabled (wouldn't be able to connect otherwise. Also checked port (5356) again wouldn't be able to connect if otherwise.

I launch the Management tool and I can verify that the database exists on the SQL server.

Any ideas are VERY welcome.

/Magnus
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: "No database found" but successful connection to SQL server.What am I miss

Is this a AD configuration or just a small network, not using AD to log in?
 

Magnus_L77

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
Re: "No database found" but successful connection to SQL server.What am I miss

Dear all,

Problem finally "solved".

I re-installed clean pc (win 7 32bit) and the SQL + BCM tools AGAIN, sigh. Added a database and the same problem occured again i.e. no database found as described above. This time I tried to add the default database as well and finally there was two databases to choose from.

So, in my case;

1) Clean install of everything, database with personal name created = no database is found

2) Clean install of everything, database with default name created (MSSmallBusiness) = no database is found

3) Clean install of everything, database with two databases created default name AND personal name; MSSmallBusiness + "mynameddatabase" = suddenly the screen showed both databases and I was able to connect to either one of them.

/Magnus
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: "No database found" but successful connection to SQL server.What am I miss

Interesting. I knew it worked better with the default name but hadn't heard that it liked two to choose from.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
A Moving Public Folders to New Database Exchange Server Administration 3
J No access to a Database BCM BCM (Business Contact Manager) 3
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
T Lost access to remote BCM database BCM (Business Contact Manager) 4
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
Diane Poremsky Restoring BCM Database After Upgrading Windows New Slipstick.com Articles 0
wallisellener "The database name cannot exceed 50 characters" BCM (Business Contact Manager) 2
S Encrypting Exchange Database Exchange Server Administration 0
R Outlook Database to a non-Outlook PC Using Outlook 10
M Modifying BCM Database using Access BCM (Business Contact Manager) 1
crazyboy Copying BCM database from backed up mounted image to new drive BCM (Business Contact Manager) 2
A use database in other office BCM (Business Contact Manager) 1
K Recover/preserve space in database BCM (Business Contact Manager) 0
P Restoring old sbb database in existing one BCM (Business Contact Manager) 4
J Install BCM Client without an local SQl Database BCM (Business Contact Manager) 6
M Sharing of BCM database across the internet BCM (Business Contact Manager) 2
Chris Grew Sharing BCM Database BCM (Business Contact Manager) 6
M BCM remote database connection issue BCM (Business Contact Manager) 1
S Updating the database based on received task Outlook VBA and Custom Forms 3
J What exactly does the BCM Database tool actually do? BCM (Business Contact Manager) 3
J How do I get the database tool to recognize my data file? BCM (Business Contact Manager) 2
C Moving BCM Database to Server Share BCM (Business Contact Manager) 1
D Open attached CSV, copy newdata and paste it to database CSV Outlook VBA and Custom Forms 2
K BCM - Connecting to Shared Database BCM (Business Contact Manager) 0
B Can't see database in multiuser BCM (Business Contact Manager) 1
S Passive Mailbox database Resynchronization issue Exchange Server Administration 1
J Can the BCM Database tool be used over VPN? BCM (Business Contact Manager) 6
D can you share a bcm database with 2 different versions of windows? BCM (Business Contact Manager) 0
T BCM database scheme BCM (Business Contact Manager) 5
E BCM Database Tool Using Outlook 2
G "database is not compatible with BCM for Outlook 2013" & more BCM (Business Contact Manager) 0
L BCM database not listed BCM (Business Contact Manager) 0
wallisellener database creation failed BCM (Business Contact Manager) 0
J No errors from BCM 2007 but can't see database BCM (Business Contact Manager) 0
P BCM 2013, Microsoft SQL Server 2008 R2 (SP2), attachment issue n database size BCM (Business Contact Manager) 2
T BCM Cannot See Existing Database BCM (Business Contact Manager) 2
R catalog Content Index failed-Unable to mount database.(hr=0x80004005,ec=-501) Exchange Server Administration 0
T Shared BCM database on remote server BCM (Business Contact Manager) 1
C My BCM Database is no longer available to be shared with the Database Tool BCM (Business Contact Manager) 3
wallisellener Server configuration for BCM 2013 shared database BCM (Business Contact Manager) 15
S Cannot Find Shared Database on Remote Computer BCM (Business Contact Manager) 13
M BCM in Outlook reports maximum database size to 4GB despite SQL Server 2008 R2 BCM (Business Contact Manager) 1
A delete database --> record remnants ?? BCM (Business Contact Manager) 3
D BCM Database Protection BCM (Business Contact Manager) 3
U Exchange 2010 & mailbox database Quotas Exchange Server Administration 1
M BCM 2010 Cannot Connect to Remote Database BCM (Business Contact Manager) 1
J Unable to view History items in BCM 2007 shared database BCM (Business Contact Manager) 3
E Accessing User Defined Fields in BCM Database part 2 BCM (Business Contact Manager) 0
E [SOLVED] Accessing User Defined Fields in BCM Database part 1 BCM (Business Contact Manager) 9

Similar threads

Top