Server Error in '/' Application.

Unable to access availability database 'Musicnotes' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Unable to access availability database 'Musicnotes' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Unable to access availability database 'Musicnotes' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.]
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1336
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +164
   System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +383
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +307
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +201
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +422
   System.Data.SqlClient.SqlConnection.Open() +1343
   System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch(TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) +104
   System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext) +473
   System.Data.Entity.SqlServer.<>c__DisplayClass1.<Execute>b__0() +19
   System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +234
   System.Data.Entity.Core.EntityClient.EntityConnection.Open() +318

[EntityException: The underlying provider failed on Open.]
   System.Data.Entity.Core.EntityClient.EntityConnection.Open() +738
   System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions) +167
   System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) +63
   System.Data.Entity.Core.Objects.<>c__DisplayClass7.<GetResults>b__5() +203
   System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +234
   System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +354
   System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() +31
   System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() +39
   System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +261
   Musicnotes.Application.Services.FeatureToggleSplitTestService.IsFeatureEnabledForHostname(String featureName, String hostname) in C:\BuildAgent\work\dac5058dfd42cc39\musicnotes_mn1\Musicnotes.Application\Services\FeatureToggleSplitTestService.cs:28
   Castle.Proxies.Invocations.IFeatureToggleRepository_IsFeatureEnabledForHostname.InvokeMethodOnTarget() +158
   Castle.DynamicProxy.AbstractInvocation.Proceed() +110
   Musicnotes.Application.ExceptionLogger.Intercept(IInvocation invocation) in C:\BuildAgent\work\dac5058dfd42cc39\musicnotes_mn1\Musicnotes.Application\ExceptionLogger.cs:56
   Castle.DynamicProxy.AbstractInvocation.Proceed() +447
   Castle.Proxies.IFeatureToggleRepositoryProxy.IsFeatureEnabledForHostname(String featureName, String hostname) +149
   Musicnotes.BusinessLogic.Services.PasswordHashService..ctor(IFeatureToggleRepository featureToggleRepo) in C:\BuildAgent\work\dac5058dfd42cc39\musicnotes_mn1\Musicnotes.BusinessLogic\Services\PasswordHashService.cs:15
   lambda_method(Closure , Object[] ) +104
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +253

[DependencyResolutionException: An exception was thrown while invoking the constructor 'Void .ctor(Musicnotes.BusinessLogic.IFeatureToggleRepository)' on type 'PasswordHashService'. ---> The underlying provider failed on Open. (See inner exception for details.)]
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +717
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Resolving.InstanceLookup.Execute() +63
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +122
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Resolving.InstanceLookup.Execute() +63
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +122
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator) +144
   Autofac.Core.Resolving.InstanceLookup.Execute() +183
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +122
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator) +144
   Autofac.Core.Resolving.InstanceLookup.Execute() +183
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +122
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Resolving.InstanceLookup.Execute() +63
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Resolving.ResolveOperation.Execute(IComponentRegistration registration, IEnumerable`1 parameters) +108
   Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance) +122
   Autofac.ResolutionExtensions.ResolveOptionalService(IComponentContext context, Service service, IEnumerable`1 parameters) +70
   Autofac.Integration.Mvc.AutofacDependencyResolver.GetService(Type serviceType) +75
   System.Web.Mvc.DefaultControllerActivator.Create(RequestContext requestContext, Type controllerType) +61

[InvalidOperationException: An error occurred when trying to create a controller of type 'Musicnotes.Controllers.ErrorController'. Make sure that the controller has a parameterless public constructor.]
   System.Web.Mvc.DefaultControllerActivator.Create(RequestContext requestContext, Type controllerType) +242
   System.Web.Mvc.DefaultControllerFactory.GetControllerInstance(RequestContext requestContext, Type controllerType) +1583
   System.Web.Mvc.DefaultControllerFactory.CreateController(RequestContext requestContext, String controllerName) +103
   System.Web.Mvc.MvcHandler.ProcessRequestInit(HttpContextBase httpContext, IController& controller, IControllerFactory& factory) +263
   System.Web.Mvc.MvcHandler.BeginProcessRequest(HttpContextBase httpContext, AsyncCallback callback, Object state) +85
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8273
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +224
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +1366


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.4108.0
back to Table of Artists

A Worship House Sheet Music

Title Index


View sorted by Style  or Instruments and Voices

Musicnotes Digital Sheet Music The Voice of Hope (As High as the Heavens)
for Voice and Piano
Musicnotes Digital Sheet Music We Crown You Now
for Voice and Piano



