शुक्रवार, 24 जुलाई 2009

SharePoint 2007 HTTP Error 503. The service is unavailable

How did I solved the "HTTP Error 503. The service is unavailable" followed by error "cannot connect to the configuration database"------------

I was working on a project and all of the sudden my SharePoint site and Central Admin started giving me the error ‘HTTP Error 503. The service is unavailable’ and I was not able to access either of them. I was not even able to connect to my Database SQL Server 2008. Thanks God! I realized soon I had changed my domain password a day before which stopped the application pool and also was not able to start MSSQLSERVER service.

I googled a lot and found the below solution:

1. Open up IIS Manager and click on Application Pools.
2. Locate your App Pool account and right-click on it and select ‘Advanced Settings’.
3. Click on the right of the Identity box to change it (A window will pop up).
4. Click on Set and simply retype your App Pool Identity in there with the new password.

Kind of weird but worked for me after giving me a day headache, I could get rid of ‘HTTP Error 503. The service is unavailable’ after restarting the IIS Server but got another shock ""cannot connect to the configuration database."

I took lesser time to identify the problem this time. I tried to login to the DataBase Server manually and was unsuccessful, this is common problem on changing the domain password which did not bother me much. The follwoing steps resolved it.

1. Goto Control Panel> Admin Tool> Services.
2. Right click on MSSQLSERVER service and choose properties.
3. Click on LogOn tab.
4. Change the Domain password.
5. Now start the service, come back to test whether can connect to SQL Server, Hurray! now connected successfully.

Final Touch, restarted all the services, could log back to my SharePoint site and Central Admin.

Regards,
Taruna- the FR