initialize a subscriber

  • When the Publication was created there was a step called "Snapshot Agent Security".  On this step there two things that deal with accounts.

    First: Run under the following windows account. OR Run under the SQL Server Agent Service Account.

    Second: "Connect to the publisher"

    By Impersonating the process account. OR Using the following SQL server Login.

    Depending on the choices made here.  This is the account credentials that you’re looking for.

  • Maybe your subscriptions are expiring. You can change that in the publication by selecting "Subscriptions never expire"

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply