With Microsoft SQL Database Server 2000 you can choose either of the two security (authentication) modes, namely:
- NT security mode (Windows NT Authentication only),
- Mixed mode (Windows NT Authentication and SQL Server Authentication).
NT security mode (Windows NT Authentication only):
It is related to windows domain. Access will be given to existing domain user account.Using those credentials, user can access the database.Separate account is not created as in other databases.
Mixed mode (Windows NT Authentication and SQL Server Authentication)
In these modes, both domain accounts and database accounts can be used to access the database.
JDBC drivers available for Microsoft SQL Database Server 2000:
1. JTDS Driver
JTDS driver works in both NT security mode and mixed mode.
2. Microsoft SQL Server JDBC Driver
MS SQL server JDBC driver works in mixed mode only.
Connection strings used for NT security mode using JTDS driver:
Ex:
con = java.sql.DriverManager.getConnection(“jdbc:jtds:sqlserver://servernaem or IP address:port no/database name;user=domain username;password=password;domain=Domain name”);
This string works in both windows and non-windows. This is not ntlm authentication method.
or
con = java.sql.DriverManager.getConnection(“jdbc:jtds:sqlserver://servernaem or IP address:port no/database name;”);
This method uses NTLM authentication. So NTLMauth.dll has to be copied to the system path. [ It is available along with JTDS driver. ]
Related posts:
Tags: Connection strings used for NT security mode using JTDS driver:, JDBC drivers available for Microsoft SQL Database Server 2000, JTDS Driver, Microsoft SQL Server JDBC Driver, MS SQL Server 2000 authentication modes
