Once we have SQL server downloaded and installed, let's take a look at it inside Visual Studio. Go to View and then select SQL Server Object Explorer; it opens a little pane on the left-hand side, as shown in Figure 16.1.4:
Figure 16.1.4: The SQL Server Object Explorer pane in Visual Studio
Next, click on the Add SQL Server Button, as shown in Figure 16.1.5:
Figure 16.1.5: The Add SQL Server Button
Now, the dialog box shown in Figure 16.1.6 appears. Notice where it says Windows Authentication. This is known as integrated security. You don't have to specify a different username and password. Just fill the Server Name field, click on Connect, and you'll be logged in to it:
Figure 16.1.6: The Connect dialog box
The specific version that you have will be different than the one shown in Figure 16.1.7, but these are the...
