About Arachnode.net Source:

• Visual Studio 2005 Solution & SQL Server 2005 Database Backup.
• Solution created with Visual Studio 2005 Professional Edition.
• Database created with SQL Server 2005 Developer (Enterprise) Edition.

Installation Notes:

• The installation instructions for Visual Studio and SQL Server pertain to Visual Studio 2005 Professional Edition and SQL Server 2005 Developer (Enterprise) Edition.  Express versions may be used but certain functionality such as CLR function deployment, Analysis Services project integration, Integration Services project integration, Full-Text Catalog manipulation and other features may not be available.  It is recommended to use Visual Studio 2005 Professional Edition and SQL Server 2005 Developer (Enterprise) Edition when possible. 
• The Visual Studio solution contains an Analysis Services 2005 project and an Integration Services 2005 project.  Analysis Services 2005 projects and Integration Services 2005 projects are not compatible with Visual Studio 2008.
• Certain database configuration settings may not be compatible with existing database development environments.  Those not extremely familiar with .NET setup and configuration are encouraged to install to a Virtual Machine (.vmc) first to ascertain compatibility with existing database environment settings.
• Instructions described below assume the individual has sufficient rights to install and configure applications, create directories and manage directory and share permissions.
• The default installation for arachnode.net is targeted at a single machine environment. Multiple machine installation is possible but users should be familiar with the single machine installation before migrating to a multiple machine deployment.
• If the installation instructions seem a bit daunting, click here.

Creating a Virtual Machine:

• Dowload Virtual PC 2007 here.
• Install Windows XP or Windows Server 2003.

Arachnode.net Installation Instructions:

• Install TortoiseSVN.  Download here.
  Note: If TortoiseSVN is already installed you may skip this step.
1. Install TortoiseSVN with default options.
2. Restart your machine.
   
   
• Create the required application and database folders.
  Note: C:\AppWorkspace and C:\AppDatabases are the assumed installation defaults and can be changed after installation.
1. Create the folders 'C:\AppWorkspace\arachnode.net\source' and 'C:\AppWorkspace\arachnode.net\database'.
2. Create the folder 'C:\AppDatabases'.
   
   
• Checkout the source files.
1. Right-click on 'C:\AppWorkspace\arachnode.net\source' and select 'SVN Checkout...'.
2. Checkout 'http://arachnodenet.svn.sourceforge.net/svnroot/arachnodenet/source' to 'C:\AppWorkspace\arachnode.net\source' with default options.
   
   
• Checkout the database files.
1. Right-click on 'C:\AppWorkspace\arachnode.net\database' and select 'SVN Checkout...'.
2. Checkout 'http://arachnodenet.svn.sourceforge.net/svnroot/arachnodenet/database' to 'C:\AppWorkspace\arachnode.net\database'.
   
   
• Create the required source and database shares.
  Note: The shares 'AppWorkspace', 'AppDatabases', 'ConsoleOutputLogs', 'DownloadedFiles', 'DownloadedImages' and 'DownloadedWebPages' are the assumed installation defaults and can be changed after installation.
1. Share 'C:\AppWorkspace' as 'AppWorkspace' and grant the account that will run the arachnode.net executables 'Change' permission.
2. Share 'C:\AppDatabases' as 'AppDatabases' and grant the account that will run the arachnode.net executables 'Change' permission.
3. Share 'C:\AppWorkspace\arachnode.net\source\Test\ConsoleOutputLogs' as 'ConsoleOutputLogs' and grant the account that will run the arachnode.net executables 'Change' permission.
4. Share 'C:\AppWorkspace\arachnode.net\source\Test\DownloadedFiles' as 'DownloadedFiles' and grant the account that will run the arachnode.net executables 'Change' permission.
5. Share 'C:\AppWorkspace\arachnode.net\source\Test\DownloadedImages' as 'DownloadedImages' and grant the account that will run the arachnode.net executables 'Change' permission.
6. Share 'C:\AppWorkspace\arachnode.net\source\Test\DownloadedWebPages' as 'DownloadedWebPages' and grant the account that will run the arachnode.net executables 'Change' permission.
   
   
• Install Visual Studio 2005 Professional Edition or greater.  Download here.
  Note: If Visual Studio 2005 Professional Edition or greater with C# and Visual Web Developer is already installed you may skip this step.
