Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / February 2008

Tip: Looking for answers? Try searching our database.

Problem connecting to SQL

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott - 05 Feb 2008 21:55 GMT
Hello,
   I have several ASP.NET 2.0 sites That connect to a SQL 7 database.  Up
untill a few days ago they had been functioning just fine .  For some reason
all my SQL connections are returning the following error sporaticly:
----------------------------------------------------------
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)
----------------------------------------------------------
   This is not happening all the time but there have been an unusual amount
of these errors as of late.  I have searched the we web but so far I have
been unable to find any documentation about this error that relates to SQL
7.

Any help would be appreciated.
-Scott
sloan - 05 Feb 2008 22:09 GMT
Find the "Surface Configuration" tool...under Start / Programs / Sql Server
2005.

However..the "remote connection" info is sometimes a red herring.

Check
www.connectionstrings.com

and make sure you (still) have a valid connection string.

> Hello,
>    I have several ASP.NET 2.0 sites That connect to a SQL 7 database.  Up
[quoted text clipped - 15 lines]
> Any help would be appreciated.
> -Scott
Scott Roberts - 05 Feb 2008 22:36 GMT
Focus on the first sentence and forget the rest. It simply means that, well,
a connection could not be established. Could be a network problem, a server
problem, a firewall problem, a SQL problem, etc.

> Hello,
>    I have several ASP.NET 2.0 sites That connect to a SQL 7 database.  Up
[quoted text clipped - 15 lines]
> Any help would be appreciated.
> -Scott

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.