I'm a newer in .net. I cann't conect to the SQLServer on a local area network computer.The more strange thing is that I can connect to another SQLServer which in USA.Now I'm in China.
My appsetting:
<add key="RRE_ConnectionString"
value="data source=CADCISDTEST2;initial catalog=ForRRE;persist security info=true;user id=sa;password=sa;workstation id=CADCISDTEST2;packet size=4096"
Error description is below:
[IMG]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 80: ISDC_Connection.ConnectionString = ConfigurationSettings.AppSettings["RRE_ConnectionString"];
Line 81: //ISDC_Connection.ConnectionString = ConfigurationSettings.AppSettings["Isdc_ConnectionString"];
Line 82: ISDC_Connection.Open();
Line 83: // ISDC_UiUtils.fillListBox(ISDC_Connection, "RRE_Features_GetList", ref DropDownList1, 1, 0 );
Line 84: ISDC_UiUtils.fillListBox(ISDC_Connection, "ISDC_Projects_GetList", ref DropDownList1, 1, 0 );
Source File: c:\inetpub\wwwroot\webapplication1\webform1.aspx.c s Line: 82
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
WebApplication1.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\webapplication1\webform1.aspx.c s:82
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()[/IMG]
Thanks a lot!