Can I use different authentication methods with SQL Server and ODBC?

Responsive Ad Header

Question

Grade: Education Subject: Support
Can I use different authentication methods with SQL Server and ODBC?
Asked by:
68 Viewed 68 Answers

Answer (68)

Best Answer
(348)
Yes, SQL Server supports various authentication methods, including Windows authentication and SQL Server authentication. The ODBC connection settings in your DSN must be configured to match the authentication method used by the SQL Server instance. Ensure the username and password entered in the DSN are valid for the chosen authentication method.