SQL Server: Setting up FogBugz database on a separate non-trusted server
In situations where the access permissions in your environment are such that Setup will not be able to log in to your SQL Server and/or grant the FogBugz user account permissions in your database:
- Run Setup on the web server, choosing Access as the database.
- Install just one of your license orders and log in as Administrator. Don't bother with any other settings right now.
- Find the FogBugz/Accessories/all.sql file. This is a SQL script that creates a skeletal FogBugz database.
- Open SQL Server Management Studio, right click on the FogBugz database, choose New Query from the pop-up menu. Go to File > Open and open the all.sql file. Copy and paste the contents into the query window that you created. Run the query (you can hit F5 to run).
- Back in SQL Server Management Studio ,. go to Security > Logins and create a login for FogBugz to use. You must set it to use SQL Server Authentication, not Windows Authentication. Make this login db_owner for the FogBugz database.
- Back in FogBugz in the browser, click on Site, top right. Scroll down about half way, and change the database to point to your SQL Server database. FogBugz will at this time prompt you to let it upgrade that database.
- Lastly, run regedit on the web server and go to:
HKLM > Software > Fog Creek Software > FogBugz > C:\\path\to\your\FogBugz
Set fFullTextSearchOK to 1. This turns full text search on in FogBugz. (Full text search is disabled when you use Access as your database.)