SQL Server 2008 Windows AD ODBC Connection Error ( JasonLaskey:ITLab)

Posted on 2014-08-17
Last Modified: 2014-09-02
Hi Gurus, I have been battling with this error and Im unable to resolve this problem for a client. Any assitance would be appreciated. Scenario is when client tries to establish a n ODBC connection using Windows Auth he gets the error (See attachment), however if he tries to establish the connection using the sa user he is successful. I frist thought this could be a permissions problem so I went and added the "logged in" AD user he tried to establisht the ODBC connection with to the SQL Managment Studio>Roles>sysadmin group. But this didnt work. I checked the "SQL network config" named pipes to make sure the servers IP is in there which it is , however this was not neccessary, as obviously a connection is still established using the sa user. Any assistance is appreciated: JasonLaskey:ITLab
Question by:benthomas
    LVL 6

    Accepted Solution


    Check out following link, may it will help you.

    Author Comment

    Thanks mate, will try it in the week and revert back to you (Jlaskey:ITLAB)

    Author Comment

    Hi Mandeep,

    Sorry that I haven't replied yet to your comment.
    I am waiting for the client to come back from Holiday before I can attempt anything WRT the ODBC error.
    As soon as I do test I will revert back to you.

    Thanks again

    Author Closing Comment

    Brilliant assistance: Thanks Mandeep just to let you know you were 100% on the right path as using the two links solved the issue

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
    Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

    754 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

    18 Experts available now in Live!

    Get 1:1 Help Now