This project has moved and is read-only. For the latest updates, please go here.


Instructions "Survey™ Project 2.2 Install package" - NEW INSTALLATION


1. SYSTEM REQUIREMENTS

Clientside:
- Browsertypes IE10 or >; Firefox <2013 versions>; Chrome <2013 verions> or > (latest versions)

Serverside:
- .NET Framework 4.* or higher must be installed
- IIS webserver (6.* or higer)
- SMTP mailserver account
- MsSqlserver 2008 R2 or 2012 database
- Supported Operating Systems: clientside = Windows7, Vista, XP; serverside = Windows Server 2003, Windows Server 2008/2012
- You must have administrator privileges on your computer

Free downloads available at http://www.asp.net/downloads/


2. FILES
- download zipped install package to your computer
- unzip files to (new) file directory (e.g. C:/Survey/..)
- optional: right click file to "Unblock" before unzipping


3. IIS

Option 1.
- create a new Virtual Directory in IIS [e.g. called 'SurveyProject'] which points to the directory where the Survey files are unzipped
- make sure you have default.aspx specified as a Default Document for your Virtual Directory
- set Asp.NET to version 4.* (or higher) and "Pipeline mode: Integrated"

Option 2.
- Create a WebApplication in IIS and follow the steps of option 1.
- Add the Webapplication to the proper Applicationpool using .NET 4.* and Integrated Pipeline Mode


4. DATABASE

"Existing DB installation" - MSSqlserver 2012
- start MS SQL Server 2012 (using Enterprise Manager or your tool of choice )**
- create a new empty database
- open sql file 'SurveyProject_2.2_Final_ExistingDBInstall_Mssql2012.sql' from the '_DatabaseSql' website directory in a query window
- change USE [yourdatabasename] command to the name of your database
- run the SQL query
- check to see if the database was created correctly

"Existing DB installation" - MSSqlserver 2008
- same procedure, now use 'SurveyProject_2.2_Final_ExistingDBInstall_Mssql2008.sql'


"To upgrade from a SP 2.1.1 database to SP 2.2."
- Run the script:
* SurveyProject_2.2_Final_UpgradeExistingDBInstall_Mssql2008.sql (2008)
or
* SurveyProject_2.2_Final_UpgradeExistingDBInstall_Mssql2012.sql (2012)


5. SECURITY
If using Windows 2000 or XP - IIS5
- the {Server}/ASPNET user account must have Read, Write and Change Control
of the root application directory (this allows the application to create files/folders )

If using Windows 2003 - IIS6
- the {Server}/NetworkService user account must have Read, Write and Change Control
of the root application directory (this allows the application to create files/folders )


6. DB CONNECTION
- open the web.config file in notepad or a texteditor
- Check the database connection string in the web.config file. Default is:

  <connectionStrings>
    <add name="SurveyProjectTestConnectionString" connectionString="Data Source=[servername];Initial Catalog=[database];Persist Security Info=True;User ID=[username];Password=[yourpassword]" providerName="System.Data.SqlClient" />
  </connectionStrings>

Note: the former setting at the <nSurveySettings> section is no longer used.


7. SMTP MAILSETTINGS
- open the web.config file in notepad or a texteditor
- check smpt settings. Default is:
        <add key="NSurveySMTPServer" value="127.0.0.1" />
        <add key="NSurveySMTPServerPort" value="25" />
        <add key="NSurveySMTPServerAuthUserName" value="" />
        <add key="NSurveySMTPServerAuthPassword" value="" />

                <add key="NSurveySMTPServerEnableSsl" value="false"/>  

8. CULTURE/UICULTURE
- The language setting of your webbrowser will determine the XML languagefiles used to translate webpage texts.
- This effect is caused by one of the settings in the web.config file: culture/ uiculture.
- If set to "auto" (default) Survey™ will pick up culture/ language of preferred browser settings.
- To explicitely pick a culture/ language, replace auto with "en-US" or "nl-NL" for example.


9. CKeditor & Filemanager:

a- Set server path in Filemanager\Scripts\filemanager.config.js -->

        "serverRoot": "[your webserver]",
        "fileRoot": "",

Check instructions at: https://github.com/simogeo/Filemanager/wiki/Filemanager-configuration-file


b- Set server path in CKeditor\config.js

    config.filebrowserBrowseUrl = '/[your webserver]/Filemanager/index.html';


10. START SURVEY
- browse to http://[nameofyourwebserver]/[NameOfSurveySite] or your hosting URL in your web browser
- the application will start running

On first login:
- Username = admin
- Password = SP_admin01


Last edited Dec 20, 2013 at 8:19 PM by fwsmaster, version 1

Comments

xx3xxx Jun 8, 2015 at 1:05 PM 
it is VERY HARD TO INSTALL

my sqlserver express console

I just use window authentication (no user, no pass e.g. sa sa)

is like this --
FUJITSUPC\SQLEXPRESS


then I don't know how to follow this instruction
6. DB CONNECTION
- open the web.config file in notepad or a texteditor
- Check the database connection string in the web.config file. Default is:

<connectionStrings>
<add name="SurveyProjectTestConnectionString" connectionString="Data Source=[servername];Initial Catalog=[database];Persist Security Info=True;User ID=[username];Password=[yourpassword]" providerName="System.Data.SqlClient" />
</connectionStrings>

Note: the former setting at the <nSurveySettings> section is no longer used.

in VS web.config file

(am I doing the correct thing here, please make some youtube video to explain options for installation== youtube, I found your channel already, but last video 3 years ago)

<connectionStrings>
<add name="SurveyProjectDevConnectionString" connectionString="Data Source=FUJITSUPC\SQLEXPRESS;Initial Catalog=SURVEYDB;Persist Security Info=True;User ID=;Password=" providerName="System.Data.SqlClient" />
<add name="SurveyProjectTestConnectionString" connectionString="Data Source=.\sqlexpress;Initial Catalog=;Persist Security Info=True;User ID=;Password=" providerName="System.Data.SqlClient" />
<add name="SurveyProjectProdConnectionString" connectionString="Data Source=.\sqlexpress;Initial Catalog=;Persist Security Info=True;User ID=;Password=" providerName="System.Data.SqlClient" />
</connectionStrings>
<!-- Survey Project database connection: to select connectionsetting options see connectionStrings-->
<dataConfiguration defaultDatabase="SurveyProjectProdConnectionString" />
<appSettings>
<!-- Fixed SiteName: used to identify webapp in code -->
<add key="SiteName" value="Survey Project"/>


[[[[ am I correct set up , what has I done wrong, ]]]]]

I always just click run with IE browser
but it has there is one single error (then I turn TRUE TO FALSE)

it said (build error, use last successful build)
and this 1 error

Error 1 It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. F:\c7msdn\survey2dot2\web.config 80


but I guess, I follow instruction , and set up windows 8 IIS , tick everything under IIS and did it successful for virtual directory -- I called the alias of virtual directory SURVEY

tell me, and show us in youtube, what has WE DONE the installation wrong ?!! we are puzzled