Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • MB 273 posts 936 karma points
    Jul 17, 2022 @ 19:56
    MB
    0

    Publish Umbraco 9 with MDF database

    Cheers,

    My Umbraco 9 is a small site using local database (umbraco.mdf located in Umbraco/Data/Umbraco.mdf).

    I'm hosted with Simply.com

    I've done:

    • Visual studio: Publish via FTP Server
    • Configuration: Release
    • Target framework: net6.0
    • Deplument mode: Self-contained
    • Target runtime: win-x86

    When I publish my website and navigate to the URL I'm prompted with Umbraco installation. When proceeding and installing Umbraco I get the error you see in the bottom of this post.

    My connection string under appsettings.json looks like this:

      "ConnectionStrings": {
    "umbracoDbDSN": "Data Source=(localdb)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Umbraco.mdf;Integrated Security=True"
    

    },

    Why can't Umbraco find the database?

    The error I get.

        {"@t":"2022-07-17T19:52:17.9866500Z","@mt":"Using an in-memory repository. Keys will not be persisted to storage.","@l":"Warning","EventId":{"Id":50,"Name":"UsingInMemoryRepository"},"SourceContext":"Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN "}
    {"@t":"2022-07-17T19:52:18.0272238Z","@mt":"Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits.","@l":"Warning","EventId":{"Id":59,"Name":"UsingEphemeralKeyRepository"},"SourceContext":"Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN "}
    {"@t":"2022-07-17T19:52:18.1079386Z","@mt":"Acquiring MainDom.","SourceContext":"Umbraco.Cms.Core.Runtime.MainDom","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO "}
    {"@t":"2022-07-17T19:52:18.1093392Z","@mt":"Acquired MainDom.","SourceContext":"Umbraco.Cms.Core.Runtime.MainDom","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO "}
    {"@t":"2022-07-17T19:52:32.8097647Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)\r\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN "}
    {"@t":"2022-07-17T19:52:33.8187578Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN "}
    {"@t":"2022-07-17T19:52:34.8268845Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN "}
    {"@t":"2022-07-17T19:52:35.8276980Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN "}
    {"@t":"2022-07-17T19:52:36.8398738Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN "}
    {"@t":"2022-07-17T19:52:36.8452744Z","@mt":"Profiler is VoidProfiler, not profiling (must run debug mode to profile).","SourceContext":"Umbraco.Cms.Web.Common.Profiler.InitializeWebProfiling","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO "}
    {"@t":"2022-07-17T19:52:36.8572219Z","@mt":"No XML encryptor configured. Key {KeyId:B} may be persisted to storage in unencrypted form.","@r":["{a4db398e-996a-460a-a233-b26dc0b60235}"],"@l":"Warning","KeyId":"a4db398e-996a-460a-a233-b26dc0b60235","EventId":{"Id":35,"Name":"NoXMLEncryptorConfiguredKeyMayBePersistedToStorageInUnencryptedForm"},"SourceContext":"Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN "}
    {"@t":"2022-07-17T19:52:37.1797582Z","@mt":"Application started. Press Ctrl+C to shut down.","SourceContext":"Microsoft.Hosting.Lifetime","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO "}
    {"@t":"2022-07-17T19:52:37.1798350Z","@mt":"Hosting environment: {envName}","envName":"Production","SourceContext":"Microsoft.Hosting.Lifetime","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO "}
    {"@t":"2022-07-17T19:52:37.1798512Z","@mt":"Content root path: {contentRoot}","contentRoot":"d:\\web\\localuser\\emiliehoej14-15.dk\\public_html","SourceContext":"Microsoft.Hosting.Lifetime","ProcessId":30520,"ProcessName":"w3wp","ThreadId":1,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO "}
    {"@t":"2022-07-17T19:52:37.3425818Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ActionId":"8365d84c-eaea-4db8-b10f-078368775aa2","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallController.Redirect (Umbraco.Web.BackOffice)","RequestId":"80000b57-0006-7b00-b63f-84710c7967bb","RequestPath":"/","ProcessId":30520,"ProcessName":"w3wp","ThreadId":11,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN ","HttpRequestId":"5e936614-4385-4da3-a513-759a1b4bdfa3","HttpRequestNumber":1,"HttpSessionId":"f8911bf7-c261-c8f6-1134-89236f233301"}
    {"@t":"2022-07-17T19:52:37.3453679Z","@mt":"Umbraco must install or upgrade.","@l":"Warning","SourceContext":"Umbraco.Cms.Web.BackOffice.Install.InstallController","ActionId":"8365d84c-eaea-4db8-b10f-078368775aa2","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallController.Redirect (Umbraco.Web.BackOffice)","RequestId":"80000b57-0006-7b00-b63f-84710c7967bb","RequestPath":"/","ProcessId":30520,"ProcessName":"w3wp","ThreadId":11,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN ","HttpRequestId":"5e936614-4385-4da3-a513-759a1b4bdfa3","HttpRequestNumber":1,"HttpSessionId":"f8911bf7-c261-c8f6-1134-89236f233301"}
    {"@t":"2022-07-17T19:52:37.4187873Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ActionId":"4f6130f6-6926-4c87-b5db-2e0819570ed6","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallController.Index (Umbraco.Web.BackOffice)","RequestId":"80000b58-0006-7b00-b63f-84710c7967bb","RequestPath":"/install","ProcessId":30520,"ProcessName":"w3wp","ThreadId":11,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN ","HttpRequestId":"a5c94e55-5b19-4bd5-873a-7f0f79b9811f","HttpRequestNumber":2,"HttpSessionId":"6fa63d82-f0c2-97ba-e87d-8d00f1e86f3c"}
    {"@t":"2022-07-17T19:52:37.4189586Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ActionId":"4f6130f6-6926-4c87-b5db-2e0819570ed6","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallController.Index (Umbraco.Web.BackOffice)","RequestId":"80000b58-0006-7b00-b63f-84710c7967bb","RequestPath":"/install","ProcessId":30520,"ProcessName":"w3wp","ThreadId":11,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN ","HttpRequestId":"a5c94e55-5b19-4bd5-873a-7f0f79b9811f","HttpRequestNumber":2,"HttpSessionId":"6fa63d82-f0c2-97ba-e87d-8d00f1e86f3c"}
    {"@t":"2022-07-17T19:52:57.2102477Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)\r\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ActionId":"1fbf10f7-1956-4220-81ec-a2aece3e57cb","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.GetSetup (Umbraco.Web.BackOffice)","RequestId":"800035bc-0000-de00-b63f-84710c7967bb","RequestPath":"/install/api/GetSetup","ProcessId":30520,"ProcessName":"w3wp","ThreadId":14,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN ","HttpRequestId":"774dfda6-5735-4ad4-95f8-b80b813e95bd","HttpRequestNumber":3,"HttpSessionId":"dbfb2e6a-9c8b-84bf-674d-04e3dff28fff"}
    {"@t":"2022-07-17T19:52:57.2134928Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ActionId":"1fbf10f7-1956-4220-81ec-a2aece3e57cb","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.GetSetup (Umbraco.Web.BackOffice)","RequestId":"800035bc-0000-de00-b63f-84710c7967bb","RequestPath":"/install/api/GetSetup","ProcessId":30520,"ProcessName":"w3wp","ThreadId":14,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN ","HttpRequestId":"774dfda6-5735-4ad4-95f8-b80b813e95bd","HttpRequestNumber":3,"HttpSessionId":"dbfb2e6a-9c8b-84bf-674d-04e3dff28fff"}
    {"@t":"2022-07-17T19:53:51.4433461Z","@mt":"Failed to detected SqlServer version.","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)\r\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Cms.Infrastructure.Persistence.SqlSyntax.SqlServerSyntaxProvider.GetSetVersion(String connectionString, String providerName, ILogger logger)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"Umbraco.Cms.Infrastructure.Persistence.UmbracoDatabaseFactory","ProcessId":30520,"ProcessName":"w3wp","ThreadId":11,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"ERROR"}
    {"@t":"2022-07-17T19:53:51.4751681Z","@mt":"Unhandled exception in recurring hosted service.","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at NPoco.Database.OpenSharedConnectionImp(Boolean isInternal)\r\n   at NPoco.Database.OpenSharedConnectionInternal()\r\n   at NPoco.Database.BeginTransaction(IsolationLevel isolationLevel)\r\n   at Umbraco.Cms.Core.Scoping.Scope.get_Database()\r\n   at Umbraco.Cms.Infrastructure.Persistence.Repositories.Implement.RepositoryBase.get_Database()\r\n   at Umbraco.Cms.Infrastructure.Persistence.Repositories.Implement.KeyValueRepository.PerformGet(String id)\r\n   at Umbraco.Cms.Core.Cache.NoCacheRepositoryCachePolicy`2.Get(TId id, Func`2 performGet, Func`2 performGetAll)\r\n   at Umbraco.Cms.Infrastructure.Persistence.Repositories.Implement.EntityRepositoryBase`2.Get(TId id)\r\n   at Umbraco.Cms.Core.Services.Implement.KeyValueService.GetValue(String key)\r\n   at Umbraco.Cms.Core.Services.MetricsConsentService.GetConsentLevel()\r\n   at Umbraco.Cms.Core.Telemetry.TelemetryService.GetVersion()\r\n   at Umbraco.Cms.Core.Telemetry.TelemetryService.TryGetTelemetryReportData(TelemetryReportData& telemetryReportData)\r\n   at Umbraco.Cms.Infrastructure.HostedServices.ReportSiteTask.PerformExecuteAsync(Object state)\r\n   at Umbraco.Cms.Infrastructure.HostedServices.RecurringHostedServiceBase.ExecuteAsync(Object state)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"Umbraco.Cms.Infrastructure.HostedServices.ReportSiteTask","ProcessId":30520,"ProcessName":"w3wp","ThreadId":11,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"ERROR"}
    {"@t":"2022-07-17T19:53:52.9313723Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Executing installation step: 'Permissions'.","TimingId":"06170b9","SourceContext":"Umbraco.Cms.Core.Logging.ProfilingLogger","ActionId":"2a470981-c678-4a95-9a15-f6c20f9c99d8","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall (Umbraco.Web.BackOffice)","RequestId":"8000b820-0006-a300-b63f-84710c7967bb","RequestPath":"/install/api/PostPerformInstall","ProcessId":30520,"ProcessName":"w3wp","ThreadId":20,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO ","HttpRequestId":"557bc810-7c6c-4fa5-b5d7-6b90a8ae2c1f","HttpRequestNumber":4,"HttpSessionId":"70420fd6-3426-43cc-3878-4716e86e0b00"}
    {"@t":"2022-07-17T19:53:52.9751880Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Step completed","Duration":43,"TimingId":"06170b9","SourceContext":"Umbraco.Cms.Core.Logging.ProfilingLogger","ActionId":"2a470981-c678-4a95-9a15-f6c20f9c99d8","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall (Umbraco.Web.BackOffice)","RequestId":"8000b820-0006-a300-b63f-84710c7967bb","RequestPath":"/install/api/PostPerformInstall","ProcessId":30520,"ProcessName":"w3wp","ThreadId":20,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO ","HttpRequestId":"557bc810-7c6c-4fa5-b5d7-6b90a8ae2c1f","HttpRequestNumber":4,"HttpSessionId":"70420fd6-3426-43cc-3878-4716e86e0b00"}
    {"@t":"2022-07-17T19:53:53.0390633Z","@mt":"An error occurred, reconfiguring...","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at NPoco.Database.OpenSharedConnectionImp(Boolean isInternal)\r\n   at NPoco.Database.OpenSharedConnectionInternal()\r\n   at NPoco.Database.BeginTransaction(IsolationLevel isolationLevel)\r\n   at Umbraco.Cms.Core.Scoping.Scope.get_Database()\r\n   at Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder.ValidateSchema(IScope scope)\r\n   at Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder.ValidateSchema()\r\n   at Umbraco.Cms.Infrastructure.Install.InstallSteps.DatabaseConfigureStep.ShouldDisplayView()\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"Umbraco.Cms.Infrastructure.Install.InstallSteps.DatabaseConfigureStep","ActionId":"2a470981-c678-4a95-9a15-f6c20f9c99d8","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall (Umbraco.Web.BackOffice)","RequestId":"8000b821-0006-a300-b63f-84710c7967bb","RequestPath":"/install/api/PostPerformInstall","ProcessId":30520,"ProcessName":"w3wp","ThreadId":20,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"ERROR","HttpRequestId":"6ea1481d-3719-4142-8a59-81e70231b73a","HttpRequestNumber":5,"HttpSessionId":"4759e0d6-9630-fe88-18ac-6cfa39167d98"}
    {"@t":"2022-07-17T19:53:53.0391495Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Executing installation step: 'DatabaseConfigure'.","TimingId":"1990e46","SourceContext":"Umbraco.Cms.Core.Logging.ProfilingLogger","ActionId":"2a470981-c678-4a95-9a15-f6c20f9c99d8","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall (Umbraco.Web.BackOffice)","RequestId":"8000b821-0006-a300-b63f-84710c7967bb","RequestPath":"/install/api/PostPerformInstall","ProcessId":30520,"ProcessName":"w3wp","ThreadId":20,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO ","HttpRequestId":"6ea1481d-3719-4142-8a59-81e70231b73a","HttpRequestNumber":5,"HttpSessionId":"4759e0d6-9630-fe88-18ac-6cfa39167d98"}
    {"@t":"2022-07-17T19:54:09.9922487Z","@mt":"Configured database is reporting as not being available.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)\r\n ---> System.ComponentModel.Win32Exception (2): The system cannot find the file specified.\r\n   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)\r\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Umbraco.Extensions.DbConnectionExtensions.IsAvailable(IDbConnection connection)\r\nClientConnectionId:00000000-0000-0000-0000-000000000000\r\nError Number:2,State:0,Class:20","SourceContext":"object","ActionId":"2a470981-c678-4a95-9a15-f6c20f9c99d8","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall (Umbraco.Web.BackOffice)","RequestId":"8000b821-0006-a300-b63f-84710c7967bb","RequestPath":"/install/api/PostPerformInstall","ProcessId":30520,"ProcessName":"w3wp","ThreadId":20,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"WARN ","HttpRequestId":"6ea1481d-3719-4142-8a59-81e70231b73a","HttpRequestNumber":5,"HttpSessionId":"4759e0d6-9630-fe88-18ac-6cfa39167d98"}
    {"@t":"2022-07-17T19:54:09.9931965Z","@mt":"Installation step {Step} failed.","@l":"Error","@x":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.\r\n ---> Umbraco.Cms.Core.Install.InstallException: Could not connect to the database\r\n   at Umbraco.Cms.Infrastructure.Install.InstallSteps.DatabaseConfigureStep.ExecuteAsync(DatabaseModel database)\r\n   --- End of inner exception stack trace ---\r\n   at System.RuntimeMethodHandle.InvokeMethod(Object target, Span`1& arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)\r\n   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)\r\n   at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.ExecuteStepAsync(InstallSetupStep step, Object instruction)\r\n   at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall(InstallInstructions installModel)","Step":"DatabaseConfigure","SourceContext":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController","ActionId":"2a470981-c678-4a95-9a15-f6c20f9c99d8","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall (Umbraco.Web.BackOffice)","RequestId":"8000b821-0006-a300-b63f-84710c7967bb","RequestPath":"/install/api/PostPerformInstall","ProcessId":30520,"ProcessName":"w3wp","ThreadId":20,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"ERROR","HttpRequestId":"6ea1481d-3719-4142-8a59-81e70231b73a","HttpRequestNumber":5,"HttpSessionId":"4759e0d6-9630-fe88-18ac-6cfa39167d98"}
    {"@t":"2022-07-17T19:54:09.9932658Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Step completed","Duration":16952,"TimingId":"1990e46","SourceContext":"Umbraco.Cms.Core.Logging.ProfilingLogger","ActionId":"2a470981-c678-4a95-9a15-f6c20f9c99d8","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall (Umbraco.Web.BackOffice)","RequestId":"8000b821-0006-a300-b63f-84710c7967bb","RequestPath":"/install/api/PostPerformInstall","ProcessId":30520,"ProcessName":"w3wp","ThreadId":20,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"INFO ","HttpRequestId":"6ea1481d-3719-4142-8a59-81e70231b73a","HttpRequestNumber":5,"HttpSessionId":"4759e0d6-9630-fe88-18ac-6cfa39167d98"}
    {"@t":"2022-07-17T19:54:09.9933260Z","@mt":"An error occurred during installation step {Step}","@l":"Error","@x":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.\r\n ---> Umbraco.Cms.Core.Install.InstallException: Could not connect to the database\r\n   at Umbraco.Cms.Infrastructure.Install.InstallSteps.DatabaseConfigureStep.ExecuteAsync(DatabaseModel database)\r\n   --- End of inner exception stack trace ---\r\n   at System.RuntimeMethodHandle.InvokeMethod(Object target, Span`1& arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)\r\n   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)\r\n   at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.ExecuteStepAsync(InstallSetupStep step, Object instruction)\r\n   at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall(InstallInstructions installModel)","Step":"DatabaseConfigure","SourceContext":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController","ActionId":"2a470981-c678-4a95-9a15-f6c20f9c99d8","ActionName":"Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall (Umbraco.Web.BackOffice)","RequestId":"8000b821-0006-a300-b63f-84710c7967bb","RequestPath":"/install/api/PostPerformInstall","ProcessId":30520,"ProcessName":"w3wp","ThreadId":20,"AppDomainId":1,"AppDomainAppId":"8381fef2caeacdeeffece96ce604daf206d6380d","MachineName":"NT19","Log4NetLevel":"ERROR","HttpRequestId":"6ea1481d-3719-4142-8a59-81e70231b73a","HttpRequestNumber":5,"HttpSessionId":"4759e0d6-9630-fe88-18ac-6cfa39167d98"}
    
  • Huw Reddick 1929 posts 6697 karma points MVP 2x c-trib
    Nov 23, 2023 @ 15:26
    Huw Reddick
    0

    Did it publish the database? can you see the mdf file on the server?

  • Søren Kottal 712 posts 4570 karma points MVP 6x c-trib
    Nov 27, 2023 @ 14:36
    Søren Kottal
    0

    I am pretty sure Simply.com doesn't support mdf (LocalDB) databases.

    If you upgrade to 10+, you can use SQLite in stead, if you don't want to use MSSQL. Of course you would need to find a way to get your content and settings from your current mdf database to the new SQLite. uSync is one option...

Please Sign in or register to post replies

Write your reply to:

Draft