Last updated: Tuesday, January 31, 2023
Unable to access availability database 'Musicnotes' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.

Server Error in '/' Application.

Unable to access availability database 'Musicnotes' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Unable to access availability database 'Musicnotes' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Unable to access availability database 'Musicnotes' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.]
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1336
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +164
   System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +383
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +307
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +201
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +422
   System.Data.SqlClient.SqlConnection.Open() +1343
   System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch(TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) +104
   System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext) +473
   System.Data.Entity.SqlServer.<>c__DisplayClass1.<Execute>b__0() +19
   System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +234
   System.Data.Entity.Core.EntityClient.EntityConnection.Open() +318

[EntityException: The underlying provider failed on Open.]
   System.Data.Entity.Core.EntityClient.EntityConnection.Open() +738
   System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions) +167
   System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) +63
   System.Data.Entity.Core.Objects.<>c__DisplayClass7.<GetResults>b__5() +203
   System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +234
   System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +354
   System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() +31
   System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() +39
   System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +261
   Musicnotes.Application.Services.FeatureToggleSplitTestService.IsFeatureEnabledForHostname(String featureName, String hostname) in C:\BuildAgent\work\dac5058dfd42cc39\musicnotes_mn1\Musicnotes.Application\Services\FeatureToggleSplitTestService.cs:28
   Castle.Proxies.Invocations.IFeatureToggleRepository_IsFeatureEnabledForHostname.InvokeMethodOnTarget() +158
   Castle.DynamicProxy.AbstractInvocation.Proceed() +110
   Musicnotes.Application.ExceptionLogger.Intercept(IInvocation invocation) in C:\BuildAgent\work\dac5058dfd42cc39\musicnotes_mn1\Musicnotes.Application\ExceptionLogger.cs:56
   Castle.DynamicProxy.AbstractInvocation.Proceed() +447
   Castle.Proxies.IFeatureToggleRepositoryProxy.IsFeatureEnabledForHostname(String featureName, String hostname) +149
   Musicnotes.BusinessLogic.Services.PasswordHashService..ctor(IFeatureToggleRepository featureToggleRepo) in C:\BuildAgent\work\dac5058dfd42cc39\musicnotes_mn1\Musicnotes.BusinessLogic\Services\PasswordHashService.cs:15
   lambda_method(Closure , Object[] ) +104
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +253

[DependencyResolutionException: An exception was thrown while invoking the constructor 'Void .ctor(Musicnotes.BusinessLogic.IFeatureToggleRepository)' on type 'PasswordHashService'. ---> The underlying provider failed on Open. (See inner exception for details.)]
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +717
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Resolving.InstanceLookup.Execute() +63
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +122
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Resolving.InstanceLookup.Execute() +63
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +122
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator) +144
   Autofac.Core.Resolving.InstanceLookup.Execute() +183
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +122
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator) +144
   Autofac.Core.Resolving.InstanceLookup.Execute() +183
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate() +122
   Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) +272
   Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters) +86
   Autofac.Core.Resolving.InstanceLookup.Execute() +63
   Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters) +171
   Autofac.Core.Resolving.ResolveOperation.Execute(IComponentRegistration registration, IEnumerable`1 parameters) +108
   Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance) +122
   Autofac.ResolutionExtensions.ResolveOptionalService(IComponentContext context, Service service, IEnumerable`1 parameters) +70
   Autofac.Integration.Mvc.AutofacDependencyResolver.GetService(Type serviceType) +75
   System.Web.Mvc.DefaultControllerActivator.Create(RequestContext requestContext, Type controllerType) +61

[InvalidOperationException: An error occurred when trying to create a controller of type 'Musicnotes.Controllers.ErrorController'. Make sure that the controller has a parameterless public constructor.]
   System.Web.Mvc.DefaultControllerActivator.Create(RequestContext requestContext, Type controllerType) +242
   System.Web.Mvc.DefaultControllerFactory.GetControllerInstance(RequestContext requestContext, Type controllerType) +1583
   System.Web.Mvc.DefaultControllerFactory.CreateController(RequestContext requestContext, String controllerName) +103
   System.Web.Mvc.MvcHandler.ProcessRequestInit(HttpContextBase httpContext, IController& controller, IControllerFactory& factory) +263
   System.Web.Mvc.MvcHandler.BeginProcessRequest(HttpContextBase httpContext, AsyncCallback callback, Object state) +85
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8273
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +224
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +1366


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.4108.0