retrieve data problems

[ahsan2011]

hii i m trying to retrieve data from sql using C#.net private void Page_Load(object sender, System.EventArgs e) SqlConnection con; SqlDataReader dr; SqlCommand cmd; con = new SqlConnection("Server=ADNAN;Database=system;UID=sa;pwd="); cmd = new SqlCommand("Select * from info",con); con.Open(); dr= cmd.ExecuteReader(); Repeater1.DataSource= dr; Repeater1.DataBind(); dr.Close(); con.Close(); Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. When user id and password is removed..recieves a message "Login failed for user ' ADNAN \ASPNET" Ahsan

[Kunal P]

go to the enterprise manager, and create a new user for the database SYSTEM. it should be an asp.net user, also grant all the privileges.. hope it helps

Kunal