473,320 Members | 1,950 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,320 software developers and data experts.

Failing to connect to remote SQL Server 2000 from ASP.NET 2.0 application

I have a problem (like most others posting issues on this forum :) )

I have a remote server running Windows XP SP2, with both SQL Server
2005 Express with Advanced Features and SQL 2000 installed. I can
remotely connect to the SQL Server 2000 instance using Query Analyser
or Enterprise Manager. I can also remotely connect to the SQLEXPRESS
using Management Studio Express Edition.

I am writing an ASP.NET 2.0 with VS2005 application (actually upgraded
from .NET 1.1 with VS2003). However, now I cannot connect to the
remote SQL Server 2000 from the application. I can connect to a
locally installed SQL Server 2000 on the development machine, but I
cannot connect to the remote server. I get these two errors:

WITH NAMED PIPES DISABLED AND TCP/IP ENABLED IN THE SQL SERVER 2000
CLIENT NETWORK UTILITY
provider: TCP Provider, error: 0 - A connection attempt failed because
the connected party did not properly respond after a period of time,
or established connection failed because connected host has failed to
respond.

WITH BOTH NAMED PIPES AND TCP/IP ENABLED IN THE SQL SERVER 2000 CLIENT
NETWORK UTILITY (TCP/IP WITH HIGHER PREFERENCE THAN NAMED PIPES)
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
I have also noticed that from VS2005 using the Server Explorer to add
a data connection, I can only connect to the remote SQL Server 2000 if
I use the OLEDB provider but not the SqlClient.

HOW CAN I FIX THIS? WHERE AM I GOING WRONG?

Mar 28 '07 #1
0 4862

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Per Bergland | last post by:
I have a system service written in C#. For some reason it fails to start on our external web server (running a tightened Windows 2000). If I try to start the services after logging on, it works...
4
by: frank | last post by:
Hi all, I have a largish asp-driven site that's crashing intermittently in a way that's just causing me to scratch my head a lot. I've not seen this happen in about five years of developing asp...
3
by: Dad | last post by:
I need to connect SQL Server 2000 to DB2 on z/OS through DB2 Connect 8. I can successfully connect and query data through a System DSN, but trying to link the server using this DSN and MSDASQL...
5
by: Daniel Bass | last post by:
I setup a asp.net project running on http://localhost/ which connects to a database on another server running sqlserver... I was able to connect to the database and create my application no...
1
by: vighnesh | last post by:
Hi All I am dealing a project in ASP.NET in which I have to establish a connection to SQL Server 2000 database,where the database was located on a remote system. For this I have used...
1
by: Antonello Calabrò | last post by:
Hi all, I created a webservice that execute a sql query on demand. If I try to execute the query from the WebForm, all is ok. If I try to execute the query from a normal Windows Application,...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...
4
by: =?Utf-8?B?VGVycmFuY2U=?= | last post by:
I have an application that runs fine on my machine(of course) that access the local Sql Server. However, when trying to run this application from another machine I receive a Sql timeout error. I...
5
by: Alan Silver | last post by:
Hello, Server configuration: Windows 2003 Server SP2 SQL Server 2000 SP4 ..NET v2.0.50727 just built up a new server using the same configuration as my current one. I even used the same CDs...
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...
0
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...
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.