MS SQL SERVER SERVICE error

Dev Shed Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

August 12th, 2003, 11:45 AM

sqlkid

Junior Member

Join Date: Aug 2003

Posts: 6

Time spent in forums: < 1 sec
Reputation Power: 0

MS SQL SERVER SERVICE error

Hi there !!
I am uisng microsoft product for the past 8 years. I need the help in SQL Server 2000 this time.

My MSSQL 2000, was working very fine on my notebook and Compaq deskpro EN. Recently, a destructive virus hit my system(deskpro) and corrupt everything from my OS to all installed product. Then, I formated my hard disk to get rid of him and reinstalled all the products which i have had. On SQL 2000, everything going well on installtion. I not even seen an single error but when i trying to start SQL Server Service Manager, i got this nasty error...

An error 1069, (The service didn't start due to logon failure.) occured while performing this service operation on MSSQL Service.

I try my best to get rid of this problem and even find one article in Microsoft knowledge base i.e. http://support.microsoft.com/?id=282254. No doubt, the article was good but it not sort out mine problem. I am still getting the same one. It arises may be because of some else reason...

If i missed any inoformation which you need /seek/want then let me know at your earliest convienence.

Would anyone like to eloborate or put some more light why it happend ? Please help me to get rid of it as soon as possible.

Any support is widely accepted !

Last edited by sqlkid : August 12th, 2003 at 11:48 AM.

August 13th, 2003, 09:38 AM

mitakeet

Last Day: May 28, 2005

Join Date: Jul 2003

Location: Maryland

Posts: 4,575

Time spent in forums: 1 Week 2 Days 8 h 5 m 34 sec
Reputation Power: 20

I suggest that during your installation you inadvertently allowed the database to install for a single user. Try to use it logged on as the actual user that was logged on when the db was installed. If that works your best choice may be to uninstall it, then reinstall it and be sure that you check the system level account at the appropriate time.

__________________

Left DevShed May 28, 2005. Reason: Unresponsive administrators.
Free code: http://sol-biotech.com/code/.
Secure Programming: http://sol-biotech.com/code/SecProgFAQ.html.
Performance Programming: http://sol-biotech.com/code/PerformanceProgramming.html.

It is not that old programmers are any smarter or code better, it is just that they have made the same stupid mistake so many times that it is second nature to fix it.
--Me, I just made it up

The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man.
--George Bernard Shaw

August 13th, 2003, 11:27 PM