Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 11th, 2006, 08:03 AM
Registered User
 
Join Date: May 2006
Location: Bristol, CT, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Named Pipes Provider, error: 40

I get 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)


Exception Details: System.Data.SqlClient.SqlException: 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)

Source Error:

Line 46: Dim dsJobSite As DataSet
Line 47:
Line 48: sqlDBConn.Open()
Line 49:
Line 50: dsJobSite = New DataSet("JobSite")

Source File: c:\inetpub\wwwroot\JIEditor\MainMenu.aspx.vb Line: 48

My ASP.NET 2.0 applicaton is running on a Windows 2000 Server with IIS 5.0. MDAC 2.6

Also, both Names Pipes and TCP/IP protocols are enabled.

Please help me connect to the database.

Isa Paine


Isa Paine
Software Developer
  #2 (permalink)  
Old November 14th, 2006, 03:36 AM
Registered User
 
Join Date: Nov 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have the same the problem. Any suggestions?



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 40. Do anyone known it? Please help! avgCS Classic ASP Basics 0 July 27th, 2007 06:53 AM
Error 40 prasanta2expert SQL Server 2000 1 December 7th, 2006 01:31 AM
Error 40 prasanta2expert ASP.NET 1.x and 2.0 Application Design 1 December 6th, 2006 06:04 AM
Error 40 prasanta2expert ASP.NET 1.0 and 1.1 Basics 0 December 6th, 2006 02:58 AM
Named Pipes bpe_xmind Visual C++ 0 February 5th, 2006 08:21 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.