|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
|||
|
|||
|
Replication Help
I am trying to configure my sql server as a publisher/distributor to create Merge Replication. Every time I do so, I get an error message that says 'SQL Server Agent on <server> currently uses the system account, which causes replication between servers to fail. In the following dialog box, specify another account for the service startup account.'
When I click ok and it takes me to the ensuing dialog box, my only other option is "This Account' which has a name 'LocalSystem' and a blocked-out password. If I select that, click on apply, and then ok I get taken right back to where I was. Any ideas? |
|
#2
|
|||
|
|||
|
Go to the offending server and change the log on permissions for that account. It could be beneficial to create a dba or operator account that has all the access the MS SQL Servers will need. Once you have done that you should be able to publish.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Replication Help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|