Installing ScrewTurn Wiki (SQL Server)

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 3.5 and SQL Server 2005/2008 installed
3. Create a new directory to host your wiki, e.g. C:\inetpub\wwwroot\wiki
4. You'll find a WebApplication directory in the ZIP file; copy all the contents into the new directory
5. Configure the new directory as Application or Website in IIS
6. Open the web.config file with a text editor and set the MasterPassword field with a password that will be used for the built-in admin account, for example:
   

   <add key="MasterPassword" value="my_password_123" />

7. 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;" />

8. 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).
9. Launch a browser and navigate to your wiki (all database tables will be created automatically)
10. Login with admin and the password set in web.config.