The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Knowledge Base

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

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:

In Control Panel, set the Standards and formats setting in the Regional and Language Options dialog box to English.
Restart the SQL Server service.
Change the SQL Server Agent proxy account.
If you want to use the original language settings, change the setting back in the Regional and Language Options dialog box.
Restart the SQL Server service.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

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'
```

You receive the error message that is mentioned in the "Symptoms" section.

Keywords: kbtshoot kbprb kbexpertiseadvanced KB926901

Microsoft KB Archive/926901

Contents