Post reply

failed login for 'sa' from distribution sql server for replication.

  • January 14, 2014 at 5:09 am

    #302642

    I have a two server configuration, both SQL 2008R2 SP2. One is a db server that has the live databases and one db server that holds the distribution database. All of a sudden on Friday every minute I get a failed login for 'sa' coming from the distibution SQL Server server to the SQL Server that holds the live databases. I haven't changed the 'sa' password and I cannot figure out on the distribution SQL Server where it stores the db servers 'sa' password. Anyone with any help?

  • January 14, 2014 at 8:24 am

    #1679932

    I figured it out on my own. Go into the publication that is failing and right click on it. Then click on Agent Security.Then click on Security Settings and change the Using the following SQL Server login.

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

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