Tech Junkie Blog: Add a Data Connection To A SQL Server Database In Visual Studio 2013

Monday, July 14, 2014

Add a Data Connection To A SQL Server Database In Visual Studio 2013

The "Server Explorer" tool in Visual Studio 2013 is a good tool at your disposal if want to interact with the database in GUI environment.  To create a new data connection to the database in the "Server Explorer" perform the following actions:

  1. Click on "Server Explorer" tab in the left hand side, then click on "Add Connection"

2.  In the "Data source" list box, select "Microsoft SQL Server", for data provider select ".NET Framework Data Provider for SQL Server", then click "Continue"


3. In the "Server name" field type in the hostname\database instance  of the database you want to connect to.  Under "Connect to a database", there is a text box or a drop down list.  You can type in the name of the database if you know it.  Or let Visual Studio pick up the database for you so that you can select it from a list of available databases in the SQL Server instance you've selected.  If you select "Use SQL Server Authentication" you have to specify the credentials to contact to the database.


4. After clicking "OK" the database will show up in the "Server Explorer" window


No comments:

Post a Comment