Showing posts with label MSSQLServer. Show all posts
Showing posts with label MSSQLServer. Show all posts

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