sql server connection error

[plily]

i am trying to connect to a sql server using windows authentication, but getting the following errro :"sql server does not exists or access denied".pls. help:following is the code:

 
public class mygrid : System.Web.UI.Page
    {
 
        //SqlConnection mysqlconnect;
        SqlDataAdapter mydadapt;
        protected System.Web.UI.WebControls.DataGrid mygrid1;
        DataSet  ds = new DataSet();
 
        private void Page_Load(object sender, System.EventArgs e)
        {
                try
         {
             // Put user code to initialize the page here
             string conn= "Data Source = localhost;Database=lily;Integrated Security=SSPI";
            SqlConnection mysqlconnect= new SqlConnection(conn);
             mysqlconnect.Open();
             mydadapt = new SqlDataAdapter("Select * from Product1", mysqlconnect);
             mydadapt.Fill(ds, "AllTables");
 
 
                mygrid1.DataSource=ds;
                    mygrid1.DataBind();
                     mysqlconnect.Close();
 
         }
         catch(SqlException objsqlexception)
         {
             Response.Write("<ul>");
             foreach(SqlError  objerror in objsqlexception.Errors)
             {
                 Response.Write("<li>" + objerror.Message + "</li>");
             }
             Response.Write("</ul>");
         }
            // Put user code to initialize the page here
        }
 
            }
 
 
 
 

[bplacker]

i am trying to connect to a sql server using windows authentication, but getting the following errro :"sql server does not exists or access denied".pls. help:following is the code:

 
public class mygrid : System.Web.UI.Page
    {
 
        //SqlConnection mysqlconnect;
        SqlDataAdapter mydadapt;
        protected System.Web.UI.WebControls.DataGrid mygrid1;
        DataSet  ds = new DataSet();
 
        private void Page_Load(object sender, System.EventArgs e)
        {
                try
         {
             // Put user code to initialize the page here
             string conn= "Data Source = localhost;Database=lily;Integrated Security=SSPI";
            SqlConnection mysqlconnect= new SqlConnection(conn);
             mysqlconnect.Open();
             mydadapt = new SqlDataAdapter("Select * from Product1", mysqlconnect);
             mydadapt.Fill(ds, "AllTables");
 
 
                mygrid1.DataSource=ds;
                    mygrid1.DataBind();
                     mysqlconnect.Close();
 
         }
         catch(SqlException objsqlexception)
         {
             Response.Write("<ul>");
             foreach(SqlError  objerror in objsqlexception.Errors)
             {
                 Response.Write("<li>" + objerror.Message + "</li>");
             }
             Response.Write("</ul>");
         }
            // Put user code to initialize the page here
        }
 
            }
 
 
 
 

make sure you are a user with read/write rights to the database, also.. instead of saying
Database = Lily, try

Initial Catalog = Lily

[plily]

Thanks for your answer bplacker , i tried that but does not work, any other suggestions??

make sure you are a user with read/write rights to the database, also.. instead of saying
Database = Lily, try

Initial Catalog = Lily

[kenobewan]

Here is an example of how to set up Windows Authentication:
How to Use Windows Authentication to Access SQL Server Through a ASP.NET Web Application

Don't forget the web.config file...

Hope that this helps.