Replication Error in windows server 2003 and 2008 SQL server
-
7 августа 2012 г. 18:04
Hi,
we are trying to configure replication,during the process we are getting below error
subscriber server :SQL 2008 server (SQL agent is running with local user account(local admin)
Publisher server :SQL 2000 server (SQL agent is running with domain account(domain admin privileges)
both server in same domain.
Uthanda
Все ответы
-
7 августа 2012 г. 19:11Модератор
Can you make s:\Program Files\Microsoft SQL Server\MSSQL\ReplData a share that the everyone group has list files and folders permission to. Then make this your snapshot folder.
If the everyone group can access the snapshot share then you know that security is your problem. Then make a local machine account on your publisher with the same name and password as it has on the subscriber and then use this account to do the pull
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Предложено в качестве ответа Brandon WilliamsMicrosoft Community Contributor, Moderator 12 августа 2012 г. 20:01
- Помечено в качестве ответа amber zhangModerator 14 августа 2012 г. 2:50
-
14 августа 2012 г. 3:31
Hi,
Thanks!!!
created same user account and tried replication and its working without any issues
Uthanda
.png)
