How to: Modify Database Connections

You can change the properties of your connection, such as login options and data source, in the Modify Connection dialog box.


In Visual Studio 2013, you can connect to a SQL Server database from either SQL Server Object Explorer or the Data Connections node in Server Explorer. SQL Server Object Explorer provides a view that is like SQL Server Management Studio. To open this explorer from the menu bar, choose View, SQL Server Object Explorer. For more information, see Connected Database Development.


Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

To modify database connections

  1. In Server Explorer, right-click a data connection and choose Modify Connection on the shortcut menu.

  2. In the Modify Connection dialog box change options for logging in or connecting to a data source or click the Advanced button for datasource-specific options.

  3. Click OK to update the connection properties.

Community Additions