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

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
ODBC-Error.jpg
benthomasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mandeep SinghDatabase AdministratorCommented:
Hi,

Check out following link, may it will help you. http://support.microsoft.com/kb/811889
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
benthomasAuthor Commented:
Thanks mate, will try it in the week and revert back to you (Jlaskey:ITLAB)
0
benthomasAuthor Commented:
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
0
benthomasAuthor Commented:
Brilliant assistance: Thanks Mandeep just to let you know you were 100% on the right path as using the two links solved the issue

http://msdn.microsoft.com/en-us/library/aa905162(SQL.80).aspx
http://msdn.microsoft.com/en-gb/library/ms191153.aspx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.

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.