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

ASP.NET 2.0 and connection to remote SQL 2000 server

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?
Aug 5 '06 #1
5 8500
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?


Aug 5 '06 #2
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?



Aug 5 '06 #3
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?




Aug 6 '06 #4
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?




Aug 6 '06 #5
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?



Aug 6 '06 #6

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

Similar topics

2
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...
16
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,...
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...
26
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...
3
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...
1
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...
5
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...
1
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...
13
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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...
0
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.