Connecting to SQL Server Using Windows Authentication

The SQL adapter enables adapter clients to use Windows Authentication to establish a connection with SQL Server. To use Windows Authentication adapter clients must specify an empty user name and password. For more information about connecting to SQL Server using Windows Authentication, see Connecting to SQL Server in Visual Studio.

To enable adapter clients to use Windows Authentication to connect to SQL Server, you must perform the following tasks on the computer running SQL Server.

The steps provided here are for SQL Server 2008 and SQL Server 2005. These steps may vary for SQL Server 2000. Refer to SQL Server documentation for more information.

To enable Windows Authentication on SQL Server
  1. Start SQL Server Management Studio and in the Connect to Server dialog box, specify a SQL Server name and administrator credentials to connect to the server.

  2. In Object Explorer, expand the SQL Server.

  3. Expand Security, right-click Logins, and then click New Login.

  4. In the Login – New window, for the Login name text box, specify the Windows user name in the format domain\username.

  5. In the left pane, click User Mapping. In the right pane, select a database to associate with the user. In the Database role membership for box, select the db_owner check box.

  6. Click OK.

After you have added the user to SQL Server, the user can connect to SQL Server using the SQL adapter, logging in with a blank username and password.