I am getting a "Login failed for user " error when try to search on my SharePoint site. The site is loading fine, but its the search page thats throwing the error.
Event viewer info
Process information: Process ID: 3644 Process name: w3wp.exe Account name: "Application Pool Identity Account"
Exception information: Exception type: SqlException Exception message: Login failed for user "Application Pool Identity Account"