WEbapplication unable to connect to SQL  2008r2 DB

Posted on 2012-09-09
Medium Priority
Last Modified: 2012-09-27
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.
Question by:GSLElectric
1 Comment
LVL 84

Accepted Solution

Dave Baldwin earned 2000 total points
ID: 38381624
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

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question