question

IT1 avatar image
IT1 asked

ODBC issue

Hi, I am having an error where when i create a ODBc to connect to a database .... it works when i test it checking the use NT account....but when i enter the credentials it gives me an error .... I enter the credentials of the administrator (with the domain) it gives me an error .. ITS SQL 2008 r2 and running on mixed mode can anyone please help out thanks
sql-server-2008-r2odbc
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What is the error?
0 Likes 0 ·
SirSQL avatar image
SirSQL answered
It sounds like you are attempting to create a DSN and when it's asking you are entering credentials. If this is indeed the case you should be entering a SQL account here. Active Directory credentials through ODBC are pass-thru only, you cannot specify an account to use for that connection (for security purposes). If you look at the error log of the SQL Server you are attempting to connect to then you will more than likely see an error indicating that you are attempting to use domain credentials for a SQL login.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

IT1 avatar image
IT1 answered
ok i found the solution.... i will explain the scenario and issue and solution... 1: I was trying to create a DSN to connect to a SQL server that was running on mixed mode. 2: the DSN worked fine if I selected the NT account ie used windows authentication but when i used SQL authentication it dint work (I was entering the login info for my computer along with the domain) 3: two reason it dint work ... I was using a network account to login ... worked fine when i used sa and other reason SQL browser was not working ...
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.