Professional Web Applications Themes

Login failed for SQL Server 2000 datasource - Coldfusion Database Access

I am trying to setup a SQL server 2000 datasource, but I keep getting the error "[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user...". I have no idea what the problem could be. I've looked everywhere for info. TCP/IP is configured. The SQL Server is configured for both Windoes and SQL server authentication. The username can login via enterprise manager. I've tried accessing the database from CF installed on the same machine and an my local machine. Both times I get the same error. Also, the ColdFusion admin seems to convert the password to a 16 character string. I'm not sure if ...

  1. #1

    Default Login failed for SQL Server 2000 datasource

    I am trying to setup a SQL server 2000 datasource, but I keep getting the error
    "[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user...".

    I have no idea what the problem could be. I've looked everywhere for info.

    TCP/IP is configured.

    The SQL Server is configured for both Windoes and SQL server authentication.
    The username can login via enterprise manager.

    I've tried accessing the database from CF installed on the same machine and an
    my local machine. Both times I get the same error. Also, the ColdFusion admin
    seems to convert the password to a 16 character string. I'm not sure if that is
    normal.

    This is the error info from the page:

    SQL SELECT * FROM CUSTOMERS
    DATASOURCE mamdev
    VENDORERRORCODE 18456
    SQLSTATE 28000

    Any help would be appreciated.

    Thank you.

    KingZeus Guest

  2. #2

    Default Re: Login failed for SQL Server 2000 datasource

    You should double check the username and password in the datasource. That
    is the problem if you are getting log in errors.

    The password field in the admin is always shown the same way, that probably
    isn't the problem.
    --
    Tom Jordahl
    Macromedia Server Development


    Tom Jordahl Guest

Similar Threads

  1. Install MX 7 failed on window 2000 server.Help help!!!
    By YXIAO in forum Coldfusion Server Administration
    Replies: 0
    Last Post: September 22nd, 05:14 PM
  2. "Login failed for user" when setting up a SQL datasource
    By windowshade in forum Coldfusion Database Access
    Replies: 3
    Last Post: August 18th, 07:09 PM
  3. Replies: 1
    Last Post: August 16th, 10:00 PM
  4. Windows 2000 Server forcing logout immediately after login
    By Luke Kandia in forum Windows Server
    Replies: 0
    Last Post: June 9th, 07:32 AM
  5. Replies: 0
    Last Post: November 1st, 10:03 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139