1. Select 'Install Visual Studio' from the setup splash screen.
2. Click 'Next' when the installation prerequisites have finished loading.
3. Enter your Name and Product key (if applicable) and accept the licensing terms and conditions from the 'Start Page' installation step.  Click 'Next'.
4. Select 'Custom' from the 'Options' page.  Click 'Next'.
5. Select Visual C#.
• Deselect Smart Device Programmability (if shown).
• Smart Device Programmability is not required.
• Deselect Java Language Conversion Assistant (if shown).
• Java Language Conversion Assistant is not required.
• Deselect Visual Studio Tools for Office (if shown).
• Visual Studio Tools for Office is not required.
6. Deselect Visual J#.
• Visual J# is not required.
7. Deselect Visual C++.
• Visual C++ is not required.
8. Deselect Visual Basic.
• Visual Basic is not required.
9. Select Visual Web Developer.
• Visual Web Developer is required for CommunityServer 2007.1 integration.
10. Leave .NET Framework SDK in the default configuration.
• .NET Framework SDK is not required for arachnode.net but contains common .NET tools and should be installed.
11. Deselect Dotfuscator Community Edition.
• Dotfuscator Community Edition is not required.
12. Deselect Tools for Redistributing Applications.
• Tools for Redistributing Applications is not required.
13. Deselect Unit Testing Tools.
• Unit Testing Tools is not required.
14. Deselect Crystal Reports for Visual Studio.
• Crystal Reports for Visual Studio is not required.
15. Deselect Microsoft SQL Server 2005 Express Edition.
• Microsoft SQL Server 2005 Express Edition is not required.  Microsoft SQL Server 2005 will be installed in a later step.
16. Click 'Install' or 'Next' to install Visual Studio 2005 Professional Edition or greater.
    
    
• Install Visual Studio 2005 Team Suite Service Pack 1.  Download here.
  Note: If Visual Studio 2005 Team Suite Service Pack 1 is installed you may skip this step.
  
  
• Install Microsoft SQL Server 2005 Standard Edition or greater.  Download here.
  Note: If Microsoft SQL Server 2005 Standard Edition or greater is installed you may skip this step.
1. Select 'Server components, tools, Books Online, and samples' from the setup splash screen.
2. Click 'I accept the licensing terms and conditions' from the 'End User License Agreement' installation step.  Click 'Next'.
3. Click 'Install' from the 'Installing Prerequisites' installation step.
4. Click 'Next' from the 'Microsoft SQL Server 2005 Setup' installation step.
5. Click 'Next' from the 'System Configuration Check' installation step.
6. Enter your name and company from the Registration Information installation step.
7. Select 'SQL Server Database Services', 'Analysis Services', 'Integration Services' and 'Workstation components, Books Online and development tools' from the 'Components to Install Screen'.  Click 'Next'.
8. Select 'Default instance' from the 'Instance Name' installation step.
• Arachnode.net can operating using a named instance.  The default installation expects a default instance.
9. Configure SQL Server service account security appropriate for your environment from the 'Service Account' installation step.  Click 'Next'.
10. Accept the defaults or configure security appropriate for your environment from the 'Authentication Mode' installation step.  Click 'Next'.
11. Accept the defaults or configure a server collation appropriate for your environment from the 'Collation Settings' installation step.  Click 'Next'.
12. Select your preferences from the 'Error and Usage Report Settings' installation step.  Click 'Next'.
13. Click 'Install' from the 'Ready to Install' installation step.
    
    
• Restore arachnode.net from backup.
1. Copy 'arachnode.net.bak' from 'C:\AppWorkspace\database\arachnode.net.zip' to 'C:\AppDatabases'.
2. Launch SQL Server Management Studio and click 'Connect'.
3. Right-click on 'Databases' and select 'Restore Database...'
4. Specify to restore from device and select 'C:\AppDatabases\arachnode.net.bak' as the restore source.
5. Check the box under 'Restore' to select the backup set to restore.
6. Select 'arachnode.net' as the restore destination from the 'To database:' drop-down.
7. In the options panel, ensure each arachnode.net database file is restored to 'C:\AppDatabases'.
8. Click 'OK'.
   
   
• Alter the arachnode.net database to allow the CLR functions to function properly.
1. Open a new query.
2. Execute the statement 'ALTER DATABASE [arachnode.net] SET TRUSTWORTHY ON'.
   
   
• Enable CLR Functions.
1. Launch SQL Server Surface Area Configuration.
2. Click 'Surface Area Configuration for Features'.
3. Select 'CLR Integration' from the left panel and select 'Enable CLR Integration'.
4. Click 'Apply'.
5. Return to SQL Server Management Studio Express, right-click the arachnode.net database instance and select 'Refresh'.
   
   
• Build and deploy arachnode.net
1. Launch Visual Studio.
2. Open the arachnode.net solution (.sln) at 'C:\AppWorkspace\arachnode.net\source\arachnode.net.sln'.
3. Press 'ctrl+shift+b' to build the solution.
4. Right-click the 'Functions' project and select 'Properties'.
5. Select the 'Database' tab.
6. Click 'Browse' next to the 'Connection String:' textbox.
7. Select the server name in the 'Server name:' drop-down, then create a connection to the arachnode.net database in the 'Select or enter a database name:' drop-down and click 'OK'.
8. Enable 'SQL/CLR Debugging' when prompted to do so.
9. Right click the 'Functions' project and select 'Deploy'.
   
   
• Start crawling.
1. Open 'Program.cs' in the 'Test' project.
2. Enter an AbsoluteUri for the Discovery and press 'F5'.

CommunityServer 2007.1 Integration Installation Instructions:

• Install and configure CommunityServer 2007.1 as described here.