February 21, 2008 at 6:18 am
Hello,
I want to implement the replication in the same server. But whenever i try to login by "Create Publication Wizard" and i choose the first option "Distributor as my own server" following message appear.
"SQL SERVER AGENT ON CURRENTLY USES THE SYSTEM ACCOUNT, WHICH CAUSES REPLICATION BETWEEN SERVERS TO FAIL"
I have already tried to login with other user as well as SQL user and Windows user, but SQLSERVERAGENT unable to login by these users.
Please urgently help me
February 21, 2008 at 6:37 am
you need to setup the sql agent service to run under a domain user account
February 21, 2008 at 5:47 pm
"If SQL Server Agent is currently configured to use the System account, you'll see a dialog box prompting you to configure the agent to use a domain account... "
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c09ppcsq.mspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply