Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Virginia
    Posts
    2

    Unanswered: [SQL Server]Login failed for user

    I am using Crystal Reports, VB.net, SQL Server 2000sp3, MDAC 8.0, and Windows XP. When I try to make a connection from a Crystal Report to SQL Server via an ODBC connection, I get the following message:

    Details: 28000:[Microsoft][SQL Server Driver][SQL Server]Login failed for user domain/username

    In the odbc, I specify SQL Server authentication and provide a username and password but these are being ignored. Why is Windows authentication being used in place of the SQL Server authentication that I specify in my odbc?

    Thanks in advance,

    Matt

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    That's Crystal for you

  3. #3
    Join Date
    Jan 2004
    Posts
    1

    Re: [SQL Server]Login failed for user

    What version of Crystal Reports are you using?

  4. #4
    Join Date
    Jan 2004
    Location
    Virginia
    Posts
    2

    Re: [SQL Server]Login failed for user

    Originally posted by awsterling
    What version of Crystal Reports are you using?
    I am the version that came with Visual Studio .Net 2003. I don't know how to get the version number from it.

    Thanks.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Get ActiveReport from DataDynamics and you won't have to deal with these issues any more

Posting Permissions

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