Skip to main content
N
Nikky2007
Participant
August 16, 2007
Question

Coldfusion and sql Server2000

  • August 16, 2007
  • 5 replies
  • 1238 views
I've been trying to use SQL Server Driver to create a data source ( I have a SQL database) and I have been having the error below

Connection verification failed for data source: test2
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection..
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection..

When i use odbc with sql specifying the same database it works. Please help what do i need to do to rectify this problem
    This topic has been closed for replies.

    5 replies

    M
    mdemahy
    Participant
    September 4, 2007
    SQL 2000 must have SP3 to work with CF8
    T
    TRS-80
    Participating Frequently
    August 27, 2007
    The SQL Server JDBC driver shipped with ColdFusion supports both Windows and SQL Server authentication; however, to use Windows authentication, the process hosting ColdFusion, e.g. the JRun service, must be running as an account with access to the database. The same is true of the JDBC drivers shipped by Microsoft. jTDS supports Windows authentication directly, but I wouldn't recommend using it if your application requires stable XA support.
    A
    aqlong
    Inspiring
    August 23, 2007
    i had this issue when i tried to authenticate with a user name that was not listed under ther Users tab in SQL 2000. you probably checked that but....
    N
    Newsgroup_User
    Inspiring
    August 16, 2007
    What kind of authentication is your DB using? Windows-only, or SQL
    Server/mixed mode? JDBC doesn't cope with windows-only, from memory.

    --
    Adam
    N
    Nikky2007Author
    Participant
    August 23, 2007
    My server is using both authentication. SQL server and Windows Authentication. I even try it with sample database that comes with Sql. I still have the following error

    Connection verification failed for data source: test2
    []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
    The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
    S
    Sankalan
    Participating Frequently
    August 16, 2007
    Are you providing the userName while selecting SQL server driver to create the datasource?

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