Create an ADO.NET Connection to BookDemo

Provides step-by-step instructions for using the ADO.NET Connection Editor to create a connection to the BookDemo SQL Server database.
  1. Start the ADO.NET Connection Editor. If you need instructions, see To start the ADO.NET Connection Editor as a user.
  2. On the main screen of the ADO.NET Connection Editor, click Add.

    This starts the ADO.NET Connection Editor wizard.

  3. On the Add an ADO.NET Connection page, click Next.
  4. In the Data Source Name field, type SQLDemo; then click Next.
  5. On the .NET Data Providers page, select SqlClient Data Provider; then click Next.
  6. In the Data Source field, type . (dot) to specify your local SQL Server instance.
  7. In the Initial Catalog field, type BookDemo, which is the name of your SQL Server database.
  8. Do one of the following to set authentication for your SQL Server instance:
    • If you want to connect using Windows authentication (recommended), change the value for the Integrated Security key to True.
    • If you want to connect by providing SQL Server-specific login credentials, type your SQL Server user ID and password into the Value fields for the User ID and Password keys respectively.
  9. Click Next, and then Finish.
  10. After the new connection appears on the main window of the ADO.NET Connection Editor, click Test to verify that the connection works.
  11. Close the ADO.NET Connection Editor.