Since the past couple days, I'm getting a lot of the following exceptions.  It's probably a couple every minute.  I've not changed anything on the site.

 

Message: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 - An attempt was made to access a socket in a way forbidden by its access permissions.)

StackTrace:

   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)
   at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)
   at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
   at DotNetNuke.Modules.Repository.SqlDataProvider.GetRepositoryObjects(Int32 ModuleId, String sFilter, String sSort, Int32 Approved, String CategoryId, String sAttributes, Int32 RowCount)
   at DotNetNuke.Modules.Repository.RepositoryController.GetSearchItems(ModuleInfo ModInfo)
   at DotNetNuke.Services.Search.ModuleIndexer.GetSearchIndexItems(Int32 portalId)

 

InnerMessage:An attempt was made to access a socket in a way forbidden by its access permissions

typically that indicates you are having network problems connecting to your sql server (http://stackoverflow.com/questions/18... offerts various things you can check) - however, typically if you are set up wrong nothing will work, its odd to see it occasionally work. At a guess I would say that a network device is causing multiple routes to be traversed (e.g. a load balancer or firewall), and one of more of the routes is not working (e.g. perhaps doesn't allow the sql server port)

---

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US

The sites work fine though. If there was a SQL issue, wouldn't I be getting a problem there too?