SQL Server JDBC Driver Login

Hi,

I'm using the SQLServer JDBC driver that was bundled with Java Studio Creator 2 Update 1, which are: smbase.jar, smutil.jar, and smsqlserver.jar. When trying to connect to SQL Server using Windows Authentication Mode, I kept getting the following connection failure status:

[SQLServer JDBC Driver]A username was not specified and the driver could not establish a connection using type 4 integrated security: C:/Program Files/Sun/Creator2_1/rave2.0/core/JDBCDriverLogin.conf (No such file or directory).

It seems that a JDBCDriverLogin.conf file was not provided with the bundled download from Sun. Please provide an example of JDBCDriverLogin.conf, or other suggestion.

I was able to connect using SQL Server Authentication Mode, but would like to use the Mixed Mode feature where either Windows Authentication or SQL Server Authentication could be used.

Regards,

Tin Lai

Message was edited by:

TmlSDNSN

[964 byte] By [TmlSDNSN] at [2007-11-26 10:59:10]
# 1

JDBCDriverLogin.confis the Configuration file that instructs the driverto use the Kerberos login module for authentication

ALso, check out this FAQ, it could apply to you:

http://developers.sun.com/prodtech/javatools/jscreator/reference/faqs/technical /dbaccess/faqsqlserver.html

Refer this as well:

http://media.datadirect.com/download/docs/jdbc/jdbcref/jdbcsqlsrv.html#wp962753

HTH,

Sakthi

sakthivelgopal at 2007-7-7 3:12:45 > top of Java-index,Development Tools,Java Tools...