asked on

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

ASKER CERTIFIED SOLUTION

Mandeep Singh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

benthomas

ASKER

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

benthomas

ASKER

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

benthomas

ASKER

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