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
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Monday, October 12, 2009
Subscribe to:
Posts (Atom)