Description

We recently purchased Site Remote server. I installed it per the provided instructions on a Win 2012 R2 Server, and it appeared to be running OK initially. Although not completely configured for production, I was able to set up a team and one client.

Recently, however, I have not been able to access Admin through a web browser (IE 11) on the Windows Server (SQL Server 2014 Express and SiteRemote are installed on the same dedicated server). I am logged into the server with the same Windows domain account that I had used previously.

Below is the error message from IE. Any guidance would be greatly appreciated.

Server Error in '/SiteRemote/Administration' Application.
________________________________________
Cannot open database "SiteRemoteBackEndServer" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.
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: Cannot open database "SiteRemoteBackEndServer" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.

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): Cannot open database "SiteRemoteBackEndServer" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.]
Provisio.Configuration.k_Configuration.Read() +343
Provisio.Common.k_ConfigurationManagerComponent.Initialize(IServiceLocator ak_SvLocator, Object ak_Arguments) +886
Provisio.Common.Components.k_ComponentEntry.Initialize(IServiceLocator ak_ServiceLocator) +517
Provisio.Common.Components.k_ComponentLoader.ActivateSet(String as_SetId) +1115

[k_ComponentLoaderException: Exceptions were thrown during activation of set "Shared":
1) System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SiteRemoteBackEndServer" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.
at Provisio.Configuration.k_Configuration.Read()
at Provisio.Common.k_ConfigurationManagerComponent.Initialize(IServiceLocator ak_SvLocator, Object ak_Arguments)
at Provisio.Common.Components.k_ComponentLoader.k_ComponentEntry.Initialize(IServiceLocator ak_ServiceLocator)
at Provisio.Common.Components.k_ComponentLoader.ActivateSet(String as_SetId)
ClientConnectionId:d025b596-853b-44b0-b492-8b51bc57b183
Error Number:4060,State:1,Class:11

]
Provisio.Common.Components.k_ComponentLoader.ActivateSet(String as_SetId) +2186
Provisio.Longinus.Server.Web.Admin.k_WebHost.Init() +312
Provisio.Longinus.Server.Web.Admin.Global.Application_Start(Object sender, EventArgs e) +23

[HttpException (0x80004005): Exceptions were thrown during activation of set "Shared":
1) System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SiteRemoteBackEndServer" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.
at Provisio.Configuration.k_Configuration.Read()
at Provisio.Common.k_ConfigurationManagerComponent.Initialize(IServiceLocator ak_SvLocator, Object ak_Arguments)
at Provisio.Common.Components.k_ComponentLoader.k_ComponentEntry.Initialize(IServiceLocator ak_ServiceLocator)
at Provisio.Common.Components.k_ComponentLoader.ActivateSet(String as_SetId)
ClientConnectionId:d025b596-853b-44b0-b492-8b51bc57b183
Error Number:4060,State:1,Class:11

]
System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +544
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +186
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +172
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +402
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +343

[HttpException (0x80004005): Exceptions were thrown during activation of set "Shared":
1) System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SiteRemoteBackEndServer" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.
at Provisio.Configuration.k_Configuration.Read()
at Provisio.Common.k_ConfigurationManagerComponent.Initialize(IServiceLocator ak_SvLocator, Object ak_Arguments)
at Provisio.Common.Components.k_ComponentLoader.k_ComponentEntry.Initialize(IServiceLocator ak_ServiceLocator)
at Provisio.Common.Components.k_ComponentLoader.ActivateSet(String as_SetId)
ClientConnectionId:d025b596-853b-44b0-b492-8b51bc57b183
Error Number:4060,State:1,Class:11

]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +579
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +112
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +716