Cannot set SQL Agent Proxy account

  • When I try to change form Enterprise Manager SQL Server Agent when clicking Button

    Reset Proxy account and entering new username/password/doamain I get error:

    Unable to set SQL Agent proxy account because of the reason listed below 'The network path was not found'

    I try this with different domain accounts and correct local policies but got same error every time

    What this error means 'The network path was not found' in current case ?

  • You are missing a file because Microsoft assumed that only people in the US would ever want to configure a Agent proxy account.

    In the SQL server (not client!) program folder - ...\Binn\Resources - copy the 1033 folder and rename it to the locale code configured for Windows.  For example for UK English rename it to 2057, and make sure you keep the original 1033 folder.  You can get a list of Microsoft locale codes from Google, or your Infrastructure people might know what has been used.

    Also, the password for the proxy account must not exceed 15 characters.  You can enter a longer password, but only the first 15 get stored.

     

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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