Failed to add database file to Visual Studio 2013. Error 50
Yes, I know this question has been asked many times, but this problem seems persistent.
I've had this error before, but it was while hosting in IIS. For this reason, I moved from VS2013 to VS2010 . There is no problem in VS2010, but I need VS2013 and now I'm here where I can't even add the DATABASE FILE .
Now, here is the error I get when adding the database:
An error related to the network or a specific instance occurred while establishing a connection to SQL Server. The server was not found or was unavailable. Verify that the instance name is correct and SQL Server is configured for remote connection. (Provider: SQL Network Interfaces, Error: 50 - A local database error occurred. Unable to create an automatic instance. See Windows Application log event for error information.)
Now I understand that there is some error with MS SQL version, I tried everything that is said in this one: http://kbijayanta.azurewebsites.net/tag/localdbv12-0/ .
Here's a look at my control panel and the SQL related programs I have:
What's the final solution for this?
PS: I have not installed any packages / programs / applications related to SQL server. It was all pre-installed with VS 2013 installation!
UPDATE
Here is a screen capture of errors in the event log:
source to share
Steps to connect LocalDB to Visual Studio Server Explorer
1.Open command prompt
2.Run SqlLocalDB.exe start v11.0 3,Run SqlLocalDB.exe info v11.0
4.Copy the Instance pipe name that starts with np:\...
5.In Visual Studio select TOOLS > Connect to Database...
6.For Server Name enter (localdb)\v11.0. If it didn't work, use the Instance pipe name that you copied earlier. You can also use this to connect with SQL Management Studio.
7.Select the database on next dropdown list
8.Click OK!
can you get help from How to Connect to LocalDB in Visual Studio Server Explorer?
source to share