"Login failed for user 'sa'" datagrid control - SqlDataAdapter

Discussion in 'ASP .Net Datagrid Control' started by Jerry Higgins, Apr 20, 2004.

  1. I added a SqlDataAdapter to a web form, created a data
    connection, and generated a dataset. I then connected it
    to a DataGrid control. When I do this using the
    SqlServer database on my machine everything works fine.
    When I do it using a SqlServer database on another
    machine I get the "Login failed for user sa" error.
    However, when I right click on the SqlDataAdapter and
    click "Preview Data" it brings back the data OK. Why
    would it bring back the data on this but not work in the
    DataGrid control?

    Thanks,

    Jerry Higgins
    Jerry Higgins, Apr 20, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jerry Higgins
    Replies:
    6
    Views:
    627
    Jerry Higgins
    Apr 21, 2004
  2. Jerry Higgins
    Replies:
    1
    Views:
    814
    Curt_C [MVP]
    Apr 21, 2004
  3. tom c
    Replies:
    1
    Views:
    1,532
    Jon Paal
    Sep 7, 2006
  4. Tony Girgenti
    Replies:
    2
    Views:
    342
    Tony Girgenti
    Sep 21, 2006
  5. Tony Girgenti

    The parameter is not correct from SqlDataAdapter control

    Tony Girgenti, Sep 20, 2006, in forum: ASP .Net Web Controls
    Replies:
    2
    Views:
    118
    Tony Girgenti
    Sep 21, 2006
Loading...

Share This Page