For an SqlClient data provider, you would need to provide the following connection information:
- Data Source - The name of the SQL Server you want to use. If the server is local, you can usually specify localhost.
- Initial Catalog - The name of the database you want to access.
- Integrated Security - Set this to True to use Windows security. It is set to False by default. When set to False, you must either provide values for the User ID and Password connection settings, or provide them in your program as part of the EXEC SQL CONNECT statement.
- MultipleActiveResultSets - When using a SQL Server 2005 or later, set this to True to allow multiple active result sets.