Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Tampa, Florida, USA
    Posts
    4

    Unanswered: Can't connect to server

    Hey,
    I've had a server running for the last couple of months and earlier today it died, i managed to get Service Pack 2 on it, and now it will start but nothing will interface with it,
    especially not coldfusion

    Coldfusion says
    SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.

    though when i use ODBC and i set a new DSN
    if i use Windows Authentication, it goes through, and i test the source and it says succesful
    though if i try and use SQL Authentication it says

    Connection Failed :
    SQL State : '28000'
    SQL Server Error : 18452
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for 'username'. Reason : User not associated with a trusted SQL connection

    any ideas?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Is your sql instance set up for windows only authentification or mixed-mode ?

  3. #3
    Join Date
    Dec 2002
    Location
    Tampa, Florida, USA
    Posts
    4
    Originally posted by rnealejr
    Is your sql instance set up for windows only authentification or mixed-mode ?
    its ok
    sorted it now, it was for SQL Authentication, not mixed or windows

    i rebuilt the registry and it worked

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •