Microsoft KB Archive/291683

{|
 * width="100%"|

FIX: xp_sqlagent_param Problems with Windows Authentication

 * }

Q291683

-

The information in this article applies to:


 * Microsoft SQL Server 2000 (all editions)

-

BUG #: 236006 (SHILOH_BUGS)

BUG #: 236007 (SHILOH_BUGS)

SYMPTOMS
When you set Windows Authentication, the xp_sqlagent_param extended stored procedure incorrectly returns this error message:

&quot;The system cannot find the file specified.&quot;

-or-

When you change the connection mode of SQL Agent, the xp_sqlagent_param extended stored procedure fails to accurately reflect that you have reverted back to the Microsoft Windows NT Connection Mode.

RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, please see the following article in the Microsoft Knowledge Base:

"Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack"

Hotfix
NOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.

The English version of this fix should have the following file attributes or later:

  Date       Time     Version   Size     File name ---

2/05/2001 7:03 AM  8.00.250  303,170  Sqlagent.exe 2/05/2001 7:03 AM  8.00.250   45,122  Sqlatxss.dll 2/05/2001 7:03 AM  8.00.250   45,122  Sqlcmdss.dll 2/05/2001 7:03 AM  8.00.250  270,400  Xpstar.dll NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.

Steps to Reproduce Behavior
Use Microsoft Windows Authentication for both SQL Server and SQL Agent.


 * 1) Run the script that follows with the SQL Agent started:
 * 2) Change the SQL Server connection to use SQL Server Authentication. Stop, and then restart the SQL Agent.
 * 3) Re-run the script.
 * 4) Change the SQL Agent back to Windows Authentication. Stop, and then restart the SQL Agent.
 * 5) Re-run the script.

Additional query words: security

Keywords : kbDSupport kbSQLServ2000bug kbSQLServ2000sp1fix

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ2000Search kbSQLServ2000