Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2005
    Posts
    115

    Unanswered: ERROR 28000 Invalid authorization specification

    a customer is getting on mS SQL 2000
    ERROR ODBC 28000 Invalid authorization specification

    I dont understand because all the rigth are OK
    ASP NET USER, IISS user and so on !

    i am trying to connect the to SQL from ASPX pages (it works for me and a few customers but not that one)

    what can be the problem ?

    thank you
    Last edited by quentin; 03-09-06 at 15:02.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    ODBC state 28000 usually means a bad password or login. You can confirm this by running a trace of the login failed event on sql server.

  3. #3
    Join Date
    Jun 2005
    Posts
    115
    maybe he has entered a password or login somewhere and even dont remember it !
    normally we have asked no login no password and no trusted connection

    how do you run a trace on SQL 2000 ?

    thanks again for helping

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Run Profiler from the SQL Server programs group.

  5. #5
    Join Date
    Jun 2005
    Posts
    115
    i try it ! thank you

  6. #6
    Join Date
    Jun 2005
    Posts
    115
    but the trace run and run how long ?
    i get no result

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Provoke the error in your application, and you should see something.

Posting Permissions

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