Microsoft KB Archive/926901

= Error message when you try to change the SQL Server Agent proxy account in SQL Server 2000: &quot;The system cannot find the path specified&quot; =

Article ID: 926901

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Workgroup Edition
 * Microsoft SQL Server 2000 Personal Edition
 * Microsoft SQL Server 2000 Enterprise Edition 64-bit

-



SYMPTOMS
Consider the following scenario. In Microsoft SQL Server 2000, you try to change the SQL Server Agent proxy account by using SQL Server Enterprise Manager or by using the xp_sqlagent_proxy_account system stored procedure. In this scenario, you may receive the following error message:

The system cannot find the path specified

This problem occurs if the following conditions are true:
 * You are running SQL Service 2000 Service Pack 4 (SP4).
 * The Standards and formats setting in the Regional and Language Options dialog box is set to something other than English.



WORKAROUND
To work around this problem, follow these steps:
 * 1) In Control Panel, set the Standards and formats setting in the Regional and Language Options dialog box to English.
 * 2) Restart the SQL Server service.
 * 3) Change the SQL Server Agent proxy account.
 * 4) If you want to use the original language settings, change the setting back in the Regional and Language Options dialog box.
 * 5) Restart the SQL Server service.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Steps to reproduce the problem
 Install SQL Server 2000 SP4. Change the SQL Server startup account to a local user account or to a domain user account. Change the Standards and formats setting in the Regional and Language Options dialog box to Hungarian. Restart the SQL Server service. Create a local administrator user in Microsoft Windows for testing.  Log on to the instance of SQL Server by using SQL Query Analyzer, and then run the following statement. xp_sqlagent_proxy_account N'SET', N'ComputerName', N'UesrName', N'Password' </li></ol>

You receive the error message that is mentioned in the &quot;Symptoms&quot; section.

Keywords: kbtshoot kbprb kbexpertiseadvanced KB926901

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.