RE: SQL Connection with ASP.net
- From: Menaka <Menaka@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 27 Mar 2007 16:00:23 -0700
i already set as the enable of rome connection in SQL Server according to
that error message, using connection object can connect with sqlserver 2005
in the same machine, but when connectiong to another server error msg occure,
pls help me
"Sashidhar Kokku" wrote:
Menaka,.
As your error text specifies, the server you are trying to connect to may
not accept remote connections. Remote connections are not the same as
connecting through an asp.net application.
You have to contact your admin and ask him/her to enable remote connections
to the server. Once you have that out of the way, connecting to the remote
sql 2000 server should not create any problems when you connect from a sql
2005 client.
--
Sashidhar Kokku
ikaSystems Corp
"Menaka" wrote:
i have developed a web application for intranet and it is installed on the
Computer name 'Server' and its already installed sql server 2005, never
problem when connecting to sql server 2005 on the 'Server', this intranet has
another computer named 'B' and it's already exist SQL2000. i want update some
data to SQL2005 on 'Server' using in a SQL2000 which have 'B' computer' when
connecting to 'B' it return error like bellow.
'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)'
please help me
- Follow-Ups:
- Re: SQL Connection with ASP.net
- From: Alexey Smirnov
- Re: SQL Connection with ASP.net
- Prev by Date: RE: Check to see if a value is a DateTime
- Next by Date: RE: server application unavailable
- Previous by thread: RE: Check to see if a value is a DateTime
- Next by thread: Re: SQL Connection with ASP.net
- Index(es):
Relevant Pages
|
