Our stagging environment is on a single server with 3 virtual servers,
- Database Server
- K2 Workflow Server
- WebFrontEnd Server
Now time to time I am getting this exception for a webpart in event log, not sure what could be the possible cause for this error.
The error was:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - Only one usage of each socket address (protocol/network address/port) is normally permitted.)
Can anyone tell me what could be the possible issue to look at, I also noticed OWSTIMER.exe on web front end server is on top with most memory consumption however processor is alright, restarting Windows Service Timer job bring OWSTimer.exe back down but there isn't any workflow but custom timer job that runs each 15 minutes but then I checked with SP Dispose checker tool, its not leaking any memory.