Offline Sync Error

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

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.

Angelo,

Any firewalls running on either machine? If running XP SP2, open the Windows firewall using these instructions;

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

HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode

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

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;

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

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

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

Angelo,

That could be an issue! ;-)

Glad you worked it out.