Здравствуйте !
У меня появлась такая вот проблема :
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Source Error:


Line 33: // myCommand.CommandType = CommandType.Text;
Line 34: //myConnection.
Line 35: myConnection.Open();
Line 36: SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
Line 37: //result;


Source File: c:\inetpub\wwwroot\webapplicationtest\webform1.aspx.cs Line: 35

Stack Trace:


[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
WebApplicationTest.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\webapplicationtest\webform1.aspx.cs:35
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Код

// Put user code to initialize the page here
SqlConnection myConnection = new SqlConnection("Persist Security Info=True;server=MAX;uid=sa;pwd=1;database=tempdb");//.AppSettings["ConnectionString"]);
DataSet ds = new DataSet();

SqlCommand myCommand = new SqlCommand("select * from tester", myConnection);

// Mark the Command as a SPROC
// myCommand.CommandType = CommandType.Text;
//myConnection.
myConnection.Open();
SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
//result;
int a = 0;
Никак не могу понять где не соединяет, таблица есть , дб есть....

То же самое ....
Сейчас работаю с кодом

private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="Persist Security Info=True;data source=MAX;uid=sa;pwd=1;database=tempdb";
oSQLConn.Open();
}
Не получается, нге подскажете , а это не может быть от настроек сервера ?
Если да, то что должно быть в нём прописано ?
Юзаю 2003 студию