arachnode.net
An Open Source C# web crawler with Lucene.NET search using SQL 2005/2008/CE
Does arachnode.net scale? | VS2008/2010/2012 & SQL2008/2012 | Download the latest release

Cannot connect to SQL server (named pipes provider error: 40)

rated by 0 users
Answered (Verified) This post has 1 verified answer | 13 Replies | 2 Followers

Top 50 Contributor
9 Posts
snapplemonkey posted on Wed, Jan 19 2011 11:20 AM

Hello!

I've been able to get Arachnode.net to work despite being overwhelmed by the project and the console application works, the search.aspx for the Webproject works  and I can goto the downloaded files/images/html directory and look at the expected output but I have two big questions. 

Environment: Windows 7 / VS 2010 / SQL 2008 R2 / IIS

Question 1: When I goto the Administration page and click on one of the tables (http://localhost:15053/AllowedDataTypes/List.aspx) , I get the following error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 

 

My connection strings.config is

 <?xml version="1.0" encoding="utf-8" ?>

<connectionStrings>

  <add name="ArachnodeConnectionString"  connectionString="Data Source=WIN7PVM\WIN7VM;Initial Catalog=arachnode.net;Integrated Security=True;Connection Timeout=3600;"  providerName="System.Data.SqlClient" />

</connectionStrings>

and the snipped from Functions.csproj is <DatabaseConnection Name="Data Source=WIN7PVM\WIN7VM;Initial Catalog=arachnode.net;Integrated Security=True" Provider="{91510608-8809-4020-8897-FBA057E22D54}" ConnectionString="blahblahlongstr" /> <br> (New to the Windows environment, so my question is probably incredibly newbish). How do I get rid of this error/connect to MS SQL Server? I tried SQL Server Configuration Manager and verified that Pipes are enabled. Rebooted SQL server and VS2010 after making that change. <br><br>

Question 2: I want to crawl pages behind an https page and I did look at http://arachnode.net/forums/p/194/10030.aspx#10030 but didn't find anything helpful. Is it possible to crawl/download pages over HTTPS (this is an absolute requirement). Thanks in advance.

 

Answered (Verified) Verified Answer

Top 10 Contributor
1,692 Posts
Verified by arachnode.net

Great!  Glad you got almost all of it working.

1.) You probably need to update the connection string in web.config in the Administration project.

<connectionStrings>

<add name="arachnode_netConnectionString" connectionString="Data Source=.;Initial Catalog=arachnode.net;Integrated Security=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

2.) Yes, AN crawls https by default.

Mike

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

All Replies

Top 10 Contributor
1,692 Posts
Verified by arachnode.net

Great!  Glad you got almost all of it working.

1.) You probably need to update the connection string in web.config in the Administration project.

<connectionStrings>

<add name="arachnode_netConnectionString" connectionString="Data Source=.;Initial Catalog=arachnode.net;Integrated Security=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

2.) Yes, AN crawls https by default.

Mike

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 50 Contributor
9 Posts

1. Awesome. Now the Administration part talks fine to MS SQL Server. 

 

2. HTTPS: Would you please point me towards the right direction? I looked it up and found something about Credential.Cache. Does this functionality require a license? I am planning to get a developer license at the very least [this is a proof of concept project running inside a Windows 7 VM :) - Linux shop and all]. 

 

Thank you for your reply and thanks again in advance.

Top 10 Contributor
1,692 Posts

Wonderful!

http://msdn.microsoft.com/en-us/library/system.net.credentialcache(v=VS.90).aspx

http://arachnode.net/search/SearchResults.aspx?q=credentialcache

The CredentialCache is added in the Crawler constructor.

        public Crawler(CrawlMode crawlMode, CredentialCache credentialCache, bool enableRenderers) : this(crawlMode, enableRenderers)

        {

            CredentialCache = credentialCache;

        }

I have a new version that is in beta testing that will compile under Mono, but uses the AN DB for storage.  The next steps after that will be to wire in non-MS storage.  All operations are abstracted out so that the crawler is entirely general and you can customize EVERYTHING about it.  You can customize just about everything in AN now, but this version makes it even more flexible.

Mike

 

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 50 Contributor
9 Posts

Ah Crawler.cs was one of the things I checked and I rubbed my eyes before realizing that this requires a license :). I'll bug you if I need more help after getting the licensed version. Cheers.

Top 10 Contributor
1,692 Posts

The crawler works just like the regular version, but is limited to 5 minutes of crawling time.

The CredentialCache should work.

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 50 Contributor
9 Posts

Except Crawler.cs is in Klingon :). I just bought a developer license  and once I hear from you, I can go about with the CredentialCache part in Crawler.cs. 

Thanks again.

Top 10 Contributor
1,692 Posts

Are you out of Seattle?  If so, check your mail.

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 50 Contributor
9 Posts

Bellevue. 

I did get a confirmation from Google checkout and Google Order page tells me my order is complete. The status says:

arachnode.net, llc will send an email to [email protected] with instructions for accessing your purchase

Top 10 Contributor
1,692 Posts

OK, I did but you didn't respond.  I will add you to the Licensed group.  One moment.

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 50 Contributor
9 Posts

I think I checked the "hide my email address" so all email gets forwarded to me by Google and their service must be out to lunch :\. I can private message you my email address should you wish.

Top 10 Contributor
1,692 Posts

I will check the DB and send you another mail.

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 50 Contributor
9 Posts

I downloaded the Licensed copy. Thankfully I have practice from yesterday Yes. Thank you.

Top 10 Contributor
1,692 Posts

Don't forget to get the latest from SVN, OK?  This is what you should be using for real development.  It is what I work from for my own projects.

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Page 1 of 1 (14 items) | RSS
An Open Source C# web crawler with Lucene.NET search using SQL 2005/2008/CE

copyright 2004-2013, arachnode.net LLC