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" <(E-Mail Removed)> wrote in message
news:800A8CF6-F3AA-4513-A6D1-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:800A8CF6-F3AA-4513-A6D1-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:59D5BE17-ECE2-4155-9CCE-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:800A8CF6-F3AA-4513-A6D1-(E-Mail Removed)...
>> > 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
>>