Offline Sync Error

Posted by Angelo on December 15, 2005, 10:57 am

Please log in for more thread options

Hey all, I am receiving a "login error for user sa" everytime i z out and the
offline db tries to sync with the main db. The main db is located on another
server, while the offline db is located on the register machine itself. Both
dbs connect successfully from within the Administrator application. The
register works successfully with the main db, and when disabling the
connection to the main db, it successfully uses the offline db. Also, I
created a different user to connect to the offline db (not sa), so it seems
that it is getting this login error trying to connect to the main db. The
main server is xp prof, while the register is xp home running msde. Any
ideas? Thanks.

Posted by Angelo on December 15, 2005, 11:10 am

Please log in for more thread options

btw, the actual error is:
Login failed for user 'sa' Reason: Not associated with a trusted SQL Server
Connection.

Not sure why it works fine when using the POS system, but not on syncing...

Posted by Angelo on December 15, 2005, 1:37 pm

Please log in for more thread options

I found KB article 872360 and thought that was the answer. So far didn't
seem to work. Will try tonight after closing.

"Angelo" wrote:

> btw, the actual error is:

> Login failed for user 'sa' Reason: Not associated with a trusted SQL Server

> Connection.

> Not sure why it works fine when using the POS system, but not on syncing...

Posted by Jeff on December 15, 2005, 4:39 pm

Please log in for more thread options

Angelo,

Change the server machine to a static IP address and then change the server
name in SO Admin of each register machine to the IP address of the server.

--
*
I found KB article 872360 and thought that was the answer. So far didn't
seem to work. Will try tonight after closing.

"Angelo" wrote:

> btw, the actual error is:

> Login failed for user 'sa' Reason: Not associated with a trusted SQL

> Server

> Connection.

> Not sure why it works fine when using the POS system, but not on

> syncing...

Posted by Angelo on December 15, 2005, 5:49 pm

Please log in for more thread options

hey Jeff, thanks for the response. Unfortunately, it still doesn't work. I
am pretty sure it has to do with some configuration on the main server. I
set up my laptop as a POS Register, and it has the the same problem.
However, using the same laptop at home, with my home desktop (this is while i
was evaluating the software), it works perfectly fine. I can't figure it out.

"Jeff" wrote:

> Angelo,

> Change the server machine to a static IP address and then change the server

> name in SO Admin of each register machine to the IP address of the server.

> --

> *

> I found KB article 872360 and thought that was the answer. So far didn't

> seem to work. Will try tonight after closing.

> "Angelo" wrote:

> > btw, the actual error is:

> > Login failed for user 'sa' Reason: Not associated with a trusted SQL

> > Server

> > Connection.

> >

> > Not sure why it works fine when using the POS system, but not on

> > syncing...