Results 1 to 7 of 7

Thread: ERROR ODBC 28000 on MS SQL 2000

  1. 03-09-2006, 01:58 PM #1
    qwer
    qwer is offline Registered User
    Join Date
    Jul 2004
    Posts
    106

    ERROR ODBC 28000 on MS SQL 2000

    a customer is getting
    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 qwer; 03-09-2006 at 02:01 PM.
    Reply With Quote Reply With Quote
  2. 03-09-2006, 04:06 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    How do you connect to sql server in aspx?
    Reply With Quote Reply With Quote
  3. 03-09-2006, 04:45 PM #3
    qwer
    qwer is offline Registered User
    Join Date
    Jul 2004
    Posts
    106
    the connection works fine on more than 10 servers and mine but that one not !

    with ODBC connection string :
    Driver={SQL Server};Server=ServerName;Database=DatabaseName;Ui d=;Pwd=;Trusted_Connection=;
    Reply With Quote Reply With Quote
  4. 03-09-2006, 04:50 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Use trusted connection? Checked mdac version? Web server and sql server in same domain? ...
    Reply With Quote Reply With Quote
  5. 03-10-2006, 01:40 AM #5
    qwer
    qwer is offline Registered User
    Join Date
    Jul 2004
    Posts
    106
    no use of Trusted_Connection the string is empty
    mdac version is the last on NET 1.1 is onstalled

    Web server and sql server in same domain > yes (local) .. no domain

    thank you
    Reply With Quote Reply With Quote
  6. 03-10-2006, 09:20 AM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You got correct user id and password then? Does sql server accept sql authentication?
    Reply With Quote Reply With Quote
  7. 03-10-2006, 10:38 AM #7
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try connecting from Query Analyzer (if it is not installed in web server try ODBC administrator) to see you can reach the SQL server.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules