CRM Needs Manual IIS Reset Daily

Usually a problem like this is because of unhandled exceptions building up.  However, for now let's look at another solution.  Do you have any process recycling setup in the Application Pool for CRM?

Have you looked at the windows event logs and IIS logs for any oddities?

Can you explain a bit more about the "CRM will not Load"?

Are you getting an error?  Is this CRM 4 or CRM 3?

What else is running on this particular server?

CRM 3, and when someone attempts to open CRM from the web it takes a long time but it will end up on a page cannot be displayed or will cycle for a very long period of time with no action.  From outlook however the crm add-on gives an error and greys out.  I will review IIS and the error logs and post the information I find.  These are both SBS servers so they are running sharepoint sites, exchange, backup exec, dhcp, dns and several others.  

This is happening at two completely separate clients.  One is CRM4 and the other is CRM3, I will look through the logs tomorrow morning when the issue is occuring.  

Here are some of the event logs, unfortunately I'm not sure if they're relavent or not.  

Event Type:      Error
Event Source:      Windows SharePoint Services 3 Search
Event Category:      Gatherer
Event ID:      2424
Date:            5/6/2009
Time:            6:20:06 AM
User:            N/A
Computer:      CRCSBS
Description:
The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again.Context: Application 'Search', Catalog 'index file on the search server Search'For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Event Type:      Error
Event Source:      Windows SharePoint Services 3
Event Category:      Database
Event ID:      3355
Date:            5/5/2009
Time:            10:45:40 PM
User:            N/A
Computer:      CRCSBS
Description:
Cannot connect to SQL Server. np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query not found. Additional error information from SQL Server is included below.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Event Type:      Error
Event Source:      DNS
Event Category:      None
Event ID:      4004
Date:            12/28/2008
Time:            2:33:07 AM
User:            N/A
Computer:      CRCSBS
Description:
The DNS server was unable to complete directory service enumeration of zone ..  This DNS server is configured to use information obtained from Active Directory for this zone and is unable to load the zone without it.  Check that the Active Directory is functioning properly and repeat enumeration of the zone. The extended error debug information (which may be empty) is "". The event data contains the error.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 2a 23 00 00               *#..    


Event Type:      Warning
Event Source:      W3SVC
Event Category:      None
Event ID:      1010
Date:            5/6/2009
Time:            11:52:03 AM
User:            N/A
Computer:      CRCSBS
Description:
A process serving application pool 'CRMAppPool' failed to respond to a ping. The process id was '14868'.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Event Type:      Error
Event Source:      W3SVC
Event Category:      None
Event ID:      1059
Date:            5/6/2009
Time:            6:25:12 AM
User:            N/A
Computer:      CRCSBS
Description:
A failure was encountered while launching the process serving application pool 'SharePoint - 2878'. The application pool has been disabled.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type:      Warning
Event Source:      W3SVC
Event Category:      None
Event ID:      1057
Date:            5/6/2009
Time:            6:25:12 AM
User:            N/A
Computer:      CRCSBS
Description:
The identity of application pool 'SharePoint - 2878' is invalid, so the World Wide Web Publishing Service can not create a worker process to serve the application pool.  Therefore, the application pool has been disabled.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The last two problems look bad.  A web application runs under and an application pool with an identity.  That tells me that in the early hours something is happening that is affecting your application pool and caused the problems.  What WAN events happen at that time?

I'll check on each server, not sure what wan events occur...