WEbapplication unable to connect to SQL  2008r2 DB

Posted on 2012-09-09
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 82

    Accepted Solution

    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:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now