Thank you, Lu Wei.
Your message is certainly very helpful. I will do this if next time I have
this issue.
Yesterday, I changed my windows password to the original one(somehow I just
memorize the old password )and restarted the computer. So the sql server
started and I re-registered the server with sql server userID and password.
It works fine.
--
Betty
[quoted text, click to view] "Wei Lu" wrote:
> Hi Betty,
>
> Thank you for using MSDN Managed Newsgroup Support.
>
> From your description, my understanding of this issue is: You want to
> change your SQL Server 2000 running account. If I misunderstood your
> concern, please feel free to let me know.
>
> Please follow these steps to resolve your problem:
> 1. In the Start menu, click Run, type services.msc and then click OK. This
> will appear a Sevices dialogbox.
>
> 2. In the Services, find the windows servicec for SQL Server. For default
> instance, the service name is MSSQLSERVER and for named instance, it is
> MSSQ$InstanceName.
>
> 3. Right-click the service, click Properties in the menu.
>
> 4. Click the Log On tab. Chose the Local System account under the Log on
> as: label.
>
> 5. Click OK and then Right-click the Service, click Restart to restart the
> service.
>
> 6. After doing this, you can try to connect to your SQL Server Instance.
>
> Hope this will be helpful!
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
Hi Betty,
Thank you for your update. Glad to hear you resolved this issue by changing
the start up account password back to the original one
If you have any questions or concerns, please feel free to let us know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.