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) +943
   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\cf1d7f191a349310\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\cf1d7f191a349310\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\cf1d7f191a349310\musicnotes_mn1\Musicnotes.BusinessLogic\Services\PasswordHashService.cs:17
   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() +3601
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +224
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +1766


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.4136.0
back to Table of SingerPros back to Table of Instruments with Voice

SingerPro: 4 Voices and Piano Sheet Music

Title Index


View sorted by ArtistsKeyword/SubjectStyle  or Form

 #  A  B  C  D  E  F  [G]  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

Titles beginning with the letter G:

Musicnotes Digital Sheet Music Giver of Life
by Brian Doerksen and Steve Mitchinson
Musicnotes Digital Sheet Music Gladys Gutzman, Queen of Snacks
by Zina Goldrich and Marcy Heisler
performed by Junie B. Jones
Musicnotes Digital Sheet Music Glorious
by Brenton Brown and Paul Baloche
Musicnotes Digital Sheet Music Glory
by Jonathan Dunn and Juante M. Hall
performed by Marvin Sapp
Musicnotes Digital Sheet Music Glory To Your Name
by Robin Mark
Musicnotes Digital Sheet Music Go With Me
by Eric Dawkins, Warryn Smiley Campbell and Deitrick Haddon
Musicnotes Digital Sheet Music God Forbid
by Kyle Matthews and Tony Wood
performed by Point of Grace
Musicnotes Digital Sheet Music Good Day Sunshine
by Paul McCartney and John Lennon
performed by The Beatles
Musicnotes Digital Sheet Music Good for You: from Dear Evan Hansen
by Justin Paul and Benj Pasek
performed by Dear Evan Hansen
Musicnotes Digital Sheet Music Gotta Worship
by Derek Allen and Haskel Jackson
Musicnotes Digital Sheet Music The Greatness of You
by Erik Cooper and Nathan LaGrange
performed by Lakeview Worship


[ go to top of page ]

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) +943
   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\cf1d7f191a349310\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\cf1d7f191a349310\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\cf1d7f191a349310\musicnotes_mn1\Musicnotes.BusinessLogic\Services\PasswordHashService.cs:17
   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() +3601
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +224
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +1766


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