Cannot connect to localdb on hosting server
Posted on 2015-01-31
This is a tough one.
I created a web site using Visual Studio 2013.
There are two databases in the App_Data folder.
One is to handle memberships, the other is used by a 3rd-party scheduler app.
The web site was FTP'ed to a server.
Neither database can be connected to.
Here are the connection strings for the web.config file:
<add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-WillowLane1-f59c4ece-32dd-40f4-9451-1620648a0486;AttachDbFilename=|DataDirectory|\aspnet-WillowLane1-f59c4ece-32dd-40f4-9451-1620648a0486.mdf;Integrated Security=True"
<add name="DatabaseConnectionString" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True"
I have played around with the connectionstring trying different things according to other threats I have found on the web, but always end up with an error like this:
Server Error in '/' Application.
The system cannot find the file specified
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.ComponentModel.Win32Exception: The system cannot find the file specified
Line 22: ' Validate the user password
Line 23: Dim manager = New UserManager()
Line 24: Dim user As ApplicationUser = manager.Find(UserName.Text, Password.Text)
Line 25: If user IsNot Nothing Then
Line 26: IdentityHelper.SignIn(manager, user, RememberMe.Checked)
Source File: C:\Inetpub\vhosts\willowlanecare.com\site1\Account\Login.aspx.vb Line: 24
[Win32Exception (0x80004005): The system cannot find the file specified]
Need some guidance here.