How to change the default connection to a server in Visual studio 2012 SQL Project?

sql-server visual-studio-2012 localdb
suresh2 picture suresh2 · Jan 23, 2013 · Viewed 26.9k times · Source

In visual studio 2012 sqlproj, the default connection button always connect to the (localdb)\Projects by default. How do I change that? Every time I need to disconnect and connect again to change the server.

Answer

Yang picture Yang · Jul 5, 2013

Check the properties of your database project. Under Debug tab, there's option "Target Connection String". Change that to the server and database you want to use.

Related questions

EF5: Cannot attach the file ‘{0}' as database '{1}'

I'm encountering the exact issue as described here (read section "Cannot Attach to Deleted MDF File"), but the solution to the problem is not told there... In short the issue is that after deleting the .mdf file, the following exception …

Read More
I can't get a Sql Server localdb connection to work on a computer that does not have SqlServer Express installed

I have a C# console application written using Visual Studio 2012. In the application I am using a Sql Server localdb connection to a database to store information. This is working fine on several computers, all of which have Visual Studio …

Read More
How do I connect to an older sql database using LocalDb in VS 2012?

I am trying to construct a connection string to a 2008 SQL Express database file in VS 2012. I am getting an error dialog: This database file is not compatible with the current instance of SQL Server. To resolve this issue, you …

Read More