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 and 2008 are supported.

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

INPUT_DIR refers to the WebApplication directory supplied along this file.
TARGET_DIR refers to the directory the application will live in on your server.

Note: depending on the environment you are running, the following steps might require minor adjustments.

1. Create TARGET_DIR if it does not already exist; be sure that the directory is empty.
2. Copy all the files from INPUT_DIR into TARGET_DIR and make sure that TARGET_DIR\public\Plugins\SqlServerProviders.dll exists.
3. 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" />

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

   
   
5. Make sure that the "web.config" file specifies the correct Settings Storage Provider:
   
   

   <add key="SettingsStorageProvider" value="ScrewTurn.Wiki.Plugins.SqlServer.SqlServerSettingsStorageProvider, SqlServerProviders.dll" />

   
   
6. 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).
7. Setup a Web Site or Application in IIS, setting the root directory to TARGET_DIRECTORY.
8. Navigate to the Web Site or Application using a web browser and verify that everything works properly (the data providers, if the connection string is correct, will automatically create the required tables in the database).
9. Login using "admin" and the password you entered in the web.config file.