Publication

I have a publication on my SQL Server.

The first time my application syncs with the server it works fine.

If I try to sync again I get "Permission Denied Number 80040E09 NativeErr: 0"

Other publications work fine, it just seems to be this one.

Any ideas?

1. What kind of publication is this one, merge publication or transactional publication?

2. How many articles are in this publication and of what kind, table, view, SP or UDF?

3. What version of SQL server are you using on distribution/publisher/subscriber?

Thanks.

|||

1 - Merge to SQL CE

2 - 14 tables

3 - SQL Server Enterprise V 8.00.679 (SP2)

|||

by "the first time sync to server ", do you mean the initial sync ?

what are the login you used to connect to SQL server ? does this login has the read permission on the database ?

thanks

Yunwen

|||

Yes the initial sync

Unfortunately the previous developer used sa as the login (DOH)

Yes sa has privileges.

We are building a new server to get rid of that.

|||

Most likely this could a security configuration issue when connecting to the backend sql server. it is still not very clear why the subsequent sync failed with permission error though since SA should have sufficient permission during sync.

Does this still repro with the new application ? we should trace it down if it repro-es.

Thanks

Yunwen