If using Windows Authentication to connect to SQL Server the user account must be added to SQL Server and have the proper permissions.

Switch the SQL Server instance from Windows Only mode to Mixed Mode

OR

  1. Add the new user as a user on the FAWeb server.
  2. Assign File and Directory Permissions (NTFS) for the user. For a list of NTFS permissions, see What NTFS permissions are required for Faculty Access for the Web 7?
  3. Add the user account to SQL Server as required for Windows Only Authentication.
  4. Add the user to the web.config file.
  5. Restart IIS on the web server.