Monday, October 12, 2009

SQL Server error 1069

When you are starting SQL Server via SQL Server Enterprise Manager or MSSQLServer Services application in the Control Panel, it generates this error:

An error 1069. (The service did not start due to a logon failure) occurred while performing this service operation on the MSSQLServer Services


Solutions:

When the above error happens in a windows XP machine go to Start -> Run -> services.msc. Then double click on MSSQLServer.

i) Under the Log on tab choose Local System Account. This will enable the system account serve the sql instance

ii) As a developer if the computer is assigned a user name and password, try entering the correct password for the account which should resolve the above error message

1 comment: