MAK1 (12/17/2010)
SQL server 2005 installed but I can't start the services, I am a local admin of my server, I use my account and also I user local system account, still getting following error"The SQL Server(MSSQLSERVER) service on local computer started and then stoped.Some services stop automatically if they have no work to do, for example. the performance logs and Alerts service"
Also on configration manager I change the Protocols for MSSQLSERVER Named Pipes to Enable
Okay, one of two things may be happenning:
1) The service account running sql server may have had a recent password change and you haven't updated the password in sql server. If that is the case, sql server is trying to use the old password that was associated with the account. Under sql server properties, on the "log on" tap update the password.
2) You are on an eval copy of the product and it has expired. Check the error log located @ C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG and search for "expired".
My guess is you changed the service account password and need you need to bounce your box.
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends