Windows Activation Service (WAS) failed to start : Error 3

Windows Process Activation services (WAS) failed to start in IIS 7.5:

Error Discription : I recently had this issue in our production environment when our production website stopped all of a sudden and we were not able to start the site and getting an error that WAS and W3SVC services are in stopped state. 
When we tried to start W3SVC service from the services.msc console we got another error that this service failed to start as this is dependent on WAS (Windows Process Activation Service)..as following.

"The World Wide Web Publishing Service service depends on the Windows Process Activation Service service which failed to start because of the following error: The system cannot find the file specified."

When we try to start  Windows Process Activation Service - WAS... we get another error something like following...

"The Windows Process Activation Service service terminated with the following error3 : The system cannot find the file specified."

Solution :

We tried all the paths like where the services or its files could be located but failed. Then at last from the Google Uncle we got the following solution.. Hope this would work for you too....




Steps :
1. Check the following path if it is present there on the box...
     C:\inetpub\temp\apppools
2. If the apppools folder is not present under the path then this is the culprit of your problem. Just create this folder under C:\inetpub\temp (if temp is also not present then first create temp folder under C:\Inetpub and then create apppools under temp). 
3. Once you create the folder apppools under c:\inetpub\temp.. Go to services.msc and start WAS service. This time you should not get any error.
4. Now start W3SVC service. This service too would start now.

Now you can start your stopped website without any issue...

Happy Googling!!! ENJOY!!!!

Command to check the open and listening ports on Windows Machine

We can use following commands on a windows machine to find all open ports: 

1. To list all the open ports on machine :

•     netstat -an |find /i "listening" 

2. To list all the established connections on machine : 

•    netstat -an |find /i "Established"

3. To list the processes owning the established connection :

•  netstat -ao |find /i "Established"

ENJOY :-)

How To Check Crawl Status of Windows Sharepoint Services 3.0 Search

Recently I came across with a Search Issue in my Clients WSS 3.0 Sharepoint enviornment. Search was running but was crawling only very few sites. It was not even crawling any document library. I checked the Search Searvice Account's access to all content Databases and it had full read access to all content. Still there were only very few search results shown against any keyword.

Unfortunately there is No GUI available in WSS 3.0 Search to check Its Crawl Status or Crawl Logs.
I did some googling and found these SQL Queries to check the Crawl Status of Search in WSS 3.0 Environment.


Queries

Notes -

• WSS_Search corresponds to your default search database.
• All the following queries should be run in SQL Query Analyzer in Management Studio of your defaul databse server for WSS 3.0

        

1.  SQL Query to check the last crawled URLs (WSS 3.0. )

I found these Queries Really Very Useful.
ENJOY!!!!!!!!!!!SELECT [DocID],[AccessURL],[DisplayURL],[DisplayHash],[LastTouchStart],[LastTouchEnd]
FROM [WSS_Search].[dbo].[MSSCrawlURL]
where DisplayURL like '%wsstest:90%'
order by LastTouchStart desc

2. SQL Query to check the crawl errors for the SharePoint sites (WSS 3.0.)select msscrawlurllog.lasttouchstart as Time, msscrawlurllog.displayurl as URL,msscrawlurllog.errorid as Error, msscrawlerrorlist.errormsg as Description
from msscrawlurllog
join msscrawlerrorlist on msscrawlurllog.errorid = msscrawlerrorlist.errorid
order by msscrawlurllog.lasttouchstart

3. SQL Query to find how many items have been crawled for the SharePoint site (WSS 3.0.)SELECT [HostID],[HostName],[SuccessCount],[ErrorCount],[WarningCount]
FROM [WSS_Search].[dbo].[MSSCrawlHostList]
where HostName like '%wsstest:90%'

4. SQL Query to find out the crawl 'Start" and 'completed" time ( WSS 3.0.)SELECT [CrawlID],[RequestTime],[Status],[StartTime],[EndTime]
FROM [WSS_Search].[dbo].[MSSCrawlHistory]
order by starttime desc