all groups > sql server replication > november 2007 >
You're in the

sql server replication

group:

Running ACT! 2008 Database on two Laptops


Running ACT! 2008 Database on two Laptops Charles Turner
11/3/2007 12:00:00 AM
sql server replication: Hi guys,

Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!

I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.

I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.

You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.

If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!

Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?

Thanks in advance,


Best Regards,



Charles

RE: Running ACT! 2008 Database on two Laptops John Bell
11/3/2007 8:13:01 AM
Hi Charles

You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You could
use SQL Profiler on the machine that works to see how it connects.

John

[quoted text, click to view]
AddThis Social Bookmark Button