If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > ERROR 28000 Invalid authorization specification

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-09-06, 14:57
quentin quentin is offline
Registered User
 
Join Date: Jun 2005
Posts: 115
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.
Reply With Quote
  #2 (permalink)  
Old 03-09-06, 15:40
MCrowley MCrowley is online now
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 4,784
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.
Reply With Quote
  #3 (permalink)  
Old 03-09-06, 17:47
quentin quentin is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 03-09-06, 18:16
MCrowley MCrowley is online now
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 4,784
Run Profiler from the SQL Server programs group.
Reply With Quote
  #5 (permalink)  
Old 03-10-06, 02:40
quentin quentin is offline
Registered User
 
Join Date: Jun 2005
Posts: 115
i try it ! thank you
Reply With Quote
  #6 (permalink)  
Old 03-10-06, 05:31
quentin quentin is offline
Registered User
 
Join Date: Jun 2005
Posts: 115
but the trace run and run how long ?
i get no result
Reply With Quote
  #7 (permalink)  
Old 03-10-06, 10:14
MCrowley MCrowley is online now
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 4,784
Provoke the error in your application, and you should see something.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On