Question
Can I use different authentication methods with SQL Server and ODBC?
Asked by: USER9835
68 Viewed
68 Answers
Answer (68)
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.