473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

My issue about SQL Server connection

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!
May 23 '07 #1
3 1054
kenobewan
4,871 Expert 4TB
Welcome to the site. SQL Server does not exist or access denied is a clear message.
May 23 '07 #2
Maybe something wrong with the server. I connected to another Server ,and it works well now
May 25 '07 #3
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"
Could be a myriad of reasons, but I'd start with that data source host name,
CADCISDTEST2. Replace it with the IP of the server see if that works. If so, try using the fully qualified hostname of the server. Get your network admin to help.
May 25 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: David Gamble | last post by:
I am having problems with long timeouts when connecting to or executing commands in SQL Server 2000 SP3. I am writing an application that will be used on laptops within an environment that is...
3
by: ACP | last post by:
Hi all, Have a situation that my company has never run across before. Client is running NT4 for the domain server, using terminal services 2000 and running an application with a SQL Server...
4
by: Frodo | last post by:
I have a problem establishing a link between Visual Studio.NET 2003 and SQL Server 2000. Both are installed on a Windows Server 2003, standard version. Visual Studio.NET Issues...
0
by: Kevin Spencer | last post by:
Hi all, I am working on a service that uploads METAR weather information to the National Weather Service FTP site. The service I'm authoring is hosted on a Windows 200 server, and the NWS FTP...
1
by: Rhys | last post by:
I have a page which has an IFrame on it. The src of the IFrame is a page with a datagrid on it. The Datagrid has bound template columns. The columns of the datagrid pass the bound data value of...
7
by: Mike | last post by:
I'm trying to connect to a SQL 2000 db that is on another server then the web server. I setup and ID and PWD to access the SQL db via the code and it works locally and when I put the everything...
3
by: AGB | last post by:
Hi all, I have a two hop issue. I have two machines in the same domain--one webserver and the other hosting SQL Server. I am using impersonation and integrated windows authentication but for...
1
by: OldButStillLearning | last post by:
OK, I am trying to connect to DB2 (z/OS). I have successfully made the connection to the database in the Server Explorer. I am also able to successfully log in to DB2 when I am testing the...
2
by: =?Utf-8?B?SnVsaWEgQg==?= | last post by:
Hi, I'm wondering if anyone can give me any ideas/good practice/advice. I've got a web form which a user inputs lots of data into, then presses submit. The submit button uses two classes to input...
10
by: jimjim | last post by:
HI, We have shifted our database from sqlserver2003 to sqlserver2005. 1. connection strings stored in web.config <!-- Machine name to connection string keys --> <add key="*777*"...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.