Confluence installation steps:
- Install SQLServer 2008
- Create Database, 'case sensitive'
- Login: windows authentication + sql server authentication
- Create login, map to role, map to db
- Install Confluence
- Config Confluence home
- Config Confluence port
- Visit confluence, you'll see setup wizard
- Choose external database, finish configuration
- You might get an error when moving pages, or deleting spaces, refer to this Confluence issue for fix:
Error code 421 when moving/re-ordering pages in confluence 3.5.1 and SQL server
http://jira.atlassian.com/browse/CONF-22275?page=com.atlassian.jira.plugin.system.issuetabpanels%3Achangehistory-tabpanel
The actual fix is in duplicate issue CONF-22164