473,569 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Not connceting to remote sqlserver through IIS

When I create an websit in VS2005 and run it then it is running on the port
and it is connecting to remote sqlserver. But when I create Virtual directory
in IIS and try to run my website it is not connecting to remote sqlserver. i
am getting the following 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)

Can any one help me in this?
Jan 29 '08 #1
1 1218
Hi Reddy,

Are you connecting to IIS hosting ASP.NET 2005 and SQL Server 2000 ????

--
Thanks,
Sanket Sirotiya
(sa************ *@yahoo.com)

"Reddy" <Re***@discussi ons.microsoft.c omwrote in message
news:71******** *************** ***********@mic rosoft.com...
When I create an websit in VS2005 and run it then it is running on the
port
and it is connecting to remote sqlserver. But when I create Virtual
directory
in IIS and try to run my website it is not connecting to remote sqlserver.
i
am getting the following 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)

Can any one help me in this?

Jan 29 '08 #2

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

Similar topics

1
2369
by: Babu Thomas | last post by:
Hello Everybody Please tell me which is the best method to adminster SQL Server database in remote web server. Eg. I am storing all the information of SQL database in my work place and after that have to upload the modified table to remote web server. Please tell me what is the easiest way or how I can achieve this without purchasing...
1
1828
by: ECathell | last post by:
Below is my code the stop works fine, but then my session is ended. And the rest of the code wont run. I was thinking of making it two different subs, but from the examples in the samples folder I shouln't have to. Dim srv1 As SQLServer srv1 = New SQLDMO.SQLServer
1
1939
by: Michael Peters | last post by:
what does a user (running XP) need who has Access but no SQLServer, and who would like to connect to a remote SQLServer database via ODBC? This user can set up a new System DSN but he needs a SQLServer driver for this, right? which files does he need to install that? -Michael
2
2952
by: christof | last post by:
Hello, I'm trying to do a backup by connecting to remote instance, code looks like that: using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Common; using System.Data.SqlClient; string connString = "Server=172.17.0.193\\SQLEXPRESS,15555;
6
20898
by: 3Dfelix | last post by:
Hi, someone could help me with this problem when trying to insert a record in a SQL express database? I can view record but not edit or insert. 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: SQL Network Interfaces, error: 26 -...
0
1400
by: man910 | last post by:
hi i configured my win2003 server to a remote access dial up server i want connect to sqlserver and get & Insert data from/into database on server from remote computer plz help me
5
1420
by: Luke Davis | last post by:
What do I have to change in the connection string to connect remotely to a SQL 2005 Server? (i.e. \\SQLSERVER becomes http://sqlserver.com:1433/) I am outsourcing the hosting and there is some information that references an internal database, any suggestions on the best way to make this happen? Thanks
1
1360
by: DR | last post by:
How to debug sql 2005 on remote machine. I am administrator on both my dev machine and remote sql server machine. I get this error when i try to connect to remote machien with visual studio: unable to connect to microsoft vistual studio remote debugging monitor named msdb3. the microsfot visual studio remote debugging montor (msvsmon.exe)...
9
1563
by: raviva | last post by:
Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing. Thanks,
0
7618
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8138
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7679
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7983
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5514
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5223
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3657
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2117
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
946
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.