Welcome Guest, you are in: Login

This page describes how to install ScrewTurn Wiki using the SQL Server Data Storage. Please note that only SQL Server 2005 (any edition) or newer is supported (2000 is not supported).

If you plan to use ScrewTurn Wiki in a web farm, please also take a look at the dedicated instructions.

  1. Download the SQL Server Data Storage ZIP package from the download page
  2. Verify that your system has the .NET Framework 4.0 and SQL Server 2005/2008 installed
  3. Required to install for IIS URL Rewrite
  4. Create a new directory to host your wiki, e.g. C:\inetpub\wwwroot\wiki
  5. You'll find a WebApplication directory in the ZIP file; copy all the contents into the new directory
  6. Configure the new directory as Application or Website in IIS
  7. Open the web.config file with a text editor
  8. In the "web.config" file, complete the SQL Server connection string, specifying server address, database name and authentication information (either user/password or integrated authentication), for example:
    <add key="SettingsStorageProviderConfig" value="Data Source=(local);Initial Catalog=ScrewTurnWiki;User ID=wiki_user;Password=wiki_password_567;" />
  9. Create a database in SQL Server with the name specified in the connection string, making sure that the specified user can create, alter and drop tables as well as select, update, insert and delete rows. Also make sure that the database collation is not case-sensitive  (see how to change it).
  10. Launch a browser and navigate to your wiki (all database tables will be created automatically)
  11. Set password for admin.

 * You can change the name of the directory Public on any other, but in this case, you have to include a new name into the parameter  appSettings\PublicDirectory of the file "web.config"

Side Projects

  • RESX Synchronizer allows to synchronize multi-language .resx files (used for the development of ScrewTurn Wiki).
  • Pixel Picker enables to pick the color of pixels on your screen — very handy for day-to-day graphics-related activities.