"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. Advertisements

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:
    654
    Jerry Higgins
    Apr 21, 2004
  2. Jerry Higgins
    Replies:
    1
    Views:
    842
    Curt_C [MVP]
    Apr 21, 2004
  3. tom c
    Replies:
    1
    Views:
    1,583
    Jon Paal
    Sep 7, 2006
  4. Tony Girgenti
    Replies:
    2
    Views:
    365
    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:
    136
    Tony Girgenti
    Sep 21, 2006
Loading...

Share This Page