Connecting to a SQL LocalDb instance

If you haven’t heard, one of the things that is new in Visual Studio 2012 is a new version of SQL Express for local development. So when you are editing a SQL script and you need to connect to a server, the server name is no longer .SQLEXPRESS. This means that if you’re working in a .sql file and you’re prompted to enter a server name to connect to, you might be stuck.

image

I wasn’t able to quickly find this information out with a web search, so here it is once and for all:

(localdb)\v11.0

Happy developing :)

26. July 2012 by Jim Wang
Categories: SQL, Visual Studio | 1 comment

One Comment

  1. Pingback: Dew Drop – July 27, 2012 (#1,373) | Alvin Ashcraft's Morning Dew

Leave a Reply

Required fields are marked *

*