Try each of the following steps in order until the issue is resolved:

  1. Restart IIS
  2. If using Windows only authentication in SQL Server, configure web.config for Integrated Windows Authentication
  3. Disable or create an exception for the SQL port on any firewalls controlling access to the SQL server