Skip to main content
B
BrianMi
Participant
September 22, 2006
Answered

NT Authentication with SqlServer 2005

  • September 22, 2006
  • 5 replies
  • 679 views
I am trying to setup a datasource in MX6.1 to connect to sql server 2005 using nt authentication. I installed the jdbc driver for sql server 2005 according to the steps listed at

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=ded4216b&pss=rss_coldfusion_ded4216b.

I am getting the following error:

Connection verification failed for data source: [servername]
[]java.sql.SQLException: No suitable driver available for [servername], please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDriver
The root cause was that: java.sql.SQLException: No suitable driver available for [servername], please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDriver

The following configuration is used in the datasource:

JDBC URL: jdbc:sqlserver://[servername]:1433;DatabaseName=[databasename];
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

I have not seen many posts on this, but the one's that I have seen do not offer a working solution.

Any help greatly appreciated.

Brian


This topic has been closed for replies.
Correct answer BrianMi
I found the problem. I needed to append "IntegratedSecurity=true" to the end of the jdbc url string just which happens to be mentioned in one of the microsoft articles.

5 replies

B
BrianMiAuthorCorrect answer
Participant
September 26, 2006
I found the problem. I needed to append "IntegratedSecurity=true" to the end of the jdbc url string just which happens to be mentioned in one of the microsoft articles.
B
BrianMiAuthor
Participant
September 26, 2006
Thanks for the input. CF is running under a domain user, and the sqljdbc_auth.dll is there, also. It seems to be something that needs to be passed in the jdbc url to force win auth, but nothing seems to work.
N
Newsgroup_User
Inspiring
September 26, 2006
I *think* I read somewhere that cf has to be running under the windows
account you want to use for authentication, or at least for the
datadirect drivers
( http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a). The
default account cf runs under is system. I wonder if the same
restriction exists for the M$SQL JDBC drivers...
and you've seen this page?
http://msdn2.microsoft.com/en-us/library/ms378428.aspx where it says to
put the sqljdbc_auth.dll in the system path

hth
--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com
B
BrianMiAuthor
Participant
September 26, 2006
That did not work, but I have since installed the 1.1 version of the jdbc driver. The driver is now being recognized, but it is still trying to use sql authentication based on the error message below. I have also tried adding "AuthenticationMethod=Type2;" to the url, but the same error appears.

[]com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
The root cause was that: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
A
Anonymous
September 26, 2006

Looks like you might have a typo in your JDBC URL.

Take a look at this article...
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18652

jdbc:microsoft:sqlserver:// ps-db : 1433 ;DatabaseName= NorthWind

Where ps-db is the name of the database server.
Where 1433 is the port number for the data source connection.
Where NorthWind is the database you are connecting to.


Good luck!
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices