Getting Error while read the data from table

Question

Hi all, I am displaying the all the data in gridview from database table. I have attached the database file in app folder. But after writing the while i am running the application getting error like "Cannot open database requested in login 'Employee'. Login fails. Login failed for user 'HOME-47F64BE31D\Administrator'."

Here is all my code: aspx page:

aspx.cs: protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) GetData();

}
private void GetData()
{
    string str = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    SqlDataAdapter da = new SqlDataAdapter("GetEmp", str);
    da.SelectCommand.CommandType = CommandType.StoredProcedure;
    DataSet ds = new DataSet();
    da.Fill(ds);
    GridView1.DataSource = ds;
    GridView1.DataBind();
}

Pls help me what is the error??

Thanks, Sumit

Answer 1

Your error is exactly what it's looks like: a database access error. That HOME-47F64BE31D\Administrator user doesn't have access to your database. You have two choices:

• To grant access to that user into your database. You can define that permissions through your SQL Management Studio.
• To inform a user with permission into your querystring; edit your configuration file to add a User ID=aaa;Password=bbb with a user with permissions

As side note, you shouldn't to use a sa user into your application.