On 2000, you can change the password from the Services
applet in Administrative Tools. Select the properties for
the service mssqlserver and go to the Log On tab. You can
change the password there.
In Enterprise Manager, if you right click on a server and
select properties, you can change the login information on
the security tab.
-Sue
On Thu, 27 Jul 2006 18:05:01 -0700, rmcompute
[quoted text, click to view] <rmcompute@discussions.microsoft.com> wrote:
>It was definitely the password. I had Data Security switch my network
>password back to the old password and it worked. The problem is that I am
>forced to change my password monthly and can't keep having Data Security
>reset it. I am using SQL Server 2000 Developer Edition and it does not have
>the Server Configuration Manager. Is there any other way to change the
>password in SQL Server ?
>
>"Sue Hoegemeier" wrote:
>
>> It sounds like the services are running under your windows
>> account. If that's the case, you need to change the password
>> for the service accounts if they are the same as yours.
>> Looks like this is SQL Server 2005 so you can use the SQL
>> Server Configuration Manager to change the password for the
>> services.
>>
>> -Sue
>>
>> On Thu, 27 Jul 2006 12:19:02 -0700, rmcompute
>> <rmcompute@discussions.microsoft.com> wrote:
>>
>> >I installed SQL Server on my PC and it has been running fine for a few
>> >months. Now I cannot start it but get this message:
>> >
>> >-------------------------------------------------------------------------------------------
>> >An error 1059 - (The Service did not Start due to a logon failure) occurred
>> >while performing this Service Operation on the MSSLQServer)
>> >-------------------------------------------------------------------------------------------
>> >I recently changed by network password; Is there something that has to be
>> >done to SQL Server when this is done ?
>>
>>
I found it on Enterprise Manager as per your instruction.
Thank you.
[quoted text, click to view] "Sue Hoegemeier" wrote:
> On 2000, you can change the password from the Services
> applet in Administrative Tools. Select the properties for
> the service mssqlserver and go to the Log On tab. You can
> change the password there.
> In Enterprise Manager, if you right click on a server and
> select properties, you can change the login information on
> the security tab.
>
> -Sue
>
> On Thu, 27 Jul 2006 18:05:01 -0700, rmcompute
> <rmcompute@discussions.microsoft.com> wrote:
>
> >It was definitely the password. I had Data Security switch my network
> >password back to the old password and it worked. The problem is that I am
> >forced to change my password monthly and can't keep having Data Security
> >reset it. I am using SQL Server 2000 Developer Edition and it does not have
> >the Server Configuration Manager. Is there any other way to change the
> >password in SQL Server ?
> >
> >"Sue Hoegemeier" wrote:
> >
> >> It sounds like the services are running under your windows
> >> account. If that's the case, you need to change the password
> >> for the service accounts if they are the same as yours.
> >> Looks like this is SQL Server 2005 so you can use the SQL
> >> Server Configuration Manager to change the password for the
> >> services.
> >>
> >> -Sue
> >>
> >> On Thu, 27 Jul 2006 12:19:02 -0700, rmcompute
> >> <rmcompute@discussions.microsoft.com> wrote:
> >>
> >> >I installed SQL Server on my PC and it has been running fine for a few
> >> >months. Now I cannot start it but get this message:
> >> >
> >> >-------------------------------------------------------------------------------------------
> >> >An error 1059 - (The Service did not Start due to a logon failure) occurred
> >> >while performing this Service Operation on the MSSLQServer)
> >> >-------------------------------------------------------------------------------------------
> >> >I recently changed by network password; Is there something that has to be
> >> >done to SQL Server when this is done ?
> >>
> >>
>
Your welcome...thanks for posting back.
-Sue
On Sat, 29 Jul 2006 06:57:01 -0700, rmcompute
[quoted text, click to view] <rmcompute@discussions.microsoft.com> wrote:
>I found it on Enterprise Manager as per your instruction.
>
>Thank you.
>
>"Sue Hoegemeier" wrote:
>
>> On 2000, you can change the password from the Services
>> applet in Administrative Tools. Select the properties for
>> the service mssqlserver and go to the Log On tab. You can
>> change the password there.
>> In Enterprise Manager, if you right click on a server and
>> select properties, you can change the login information on
>> the security tab.
>>
>> -Sue
>>
>> On Thu, 27 Jul 2006 18:05:01 -0700, rmcompute
>> <rmcompute@discussions.microsoft.com> wrote:
>>
>> >It was definitely the password. I had Data Security switch my network
>> >password back to the old password and it worked. The problem is that I am
>> >forced to change my password monthly and can't keep having Data Security
>> >reset it. I am using SQL Server 2000 Developer Edition and it does not have
>> >the Server Configuration Manager. Is there any other way to change the
>> >password in SQL Server ?
>> >
>> >"Sue Hoegemeier" wrote:
>> >
>> >> It sounds like the services are running under your windows
>> >> account. If that's the case, you need to change the password
>> >> for the service accounts if they are the same as yours.
>> >> Looks like this is SQL Server 2005 so you can use the SQL
>> >> Server Configuration Manager to change the password for the
>> >> services.
>> >>
>> >> -Sue
>> >>
>> >> On Thu, 27 Jul 2006 12:19:02 -0700, rmcompute
>> >> <rmcompute@discussions.microsoft.com> wrote:
>> >>
>> >> >I installed SQL Server on my PC and it has been running fine for a few
>> >> >months. Now I cannot start it but get this message:
>> >> >
>> >> >-------------------------------------------------------------------------------------------
>> >> >An error 1059 - (The Service did not Start due to a logon failure) occurred
>> >> >while performing this Service Operation on the MSSLQServer)
>> >> >-------------------------------------------------------------------------------------------
>> >> >I recently changed by network password; Is there something that has to be
>> >> >done to SQL Server when this is done ?
>> >>
>> >>
>>
>>
Don't see what you're looking for? Try a search.