• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

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
0
benthomas
Asked:
benthomas
  • 3
1 Solution
 
Mandeep SinghDatabase AdministratorCommented:
Hi,

Check out following link, may it will help you. http://support.microsoft.com/kb/811889
0
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now