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
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.
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 ...
