Temat: [Entity Framework] The underlying provider failed on Open.

System.Data.EntityException was unhandled by user code

  Message=The underlying provider failed on Open.

  Source=System.Data.Entity

  StackTrace:

       at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)

       at System.Data.EntityClient.EntityConnection.Open()

       at System.Data.Objects.ObjectContext.EnsureConnection()

       at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)

       at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()

       at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)

       at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)

       at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)

       at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)

       at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)

       at OneWebsite.Membership.ApplicationManager.GetApplicationID(Entities data, String ApplicationName) in C:\Users\Krzysiek\Documents\Visual Studio 2010\Projects\projekt\projekt\OneWebsite\OneWebsite.Membership\ApplicationManager.cs:line 21

       at OneWebsite.Membership.EFRoleProvider.Initialize(String name, NameValueCollection config) in C:\Users\Krzysiek\Documents\Visual Studio 2010\Projects\projekt\projekt\OneWebsite\OneWebsite.Membership\EFRoleProvider.cs:line 91

       at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)

  InnerException: System.Data.SqlClient.SqlException

       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 - Nie można nawiązać połączenia, ponieważ komputer docelowy aktywnie go odmawia.)

       Source=.Net SqlClient Data Provider

       ErrorCode=-2146232060

       Class=20

       LineNumber=0

       Number=10061

       Server=""

       State=0

       StackTrace:

            at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

            at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

            at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)

            at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)

            at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)

            at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

            at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

            at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

            at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

            at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

            at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

            at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

            at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

            at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

            at System.Data.SqlClient.SqlConnection.Open()

            at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)

       InnerException: 

Mam pewien problem z połączeniem z bazą danych. Otrzymuje taki oto komunikat błędu jak powyżej.

W dwóch projektach korzystam z tego samego connection stringa i działa poprawnie, w ostatnim natomiast sypie błędem. Nie mam pomysłu co może być nie tak.
Dodałem ConnectionTimeOut =600 ale nie pomogło. Do bazy mam maksymalnie 3 połączenia otwarte.

Z góy dziekuje za pomocKrzysiek Z. edytował(a) ten post dnia 01.02.12 o godzinie 23:56

Temat: [Entity Framework] The underlying provider failed on Open.

Otwarte połączenie w Visual Studio w Server Explorer?

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 - Nie można nawiązać połączenia, ponieważ komputer docelowy aktywnie go odmawia.)

Próbowałeś z remote connections?

Temat: [Entity Framework] The underlying provider failed on Open.

problem rozwiązany, MSSQL umożliwiał połączenie jedynie z ip serwera.