1 person found this helpful
I would say this is an issue with the SQL server rather then CF. Have you tried using a different user for the datasource to see if the issue still happens?
If its the same time everyday, I would look at maintenance tasks on the SQL server to see if they are doing something that causes this kind of behaviour.
Need to check the jobs.
Also the default user name for the database was set... The other one which is running well is not having the default user name
The original reason is there is a job in our site which is reassigning the datasource and thus caused this. Now the problem is solved....
Please mark the correct answer. Thank you.