Localdb usage through SQL Server Configuration Manager alias

In our solutions we often use aliases in our connection strings as not everybody has the same database server installed. Most of the developers have sqlexpress and just some (including me) have a real SQL Server running the whole time.
Right now I had to make our alias working with (localdb)\v11.0
It turned out not to be so easy, so I decided to share it. First I needed to find out how to get the named pipe alias which I’ve found here.
I’ve just started the developer command prompt as follows:
gettingnamedpipe
Then I’ve created the alias as shown on the figure below: namedpipealias

Advertisements

About Tamas Nemeth

Husband and proud father of two daughters in Nürnberg. I'm working as a Senior Software Developer and an enthusiastic Clean-Coder. I spend most of my free time with my family (playing, hiking, etc...). I also play table-tennis and badminton sometimes...
This entry was posted in Technical Interest and tagged , , , , . Bookmark the permalink.

2 Responses to Localdb usage through SQL Server Configuration Manager alias

  1. TJ says:

    It seems that this Instance pipe name gets regenerated every reboot/over time?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s