Friday, February 24, 2012

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 youODBC 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.|||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|||Run Profiler from the SQL Server programs group.|||i try it ! thank you|||but the trace run and run how long ?
i get no result|||Provoke the error in your application, and you should see something.

No comments:

Post a Comment