Offline Sync Error

Posted by Jeff on December 16, 2005, 12:35 am

Please log in for more thread options

Angelo,

Any firewalls running on either machine? If running XP SP2, open the
Windows firewall using these instructions;
http://tinyurl.com/78fzl
--
*
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...

Posted by Angelo on December 16, 2005, 1:30 pm

Please log in for more thread options

Nope, one of the first things i tried...sorry, should of mentioned that. It
just doesn't make sense that the POS system connects fine, never a
problem...but on syncing there is a login error? Isn't it using the same
credentials?

"Jeff" wrote:

> Angelo,

> Any firewalls running on either machine? If running XP SP2, open the

> Windows firewall using these instructions;

> http://tinyurl.com/78fzl

> --

> *

> 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...

> >

Posted by Glenn Adams [MVP - Retail Mgmt on December 16, 2005, 2:49 pm

Please log in for more thread options

That error seems to be indicating that SQL Server or MSDE was installed with
the "Windows Authentication" option rather than "Mixed Mode", which is what
KB872360 is trying to address. Did you run the statement from the KB on ALL
systems, including the server?

There is a registry entry that you can check to see the current
authentication mode, but the SQL from the KB should have updated this...

HKLMSOFTWAREMicrosoftMSSQLServerMSSQLServerLoginMode

In Mixed Mode (What you want it to be) this registry entry will have a value
of 2. If you see any other value in that key, try the instructions from the
KB again - make sure you stop and restart SQL Server...

--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

>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 16, 2005, 8:47 pm

Please log in for more thread options

hey glenn, thanks for the reply. I actually came across that KB article
right after I posted here. It was the exact problem I was having, but,
unfortunately it didn't solve my issue. I did check the reg values (after I
ran those scripts) on both machines and they were both set to 2. I not only
started/stopped sql server but rebooted both machines. I am pretty confident
that the issue lies in the server. As I stated above, I set up my laptop as
a test POS register and it has the same problem when pointing to my live
server. The same exact laptop (same settings) pointed to my test server
works perfectly fine. I am pretty much at a loss right now; any ideas,
suggestions, or anything would be great. thanks!

"Glenn Adams [MVP - Retail Mgmt]" wrote:

> That error seems to be indicating that SQL Server or MSDE was installed with

> the "Windows Authentication" option rather than "Mixed Mode", which is what

> KB872360 is trying to address. Did you run the statement from the KB on ALL

> systems, including the server?

> There is a registry entry that you can check to see the current

> authentication mode, but the SQL from the KB should have updated this...

> HKLMSOFTWAREMicrosoftMSSQLServerMSSQLServerLoginMode

> In Mixed Mode (What you want it to be) this registry entry will have a value

> of 2. If you see any other value in that key, try the instructions from the

> KB again - make sure you stop and restart SQL Server...

> --

> Glenn Adams

> Tiber Creek Consulting

> http://www.tibercreek.com

> glenn@tibercreek.com

> ----------------------------------------------

> Please DO NOT respond to me directly but post all responses here in the

> newsgroup so that all can share the information

> >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 17, 2005, 12:29 am

Please log in for more thread options

Angelo,

Re-reading your original message again, while it shouldn't make a
difference, delete and re-create the offline database again. This time use
the "sa" user name. There is no need to use anything different. Make sure
you follow the instructions in this KB article;
http://tinyurl.com/75cs9

--
=

> 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.