asked on

SQL Server 2000 error 1069?

The problem i am having is whenever i reboot my server the SQL service is automatically off. So when i go to start it manually i get the following error "The service did not start due to a logon failure", which is followed by an error number "1069". So to fix this i have to manually reenter my password for the MSSQL Server service and then start it again. Is there a way to fix this problem? i want to reboot and have it start automatically everytime. BTW, im not using our local system account for this service.

Thanks

xxg4813

Hi,

This post is helpful.

If you are running SQL 7 on your desktop, not a dedicated server, try this. Go to Control Panel | Services. Find MSSQLServer and go to Properties. From there, try logging on through your local system account rather than through a Domain. Hope this helps.

Good luck!

tipmontana

ASKER

Thanks for the advice, but i have tried that before w/ no success. BTW, we are using SQL2000...

ASKER CERTIFIED SOLUTION

cdillon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CleanupPing

tipmontana:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.

cdillon

I submit that my answer is correct and the points should go to me.

monosodiumg

No comment has been added to this question in more than 245 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
Accept: cdillon http:#8076984

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

monosodiumg
EE Cleanup Volunteer