I've created a number of Delphi applications that work against a SQL Server 7.0 database. These operate through a single database component that makes use of a ODBC connection. Normally when I set up these ODBC connections I (after selecting a Name and Server-Name) select the option 'With SQL Server authentication using a login ID and password entered by the user' (for the parameter 'How should SQL Server verify the authenticity of the login ID'). However I am now attempting to make use of an ODBC connection whereby I select the option 'With Windows NT authentication using the network login ID'. I have not been successful in doing this. When I click the 'Next' button on the creation of the ODBC connection I am presented with an error indicating that the login failed for the indicated user (I am unable to set the user-name/password) - I had assumed that the user/password would be taken from the login (for the Windows NT / 2000 machine) but this does not provide me with a successful connection.
This is probably something fundamental that I'm missing so would appreciate any pointers anyone may have with this ....
Thanks in advance.
Steve
This is probably something fundamental that I'm missing so would appreciate any pointers anyone may have with this ....
Thanks in advance.
Steve