Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
creditwatch
Starting Member
4 Posts |
 Posted - 2004-09-13 : 12:04:31
|
| I setup the replication of a database to my backup server by building a publication with just one table in the selection. The table replicated fine but when I try to access it on the backup server I get a permission error. I didn't get the error before on the backup server. Only after the table was replicated. What did I do wrong in this setup. |
|
|
creditwatch
Starting Member
4 Posts |
Posted - 2004-09-13 : 12:13:40
|
| It seems that after replication that the public permission were all unchecked. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-13 : 23:47:56
|
| when you replicate tables and they're being recreated, permissions are also dropped, you need to set them up again or change the snapshot properties to "not to" drop the tables just delete the records, so everytime you need to reinitialize you won't get this problem... |
|
|
|
|
|
|
Replication tables and permission problems