Hi, folks!
I'm trying to change SQLServerAgent password, as described in the following
link...
http://support.microsoft.com/default...b;en-us;259710
... but in client machine (withou any interface), with Win98 O.S.
Do you have any ideas? (procedure, etc...)
If you don't have access to Enterprise Manager, one option is to
install the SP3 version of MSDE.
-Sue
On Thu, 28 Oct 2004 07:29:03 -0700, Du Santos
<DuSantos@.discussions.microsoft.com> wrote:
>Hi, folks!
>I'm trying to change SQLServerAgent password, as described in the following
>link...
>http://support.microsoft.com/default...b;en-us;259710
>... but in client machine (withou any interface), with Win98 O.S.
>Do you have any ideas? (procedure, etc...)
|||Sorry, I think that I did not understand what you said... I have MSDE SP3 on
clients. When I install it, the sa password is informed. But SQLServerAgent
password remains the same (blank). How to change this pwd?
Thanks for reply.
Du Santos
"Sue Hoegemeier" wrote:
> If you don't have access to Enterprise Manager, one option is to
> install the SP3 version of MSDE.
> -Sue
> On Thu, 28 Oct 2004 07:29:03 -0700, Du Santos
> <DuSantos@.discussions.microsoft.com> wrote:
>
>
|||The reason I referred to using SP3 was that the issue from the article
http://support.microsoft.com/default...b;en-us;259710
is an issue under SP1 and SP2.
If you are on MSDE SP3, the password requirement and usage info is in
the ReadMe file for this service pack.
-Sue
On Wed, 3 Nov 2004 03:21:05 -0800, Du Santos
<DuSantos@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sorry, I think that I did not understand what you said... I have MSDE SP3 on
>clients. When I install it, the sa password is informed. But SQLServerAgent
>password remains the same (blank). How to change this pwd?
>Thanks for reply.
>Du Santos
>"Sue Hoegemeier" wrote:
|||According to the KB article, after you change SA password, and if your
SQLagent is using SA account to connect to SQL server, you need to type in
the new SA password on the SQLagent property/connect page to enable the
agent to connect to SQL again.
You may find any machine in your network which has SQL SEM installed to
perform the task. If your W98 is stand alone, you may consider installing
SQL client to the machine to give you an interface for this and other
possible tasks.
Thanks
Lan Lewis-Bevan
MS SQL support
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
No comments:
Post a Comment