


In order to get the default connection string that is created with the project to work, you would need to install SQL Server LocalDB on the remote server. What configuration am I missing to get this simple ASP. It didn't work neither.ĭata Source=.\MSSQLSERVER AttachDbFilename=|DataDirectory|\aspnet-WebApplication1-20180923034052.mdf Initial Catalog=aspnet-WebApplication1-20180923034052 Integrated Security=True" providerName=" Since I configure the SQL server as default on the remote server, I figure that I should match up the name of SQL server database engine, which is MSSQLSERVER by default as shown below. So I figure the problem might be coming from the connection string:ĭata Source=(LocalDb)\MSSQLLocalDB AttachDbFilename=|DataDirectory|\aspnet-WebApplication1-20180923034052.mdf Initial Catalog=aspnet-WebApplication1-20180923034052 Integrated Security=True" providerName=" I attempt to fix the problem by installing SQL Server 2012 Express on the remote server, but the problem is still there. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled. SQL Network Interfaces error 52 - Unable to locate a Local Database Runtime installation. I have been getting the following error as a result: When I publish it to a folder on a remote server, I can't seem to figure out how to configure IIS 10 to read from that local SQL database file saved to its App_Data subdirectory. So far, I am able to get it to work on my computer. NET Web Application using MVC template with authentication via a local SQL database file. I have been trying to deploy original ASP.
