Offline Sync Error

Posted by Angelo on December 17, 2005, 10:50 am

Please log in for more thread options

Actually, I did create the db using the sa user (many times,actually). What
I meant to say in the original post is that I used different sql server
account logins(created new ones and gave permissions to dbs) on the
configuration tabs for the offline and main db, so that I would know where
the logon failure was occuring (locally or remotely). One thing i did do
though, is created an offline db on the main server (I know, not supposed to
do that) and it syncs fine to the same server...which leads me to believe
somehow this Windows authentication issue still exists(from kb article
872360). But I know those reg values are correct...

"Jeff" wrote:

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

Posted by Jeff on December 18, 2005, 4:01 am

Please log in for more thread options

Angelo,

I don't use XP Home, but I remember something about Simple File Sharing in
Pro having some issues with Home. Try adding the user name of the Home
machine into the user group on the Pro machine and turn off Simple File
Sharing. Restart both and log into the Pro machine from the Home machine
manually.

--
=

> Actually, I did create the db using the sa user (many times,actually).

> What

> I meant to say in the original post is that I used different sql server

> account logins(created new ones and gave permissions to dbs) on the

> configuration tabs for the offline and main db, so that I would know where

> the logon failure was occuring (locally or remotely). One thing i did do

> though, is created an offline db on the main server (I know, not supposed

> to

> do that) and it syncs fine to the same server...which leads me to believe

> somehow this Windows authentication issue still exists(from kb article

> 872360). But I know those reg values are correct...

> "Jeff" wrote:

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

Posted by Angelo on December 18, 2005, 1:02 pm

Please log in for more thread options

Yes, I was heading down that path. I noticed that when disabling the guest
account on the main server, the pos register was unable to connect to it (on
POS with either home or prof edition). I changed the local security policy
to "classic" instead of guest only, and created a user on the pos register
identical to one on the main server. So now authentication not using guest
account. However, this did not solve the problem...
However, and I am almost embarassed to admit this, but the reason for the
error was that SP3 for sql server was not installed on the server. Normally
this is one of the first things I check...since I was getting nowhere, I
started from scratch, checking differences between my test and live
setup...very novice mistake. Thanks to all that tried to help, much
appreciated.

"Jeff" wrote:

> Angelo,

> I don't use XP Home, but I remember something about Simple File Sharing in

> Pro having some issues with Home. Try adding the user name of the Home

> machine into the user group on the Pro machine and turn off Simple File

> Sharing. Restart both and log into the Pro machine from the Home machine

> manually.

> --

> =

> > Actually, I did create the db using the sa user (many times,actually).

> > What

> > I meant to say in the original post is that I used different sql server

> > account logins(created new ones and gave permissions to dbs) on the

> > configuration tabs for the offline and main db, so that I would know where

> > the logon failure was occuring (locally or remotely). One thing i did do

> > though, is created an offline db on the main server (I know, not supposed

> > to

> > do that) and it syncs fine to the same server...which leads me to believe

> > somehow this Windows authentication issue still exists(from kb article

> > 872360). But I know those reg values are correct...

> >

> > "Jeff" wrote:

> >

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

> >>

Posted by Jeff on December 19, 2005, 5:02 pm

Please log in for more thread options

Angelo,

That could be an issue! ;-)

Glad you worked it out.

--
*
Yes, I was heading down that path. I noticed that when disabling the guest
account on the main server, the pos register was unable to connect to it (on
POS with either home or prof edition). I changed the local security policy
to "classic" instead of guest only, and created a user on the pos register
identical to one on the main server. So now authentication not using guest
account. However, this did not solve the problem...
However, and I am almost embarassed to admit this, but the reason for the
error was that SP3 for sql server was not installed on the server. Normally
this is one of the first things I check...since I was getting nowhere, I
started from scratch, checking differences between my test and live
setup...very novice mistake. Thanks to all that tried to help, much
appreciated.

"Jeff" wrote:

> Angelo,

> I don't use XP Home, but I remember something about Simple File Sharing in

> Pro having some issues with Home. Try adding the user name of the Home

> machine into the user group on the Pro machine and turn off Simple File

> Sharing. Restart both and log into the Pro machine from the Home machine

> manually.

> --

> =

> > Actually, I did create the db using the sa user (many times,actually).

> > What

> > I meant to say in the original post is that I used different sql server

> > account logins(created new ones and gave permissions to dbs) on the

> > configuration tabs for the offline and main db, so that I would know

> > where

> > the logon failure was occuring (locally or remotely). One thing i did

> > do

> > though, is created an offline db on the main server (I know, not

> > supposed

> > to

> > do that) and it syncs fine to the same server...which leads me to

> > believe

> > somehow this Windows authentication issue still exists(from kb article

> > 872360). But I know those reg values are correct...

> >

> > "Jeff" wrote:

> >

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

> >>

Posted by Glenn Adams [MVP - Retail Mgmt on December 19, 2005, 10:01 am

Please log in for more thread options

If I understand this correctly, you are not using sa to connect to the
server. If that is correct, first just switch to the sa account to see if
it fixes the problem (This is on the Database tab - connection to the
Server).

The offline database syncs by creating a linked server object. You need a
fairly high level of access (way beyond DBO on the database) to create a
linked server - switch to sa and see if that helps, then you can check out
SQL Server Books Online to find exactly what server role you need to be
in...

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

> Actually, I did create the db using the sa user (many times,actually).

> What

> I meant to say in the original post is that I used different sql server

> account logins(created new ones and gave permissions to dbs) on the

> configuration tabs for the offline and main db, so that I would know where

> the logon failure was occuring (locally or remotely). One thing i did do

> though, is created an offline db on the main server (I know, not supposed

> to

> do that) and it syncs fine to the same server...which leads me to believe

> somehow this Windows authentication issue still exists(from kb article

> 872360). But I know those reg values are correct...

> "Jeff" wrote:

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