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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2008-03-31 : 00:03:08
|
| Hi Everyone, I try to implement transactional replication but I got the following errorThe process could not read file '\\192.168.X.XXX\replication_test\unc\DEV$Test_REP\20080331143817\test_2.pre' due to OS error 5.I set publisher and distributor on the same machine. I use pull ssubscribption. I have checked google and someone has mentioned that it's related to account issue. But my subscription server is not in domain. so what account should I set?Thank you in advance, |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 00:06:04
|
| You need to have domain account setup for replication to work. Doesn't work in local system account |
 |
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2008-03-31 : 00:18:02
|
SO if my servers are not in domain, is there workaround?quote:
Originally posted by sodeep
You need to have domain account setup for replication to work. Doesn't work in local system account
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 00:24:02
|
| You can go SQL server configuration manager,change account to Domain a/c from local system account.But you need to restart the services. Donot do if your subscribers is running production. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 23:48:06
|
| You can't start sql with domain account if server is not in domain.>> SO if my servers are not in domain, is there workaround?If they are in same workgroup, can try create windows account with same id/pwd on all related servers then start sql with that account. |
|
|
|
|
|
|
Replication problem