Instructions "Survey™ 1.2.3 Install package" - New Installation


1. SYSTEM REQUIREMENTS
- .NET Framework 4.* or higher must be installed
- IIS webserver (6.* or higer)
- Smpt mailserver account
- MsSqlserver 2005 or 2008 database
- supported Operating Systems are Windows7, Vista, XP, Windows 2000, Windows Server 2003, Windows Server 2008
- 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/..)


3. IIS

Option 1.
- create a Virtual Directory in IIS [e.g. called 'Survey'] 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)

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

Option 1. "New DB installation"

- start MS SQL Server (using Enterprise Manager or your tool of choice )**
- open sql file 'Survey123_NewDBInstall.sql' from the '_Sql' website directory in a query window
- set database to 'master' db (use master)
- run sql query to create "Nsurvey" database
- check to see if database was created correctly *


Option 2. "Existing DB installation"

- start MS SQL Server (using Enterprise Manager or your tool of choice )**
- create an empty database
 
- open sql file "Survey123_ExistingDBInstall.sql" from the _SQL websitedirectory in query window
- set database to db you just created: use [dbname]
- run sql query to create "[dbname]" database
- check to see if database was created correctly *


*   Certain warnings/ messages can be ignored e.g."
         "The module '...........' depends on the missing object ......."
         and "Msg 15401, Level 11, State 1, Procedure sp_grantlogin,.. "
**  Both MsSqlserver 2005 and 2008 can be used to create and administer the Survey DB.


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:
        <add key="NSurveyConnectionString" value="server=(local);Integrated Security=SSPI;database=nsurvey" />
- As an alternative try:
        <add key="NSurveyConnectionString" value="Server=YourSqlServer;Database=YourDatabase;uid=YourDbUser;pwd=YourPassword" />


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="" />


8. CULTURE/UICULTURE
- As of Survey™ 1.2.2. the language setting of you 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. START SURVEY
- browse to http://localhost/[NameOfSurveySite] or your hosting URL in your web browser
- the application will start running

________________________________________________________________________________________________


Instructions "Survey 1.2.3™ Install package" - Upgrade Installation


1. Create a backup of the webfiles of your current Survey webdirectories

2. Copy the new webfiles and directories into the directory root of your current Survey installation.

3. Go to web.config file and recreate the original sql-db and smtp connection settings; change the culture/UI culture setting if needed.

4. Run the query Upgrade_Survey122to123_Sproc_spFileUnValidatedGetAll.sql from the _SQL directory


Note on upgrades of 1.1.0 to 1.2.0/ 1.2.1/ 1.2.2/1.2.3

- Because of the many changes to the 1.2.* versions we advise to fully replace the 1.1.0 database and webfiles with the latest version;
- Surveys created in 1.1.0 can be exported to XML and imported into the 1.2.* versions.
- Manual corrections to the XML files may be necessary;

Last edited May 12, 2011 at 8:14 PM by fwsmaster, version 1

Comments

No comments yet.