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 |
|
betesh
Starting Member
34 Posts |
 Posted - 2008-06-15 : 07:15:37
|
| Hi,I am trying to test a replication or at least get the feel for it on my local copy before I set it up on the real server.Can I do that by setting my local database as the publisher as well as the subscriber?I am getting an error message but I am wondering if there are any settings I can change to make this work. Or any other ideas of how to see the replication tool before actually doing it live?Error message:"Server 'MyComputerName' is neither a Publisher nor a Distributor, or you do not have permission to access replication functionality on this server.I might add that I am not only new to the project but also new to MS SQL Server.Thank you! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-15 : 19:47:36
|
| Yes with different dbs. Did you config distributor yet? |
 |
|
|
|
|
|
Test replication on local copy?