Can someone please explain exactly how the Distribution task logs on via SQL Server? I am setting up Replication for testing, and the task keeps failing with a 2800 ODBC Error: Login Failed. SQL Exec is running under a sep account as a Domain Admin. It is using repl_subscriber as the owner of the task. How can I fix this so it works? This is a local Single Pub/sub/Distrib
Thanks in advamce.................