More problems with Database Sharing !!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lexicon - 30 Mar 2006 13:58 GMT

I have BCM installed on my laptop which runs windows XP professional and have
built up a load of accounts and contacts.

I now want to connect a desktop computer but I also want the database file
to be stored and managed from that computer.

The desktop computer has windows 2000 SP4. I successfully installed BCM and
created a new database. I then exported a BCM data file from my laptop with
all the accounts and contact info and imported into the new database on the
desktop. All good so far…

The system seemed to be working fine, all the contacts and info could be
viewed and managed from either computer and any changes made on one computer
immediately showed up on the other. So job done, at the end of the day I shut
down both computers and went home a happy man.

The next day I started up both computers and opened outlook on my laptop.
After some waiting it finally came up with the error message ‘cannot connect
to database….’ I’ve gone through several help files checked subnet mask,
firewalls etc but I have two main questions:

Does it matter that the desktop is running Windows 2000? And…

Why did it work the first day and suddenly decide to stop working when I
next booted up?

Any suggestions would be very much appreciated

Reply to this Message

Leonid S. Knyshov - 30 Mar 2006 20:15 GMT

>I have BCM installed on my laptop which runs windows XP professional and
>have
> built up a load of accounts and contacts.
>
> I now want to connect a desktop computer but I also want the database file
> to be stored and managed from that computer.

Symptoms - BCM database not accessible from laptop. Is it accessible from
the desktop?

Did you actually set laptop to use the BCM database on the desktop in the
Data File management screen?

Make sure MSSQL$MICROSOFTSMLBIZ (or MSSQL$MICROSOFTBCM) service is running
on the 2000 desktop.
Start -> Run -> services.msc [OK]
Start -> Run -> svrnetcn [OK]
Verify that named pipes and TCP/IP are enabled for the service, and restart
the service if necessary

Signature

Leonid S. Knyshov, CEO
Crashproof Solutions, LLC - http://www.crashproofsolutions.com
MCP Exchange 2003/Small Business Server 2003, CCNA, SCSA 8, NCIE
Microsoft Small Business Specialist Partner

Reply to this Message

Lexicon - 31 Mar 2006 11:22 GMT

HI Leonid,

Yes the database is accessible from the deskop.

Yes the laptop is set to use the desktop databse in the Data file management
screen, as it did work properly on the first day.

Thanks so much for your input

Lex

> >I have BCM installed on my laptop which runs windows XP professional and
> >have
[quoted text clipped - 15 lines]
> Verify that named pipes and TCP/IP are enabled for the service, and restart
> the service if necessary

Reply to this Message

Raul - 31 Mar 2006 12:03 GMT

Hi Lex

Can you try the following article
http://support.microsoft.com/kb/901164/en-us

looks like you have already tried some steps already mentioned in the
same,try
using the OSQL command mentioned and see if you can access the database

Signature

With Regards

Raul Thomas

> HI Leonid,
>
[quoted text clipped - 30 lines]
>> restart
>> the service if necessary

Reply to this Message

Leonid S. Knyshov - 31 Mar 2006 12:17 GMT

> HI Leonid,
>
[quoted text clipped - 5 lines]
>
> Thanks so much for your input

This sounds a little strange. Perhaps you would like to remove the BCM data
from the laptop and attempt to reconnect to the desktop so that specific
error messages would become visible. I want to eliminate the cached
credentials effect by doing this.

It sounds like like a personal firewall problem. I could take a 5-minute
look at this I suppose. :-)

Ideally, I'd want to try creating a DSN in ODBCAD32 (pretty easy - you run
ODBCAD32, click Add, choose the SQL Server driver [typically listed on the
very bottom], and connect to the DESKTOPNAME\MicrosoftBcm or
DESKTOPNAME\MicrosoftSmlBiz - if successful, it'll let you proceed. If not,
well nothing will work anyway)

Signature

Leonid S. Knyshov, CEO
Crashproof Solutions, LLC - http://www.crashproofsolutions.com
MCP Exchange 2003/Small Business Server 2003, CCNA, SCSA 8, NCIE
Microsoft Small Business Specialist Partner

Reply to this Message