Hello

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T. Theunissen - 29 Jul 2005 15:48 GMT

After the command : " xp_sqlagent_proxy_account N'Del'"
I get the following errormessage :

The system cannot find the path specified.

Can anybody explain what is happening?

Reply to this Message

Sue Hoegemeier - 02 Aug 2005 03:03 GMT

Did you change the service account using the services applet
instead of Enterprise Manager? You can get a similar error
if the service accounts are changed through the services
rather than through Enterprise Manager as the permissions
aren't set up correctly when done outside of Enterprise
Manager.

-Sue

>After the command : " xp_sqlagent_proxy_account N'Del'"
>I get the following errormessage :
>
>The system cannot find the path specified.
>
>Can anybody explain what is happening?

Reply to this Message

T. Theunissen - 02 Aug 2005 08:40 GMT

Hello Sue,

Thanks for the suggestion, but this errormessage appears just when I change
the account with the Enterprise manager, have you an idea of which
permissions are involved?

Teun

> Did you change the service account using the services applet
> instead of Enterprise Manager? You can get a similar error
[quoted text clipped - 11 lines]
> >
> >Can anybody explain what is happening?

Reply to this Message

Sue Hoegemeier - 03 Aug 2005 00:44 GMT

Maybe you misunderstood - I wasn't referring to the error
happening from changing the proxy account but from changing
the service accounts for SQL Server/SQL Agent outside of
Enterprise Manager.
The permissions needed for the service accounts can be found
going through the following article:
HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811

-Sue

>Hello Sue,
>
[quoted text clipped - 19 lines]
>> >
>> >Can anybody explain what is happening?

Reply to this Message

TOMAS CARLOS OTANO - 19 Jan 2006 20:50 GMT

THE SOLUTION IS
SEARCH INTO THE SQL INSTALLATION PATH
..\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\
YOU HAVE A FOLDER NAMED "1033". MAKE A COPY (NOT RENAME OK!? JUST A
COPY)WITH THE NAME "1034"
SQL is searching for this file in that location:
..\Program Files\Microsoft SQL
Server\MSSQL\Binn\Resources\1034\sqlstbss.rll
OTHERWISE TRY TO LOCATE THAT FILE sqlstbss.rll and follow THE PREVIOUS
INSTRUCTIONS.
TRY AGAIN xp_sqlagent_proxy_account N'Del'
VOIL?

GOOD SHOW !

Reply to this Message

Anand Kuppa - 27 Jan 2006 12:35 GMT

Hi

Did you find a resolution to this problem? am facing a similar
situation.

Thanks
AKuppa

Reply to this Message