The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

To test the connectivity, click on Connect Now. It will open a Command Prompt window showing the version information. ... Finally, let us connect to the SQL Server. To do this, ...