BCM 2010 - New user cannot connect to remote DB

Status
Not open for further replies.

Jay Cartay

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hi all, first post here. Needing a bit of help, as I have just created a new user via the BCM for Outlook 2010 tool on the customer's SBS 2011, but when I go to install it on the user's machine and connect to the remote DB, it tells me that there's no SQL DB on the server I am specifying.

I have tried typing in the name of the server, tried the IP, tried both with \MSSMLBIZ on the end, tried to check permissions on SQL, all with no luck. I don't know much about BCM, but have followed all the logical steps I can think of.

I also tried removing and reinstalling BCM and SQLEXPRESS on the client machine.

As this works for a bunch of existing users, I can rule out the DB itself being an issue. Windows Firewall is turned off on the client machine also.

Does anybody have any ideas? I've done a lot of Googling for this, and don't seem to be getting anywhere fast....
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If other computers can use it, then it's not the DB server - it's the client computer. The most common cause is the firewall, second most is the log on account. Is the username and password the user uses to log into the computer configured on the SQL computer? I can't recall if not having the account causes the 'no db' error or a more general 'can't connect' error.

Check in Administrative Tools > Computer Managements > Local users and Groups.
 

Jay Cartay

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
If other computers can use it, then it's not the DB server - it's the client computer. The most common cause is the firewall, second most is the log on account. Is the username and password the user uses to log into the computer configured on the SQL computer? I can't recall if not having the account causes the 'no db' error or a more general 'can't connect' error.

Check in Administrative Tools > Computer Managements > Local users and Groups.
Hi Diane,

Thanks for your help and sorry for the delay in me coming back to this. Things have been a little hectic!

Basically the Server that hosts the SQL DB is an SBS, so users don't have local accounts on that server. We use the BCM for Outlook 2010 Database Tool. I tell it to Share a Database, then go through and select the MSSMLBIZ instance and then the MSSmallBusiness DB. I click add new user, browse for their AD account and select it, then click next a couple of times and close. These are the instructions that colleagues have used in the past successfully.

Once I go in and look at the existing user accounts on the Tool, it does show the new user in there, so it does seem to have done what it should have.

I'm very confused about this!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
They are logging into the computer using that account? It should work. The computer passes it's authentication to the database.

Also, the account name needs to be the same as the path in C:\users\username.
 

Jay Cartay

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Yeah they log in with the same account that I have registered via the Outlook DB Tool.

Here's where the plot thickens: I have now set up another new user the exact same way and it works fine. That makes me think there's an issue with the machine itself in this case....
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
It sure sounds like its the machine - the firewall is the first place I'd triple check.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
P Where are User-defined fields stored in BCM 2010 database? BCM (Business Contact Manager) 2
D BCM 2013 not functioning as BCM 2010 Example no drop down for communications history Using Outlook 0
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
A Upgrade BCM System from 2010 to 2013 BCM (Business Contact Manager) 0
S BCM crash Atheros Addin 2010 Using Outlook 1
C bcm 2010 download does not recognize outlook Using Outlook 3
Forum Admin BCM Update for Outlook 2010/2013 - Nov 2014 BCM (Business Contact Manager) 14
JimR BCM 2010 or 2013 BCM (Business Contact Manager) 6
J Migration from BCM 2010 to 2013 is messing up the label fields BCM (Business Contact Manager) 4
T BCM 2010 Archiving Communication History BCM (Business Contact Manager) 2
R BCM 2010 Problem with remote office (VPN) users cannot connect BCM (Business Contact Manager) 12
C Trying to move my Business Contact Manager ver. 2003 to BCM ver. 2010 Using Outlook 3
R BCM is almost at capacity Outlook 2010 BCM (Business Contact Manager) 2
O Is it possible to go from BCM Office 13 back to BCM Office 2010? BCM (Business Contact Manager) 1
V Permissions in BCM 2010 BCM (Business Contact Manager) 3
M Is there a list of FieldNames that BCM 2010 uses? BCM (Business Contact Manager) 0
A BCM 2010 converts html e-mails to plain text BCM (Business Contact Manager) 1
A BCM 2010 account names import in reverse order BCM (Business Contact Manager) 4
A Trouble importing data to radio buttons Business Contact Manager 2010 (BCM) Using Outlook 2
B BCM 2010: Exporting Notes to .CSV with Business Contacts? BCM (Business Contact Manager) 3
O BCM 2010 - Customize a field with a consecutive number? BCM (Business Contact Manager) 1
E Can we make custom form as default form in BCM 2010? BCM (Business Contact Manager) 5
B can not establish BCM 2010 connection to Shared DB on SQL 2008 Express BCM (Business Contact Manager) 4
N BCM 2010 for CRM tool? BCM (Business Contact Manager) 3
S BCM 2007 to 2010 migration failure issue BCM (Business Contact Manager) 1
T BCM 2007 to Outlook 2010 with no BCM - need contacts imported BCM (Business Contact Manager) 3
R Sorting and crossing over project tasks in project window (BCM 2010) BCM (Business Contact Manager) 1
M BCM 2010 Cannot Connect to Remote Database BCM (Business Contact Manager) 1
M BCM 2010 Link to Record (very) slow BCM (Business Contact Manager) 2
C Remote BCM database 2010 hosted via Godday SQL Server + access via PC Window 7 BCM (Business Contact Manager) 3
D [SOLVED] Optimizing Outlook 2010 BCM BCM (Business Contact Manager) 2
C Outlook 2010 with BCM - Database Connection problems using Windows 7 Clients Using Outlook 1
T Custom forms BCM 2010; use of form controls Using Outlook 1
S Recovering .sbb file that should be a .bcm file for Business Contact Manager 2010 Using Outlook 3
M Where are contacts stored for BCM 2010? Using Outlook 1
I Outlook 2010 BCM Mass E-mail feature insists on converting outbound HTML emails to plain text Using Outlook 2
I Office 2010 BCM Using Outlook 1
N Receive "Requested Operation Failed" Dialog when trying to add BCM Database in Outlook 2010 Using Outlook 2
B Outlook with BCM 2010 and Windows Mobile will not sync contacts separately Using Outlook 1
P Communication History disappeared in BCM 2010 Using Outlook 22
D BCM for Office 2010 Pro Plus Using Outlook 1
R BCM 2007 to 2010 Conversion fails - Database size > 4GB Help! Using Outlook 1
G Importing BCM file into Business Contact Manager 2010 Using Outlook 3
L 2010 BCM Install Using Outlook 1
K BCM 2010 - Permissions Setting? Using Outlook 1
J outlook and BCM 2010 have Hyper links fileds Using Outlook 3
N BCM 2010 Will Not Setup Using Outlook 2
L BCM 2010 Linking A Business Contact to Multiple Accounts or Projects Using Outlook 1
M BCM 2010 rtm available for registered partners on portal???? Using Outlook 1
M BCM in office 2010 professional? Using Outlook 1
Similar threads


















































Top