Last post Nov 05, 2013 12:52 AM by Finlay
Nov 03, 2013 09:53 PM|Finlay|LINK
I have just installed SQL Server 2012 Express (instance ID SQLEXPRESS) +
Visual Studio Express 2012 for Web (VS2012):
1. in SQL Server 2012 Management Studio, it is OK to connect to this database engine by server name
.\SQLEXPRESS or instance (localdb)\v11.0
2. although VS2012 can connect to server name
.\SQLEXPRESS, it cannot locate instance (localdb)\v11.0
3. but VS2012 can connect to its instance pipe name instead, such as np:\\.\pipe\LOCALDB#CEEBB35C\tsql\query
Does anyone know how to make VS2012 connect to instance (localdb)\v11.0?
Nov 05, 2013 12:52 AM|Finlay|LINK
Answer found: If your application uses a version of .NET before 4.0.2 you must connect directly to the named pipe of the LocalDB.