Selecting the type of security validation used when logging on to SQL Server

From a Microsoft Access project (.adp) file, you can administer basic security tasks by using the Database Security command to add, edit, or delete server logins, database users, and database roles.

Note   You must have SQL Server installed on the same computer as the Access project for these commands to work.

SQL Server provides two security methods for validating logins to the SQL Server database:

• SQL Server security, which uses SQL Server user names and passwords.
• Windows NT integrated security, which uses Windows NT account user names. In this case, Windows NT authenticates a user when they log on, and SQL Server accepts Windows NT authentication.

To select the type of security validation used, do one of the following:

Use SQL Server security

1. Select the Use a specific username and password checkbox on the Connection tab of the Data Link Properties dialog box.

2. Do one of the following:

   • Clear the Allow saving of password check box to require users to log on to the SQL Server database each time they open the Access project.

   • Select the Allow saving of password check box if you want to create an application that doesn't require a user to repeatedly log in to the SQL Server database.

Use Windows NT authentication to connect an SQL Server database

Select the Use Windows NT Integrated Security checkbox on the Connection tab of the Data Link Properties dialog box.

You don't need to provide a password because SQL Server uses your network login identity.