Hi
I created ASP.NET 2.0 web application that uses SQL Server 2000 database and
it works perfectly when website and Sql server were on local machine.
Then I installed application on production server. Database is placed on
another server.
I received the error:
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)
Why it thinks I am trying to connect to SQL Server 2005 ? There is no any
2005 server on remote server!
This is my connection string:
Server=servername;Database=SOX;User ID=userxxx;Password=******;
Query Analyzer and Enterprise Manager connect perfectly (when installed on
production server) to database server! Then I created small console
appplication which uses the same data layer as web application (and
connection string ) - it connected to remote database too! Only ASP.NET
2.0 application couldn't connect to remote Sql server 2000.
Can anyone help? 5 8499
Try changing the connection string to reflect the actual address to server,
that may include changing that information in the web.config file...
This is my connection string:
Server=ADDRESS TO SERVER!;Database=SOX;User ID=userxxx;Password=******;
"Mitya Mitriev" <aa*@stopspam.orgwrote in message
news:uT**************@TK2MSFTNGP04.phx.gbl...
Hi
I created ASP.NET 2.0 web application that uses SQL Server 2000 database
and
it works perfectly when website and Sql server were on local machine.
Then I installed application on production server. Database is placed on
another server.
I received the error:
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)
Why it thinks I am trying to connect to SQL Server 2005 ? There is no any
2005 server on remote server!
This is my connection string:
Server=servername;Database=SOX;User ID=userxxx;Password=******;
Query Analyzer and Enterprise Manager connect perfectly (when installed on
production server) to database server! Then I created small console
appplication which uses the same data layer as web application (and
connection string ) - it connected to remote database too! Only ASP.NET
2.0 application couldn't connect to remote Sql server 2000.
Can anyone help?
Do you mean IP address? I tried, it didn't help :(
"Henry" <at**************@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...
Try changing the connection string to reflect the actual address to
server, that may include changing that information in the web.config
file...
This is my connection string:
Server=ADDRESS TO SERVER!;Database=SOX;User ID=userxxx;Password=******;
"Mitya Mitriev" <aa*@stopspam.orgwrote in message
news:uT**************@TK2MSFTNGP04.phx.gbl...
>Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine.
Then I installed application on production server. Database is placed on another server. I received the error: 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)
Why it thinks I am trying to connect to SQL Server 2005 ? There is no any 2005 server on remote server!
This is my connection string: Server=servername;Database=SOX;User ID=userxxx;Password=******;
Query Analyzer and Enterprise Manager connect perfectly (when installed on production server) to database server! Then I created small console appplication which uses the same data layer as web application (and connection string ) - it connected to remote database too! Only ASP.NET 2.0 application couldn't connect to remote Sql server 2000.
Can anyone help?
Mitya i think you might need to take some additional steps
See this page at : http://www.datamasker.com/SSE2005_NetworkCfg.htm
Hope that helps
Patrick
"Mitya Mitriev" <aa*@stopspam.orgwrote in message
news:ex**************@TK2MSFTNGP03.phx.gbl...
Do you mean IP address? I tried, it didn't help :(
"Henry" <at**************@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...
>Try changing the connection string to reflect the actual address to server, that may include changing that information in the web.config file...
This is my connection string:
Server=ADDRESS TO SERVER!;Database=SOX;User ID=userxxx;Password=******;
"Mitya Mitriev" <aa*@stopspam.orgwrote in message news:uT**************@TK2MSFTNGP04.phx.gbl...
>>Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine.
Then I installed application on production server. Database is placed on another server. I received the error: 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)
Why it thinks I am trying to connect to SQL Server 2005 ? There is no any 2005 server on remote server!
This is my connection string: Server=servername;Database=SOX;User ID=userxxx;Password=******;
Query Analyzer and Enterprise Manager connect perfectly (when installed on production server) to database server! Then I created small console appplication which uses the same data layer as web application (and connection string ) - it connected to remote database too! Only ASP.NET 2.0 application couldn't connect to remote Sql server 2000.
Can anyone help?
Thank you, but I use Sql Server 2000.
"Patrick.O.Ige" <na********@hotmail.comwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
Mitya i think you might need to take some additional steps
See this page at :http://www.datamasker.com/SSE2005_NetworkCfg.htm
Hope that helps
Patrick
"Mitya Mitriev" <aa*@stopspam.orgwrote in message
news:ex**************@TK2MSFTNGP03.phx.gbl...
>Do you mean IP address? I tried, it didn't help :(
"Henry" <at**************@hotmail.comwrote in message news:%2****************@TK2MSFTNGP04.phx.gbl...
>>Try changing the connection string to reflect the actual address to server, that may include changing that information in the web.config file...
This is my connection string:
Server=ADDRESS TO SERVER!;Database=SOX;User ID=userxxx;Password=******;
"Mitya Mitriev" <aa*@stopspam.orgwrote in message news:uT**************@TK2MSFTNGP04.phx.gbl... Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine.
Then I installed application on production server. Database is placed on another server. I received the error: 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)
Why it thinks I am trying to connect to SQL Server 2005 ? There is no any 2005 server on remote server!
This is my connection string: Server=servername;Database=SOX;User ID=userxxx;Password=******;
Query Analyzer and Enterprise Manager connect perfectly (when installed on production server) to database server! Then I created small console appplication which uses the same data layer as web application (and connection string ) - it connected to remote database too! Only ASP.NET 2.0 application couldn't connect to remote Sql server 2000.
Can anyone help?
You have to make sure that the remote server is not "Hidden" which would
prevent a remote connection; also check that BOTH Sql Server and Windows
Authentication are enabled.
Peter
--
Co-founder, Eggheadcafe.com developer portal: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
"Mitya Mitriev" wrote:
Thank you, but I use Sql Server 2000.
"Patrick.O.Ige" <na********@hotmail.comwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
Mitya i think you might need to take some additional steps
See this page at :http://www.datamasker.com/SSE2005_NetworkCfg.htm
Hope that helps
Patrick
"Mitya Mitriev" <aa*@stopspam.orgwrote in message
news:ex**************@TK2MSFTNGP03.phx.gbl...
Do you mean IP address? I tried, it didn't help :(
"Henry" <at**************@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl... Try changing the connection string to reflect the actual address to server, that may include changing that information in the web.config file...
This is my connection string:
Server=ADDRESS TO SERVER!;Database=SOX;User ID=userxxx;Password=******;
"Mitya Mitriev" <aa*@stopspam.orgwrote in message news:uT**************@TK2MSFTNGP04.phx.gbl... Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine.
Then I installed application on production server. Database is placed on another server. I received the error: 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)
Why it thinks I am trying to connect to SQL Server 2005 ? There is no any 2005 server on remote server!
This is my connection string: Server=servername;Database=SOX;User ID=userxxx;Password=******;
Query Analyzer and Enterprise Manager connect perfectly (when installed on production server) to database server! Then I created small console appplication which uses the same data layer as web application (and connection string ) - it connected to remote database too! Only ASP.NET 2.0 application couldn't connect to remote Sql server 2000.
Can anyone help?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Maziar Aflatoun |
last post by:
Hi guys,
I'm using Windows authentication to connect to SQL Server 2000. On my
computer the connection is fine. Now if I move it to a remote server, how
to I hard code my Username/Password in...
|
by: peshekeedweller |
last post by:
Using asp.net 1.1. vb.net 2003.
I am trying to connect to a remote sql server 2000 on a virtual machine
running windows 2000 server. I can connect through the server explorer in
visual studio,...
|
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...
|
by: Rajeev Tipnis |
last post by:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;819450
Questions:
1) Is this patch (fix) applicable to the .NET 1.1
Framework as well? That is, if we have Framework 1.1 (On...
|
by: gharmel |
last post by:
I'm trying to get some clues on why I get (much) slower responses from
my PHP applications when dealing with a remote sql server as opposed to
a local sql server.
Here's my situation:
Server...
|
by: =?Utf-8?B?TWVuYWth?= |
last post by:
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...
|
by: OJ |
last post by:
Hi,
I am at a loss here, I have a c# asp.net website which connects to a
remote SQL Server 2000 db via a connection string. If I set the
website up in the filesystem and use the inbuilt cassini...
|
by: Vikram S |
last post by:
Hi All,
I have an ASP.NET 2.0 web application on a web server and a separate machine
for SQL Server 2000 Database. I am using a Connectionstring based on Sql
Authentication to connect to the...
|
by: dfarney |
last post by:
I have created a program in c# .net 2.0 that connects to a remote sql 2000 server. Connection for all our users/clients all over the US is fine, execpt one. Im thinking that it his firewall, but when...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |