BCM 2010 & remote database

Status
Not open for further replies.
A

Andy Carr

I am having problems connecting to a remote database. I have installed bcm

2010 and can create and access local databases OK

On the server i have uninstalled sql 2005 express & bcm2007 database tool

and installed sql2008 express and 2010 database tool. I can create a new

database, share it and view it in sql express however when i try to connect

to it from BCM i get the following error

"The computer <computer name> does not contain any shared BCM databases.

please confirm that a shared BCM database is stored on the computer."

The previous BCM 2007/sql 2005 setup worked fine.

Any ideas as to what the problem can be?

Thanks
 
Try replacing the computer name with the IP address and see if you can get

it to connect .

If this also fails .I would check if I can ping the server machine and

receive response .

Else use the sqlcmd command and see if we can connect to the database (take

a look at KB 953745)

Regards

Rahul Thomas

MSFT

"Andy Carr" <AndyCarr> wrote in message

news:800A8CF6-F3AA-4513-A6D1-330B2DBF9D4D@microsoft.com...
> I am having problems connecting to a remote database. I have installed bcm
> 2010 and can create and access local databases OK

> On the server i have uninstalled sql 2005 express & bcm2007 database tool
> and installed sql2008 express and 2010 database tool. I can create a new
> database, share it and view it in sql express however when i try to
> connect
> to it from BCM i get the following error

> "The computer <computer name> does not contain any shared BCM databases.
> please confirm that a shared BCM database is stored on the computer."

> The previous BCM 2007/sql 2005 setup worked fine.

> Any ideas as to what the problem can be?

> Thanks
 
Raul,

Thanks - working through KB953745 has now allowed me to connect to the

database (the TCP port was blank tather than set to 5356) however it does not

list any of the databases. Am I correct in suspecting that this is now

something to do with the sharing of the database and/or user names?

"Raul Thomas" wrote:


> Try replacing the computer name with the IP address and see if you can get
> it to connect .

> If this also fails .I would check if I can ping the server machine and
> receive response .

> Else use the sqlcmd command and see if we can connect to the database (take
> a look at KB 953745)
> > Regards

> Rahul Thomas

> MSFT

> "Andy Carr" <AndyCarr> wrote in message
> news:800A8CF6-F3AA-4513-A6D1-330B2DBF9D4D@microsoft.com...
> > I am having problems connecting to a remote database. I have installed bcm
> > 2010 and can create and access local databases OK
> > On the server i have uninstalled sql 2005 express & bcm2007 database tool
> > and installed sql2008 express and 2010 database tool. I can create a new
> > database, share it and view it in sql express however when i try to
> > connect
> > to it from BCM i get the following error
> > "The computer <computer name> does not contain any shared BCM databases.
> > please confirm that a shared BCM database is stored on the computer."
> > The previous BCM 2007/sql 2005 setup worked fine.
> > Any ideas as to what the problem can be?
> > Thanks

>
 
Hi Andy

Thanks for you response .

Here what I would do :

- Create a blank database (do not import any data) , share it out and see if

you can hit it from the client machines

If this works it could be the data set within the database that is prevent

it from being listed as an option

Also wanted to know if the clients that are accessing the shared database

(hosted on SQL 2008) are all running Business contact manager 2010 ?

Regards

Rahul Thomas

MSFT

"Andy Carr" <AndyCarr> wrote in message

news:59D5BE17-ECE2-4155-9CCE-552AFB2EB4E5@microsoft.com...
> Raul,

> Thanks - working through KB953745 has now allowed me to connect to the
> database (the TCP port was blank tather than set to 5356) however it does
> not
> list any of the databases. Am I correct in suspecting that this is now
> something to do with the sharing of the database and/or user names?

> "Raul Thomas" wrote:
>
> > Try replacing the computer name with the IP address and see if you can
> > get
> > it to connect .
>

>> If this also fails .I would check if I can ping the server machine and
> > receive response .
>

>> Else use the sqlcmd command and see if we can connect to the database
> > (take
> > a look at KB 953745)
> > > > Regards
>

>> Rahul Thomas
>

>> MSFT
>

>> "Andy Carr" <AndyCarr> wrote in message
> > news:800A8CF6-F3AA-4513-A6D1-330B2DBF9D4D@microsoft.com...
> > > I am having problems connecting to a remote database. I have installed
> > > bcm
> > > 2010 and can create and access local databases OK
> >> > On the server i have uninstalled sql 2005 express & bcm2007 database
> > > tool
> > > and installed sql2008 express and 2010 database tool. I can create a
> > > new
> > > database, share it and view it in sql express however when i try to
> > > connect
> > > to it from BCM i get the following error
> >> > "The computer <computer name> does not contain any shared BCM
> > > databases.
> > > please confirm that a shared BCM database is stored on the computer."
> >> > The previous BCM 2007/sql 2005 setup worked fine.
> >> > Any ideas as to what the problem can be?
> >> > Thanks

> >
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R BCM 2010 Problem with remote office (VPN) users cannot connect BCM (Business Contact Manager) 12
J BCM 2010 - New user cannot connect to remote DB BCM (Business Contact Manager) 5
M BCM 2010 Cannot Connect to Remote Database BCM (Business Contact Manager) 1
C Remote BCM database 2010 hosted via Godday SQL Server + access via PC Window 7 BCM (Business Contact Manager) 3
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
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 Link to Record (very) slow BCM (Business Contact Manager) 2
D [SOLVED] Optimizing Outlook 2010 BCM BCM (Business Contact Manager) 2
Forum Admin Download BCM 2010 BCM (Business Contact Manager) 0
C BCM 2007 to 2010 Migration BCM (Business Contact Manager) 1
R Missing contacts and Opportunities in BCM 2010 Shared database BCM (Business Contact Manager) 1
M BCM for Outlook 2010 now on Technet BCM (Business Contact Manager) 2
J BCM 2010 BCM (Business Contact Manager) 1
G Small Businesses Owners being priced out of BCM 2010 BCM (Business Contact Manager) 2
J Where is Final Release BCM 2010, Microsoft? Why is Dev Team silent BCM (Business Contact Manager) 2
L Cannot install BCM 2010-"Outlook 2010 Not Installed" but it is! BCM (Business Contact Manager) 1
B Where is RTM version of BCM 2010? BCM (Business Contact Manager) 2
R BCM 2010 error creating offline copy of shared database BCM (Business Contact Manager) 1
T BCM Install fails Both w Off. Pro 2010 Beta & on reinstall Off.Pro BCM (Business Contact Manager) 5
C BCM for RTM Release of Outlook 2010 BCM (Business Contact Manager) 3
S RE: BCM won't open after installing Office 2010 Beta BCM (Business Contact Manager) 2
K BCM 2010 report error BCM (Business Contact Manager) 6
B Multiple businesses in BCM 2010 BCM (Business Contact Manager) 9
S Trying to install BCM 2010 x64, getting error BCM (Business Contact Manager) 8
J Installing BCM 2010 on Server and Custom Form Layouts BCM (Business Contact Manager) 2
A BCM 2010. Cannot open this item. Error loading form. Some of neede BCM (Business Contact Manager) 3
M BCM 2010 changes BCM (Business Contact Manager) 1

Similar threads

Back
Top