I am getting this error while trying to access my website:
Exception information:
Exception type: SqlException
Exception message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
This error occurs 6-7 times in a whole day.
Can anyone tell me why do I am getting this error? Is there any special settings I can made on my SQL server end to avoid this crash or its a problem in my web application?