Hi,
I'm getting the following error when trying to view an aspx web page.

"SQL Server does not exist or access denied"

The aspx page and sql database are located on the same machine.

Here is my connection string and code:

string SQL = "SELECT * FROM tblCountry"; SqlConnection conn =new SqlConnection("Data Source=(localhost);Initial Catalog=YLCdbSQL;Integrated Security=SSPI"); SqlCommand countryLoad =new SqlCommand (SQL, conn); SqlDataAdapter daCountry =new SqlDataAdapter(countryLoad); DataSet dsCountry =new DataSet("YLCdbSQL"); try { conn.Open(); daCountry.Fill(dsCountry, "countryName"); } finally { conn.Close(); }

The error highlights the conn.Open(); line. I'm using SQL Server 2000.

Any ideas what the problem might be?

Thanks