Bug tracking and defect tracking
Aug 16, 2005 | Home > Bugzero > FAQs > KB

Login Authentication methods for Microsoft SQL Server

Microsoft SQL Server allows two authentication methods to access the database, SQL Server authentication and Windows NT authentication (the computer running SQL Server enables access to its data through Windows NT accounts).

If you connect SQL database using JDBC, you should use SQL Server authentication. SQL Server authentication relies on the internal user list maintained by the SQL Server computer. This list does not include Windows NT users, and is specific to the SQL Server computer. Users are created and configured using the SQL Server Enterprise Manager.

If you have a connection problem, see SQL Server JDBC Connection Errors

* Reference brought to you by Bugzero, it's more than just bug tracking software!