WEbapplication unable to connect to SQL 2008r2 DB

From an webapplication on a 2003 webserver trying to access a sql server 2008r2 login in failed.

Verifiyed domain account is in the security.  The account is a service using the application pool.  

have reset the app pool and the username password still unable to connect.  

Only upgrading the sql server from server2003r2 to Server 2008r2 and also upgraded from sql 2008 to sql 2008r2

Webserver nothing changed and the user account we are  using can connect to the db using Management studio.
Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
If the web server is on a different machine from the SQL Servers, you may need to upgrade the SQL Native Client on the web server.  Every new version of SQL Server seems to need a new version of the SQL Native Client.  Look for the current version in the middle of this page: http://www.microsoft.com/en-us/download/details.aspx?id=29065
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.