Question

The connection to the SQL server database is in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Fog Creek Software\FogBugz\[your FogBugz install directory]\sConnectionString

How do I alter this to switch between Integrated Security, which uses the FogBugz Windows user account to connect to the database, to SQL Server authentication, in which FogBugz has its own user account in SQL Server?

Answer 1

First, make sure that Mixed Mode Authentication is enabled in your SQL Server install.

Then, create a new login, named something distinctive, like "fogbugz", using SQL Server Authentication. Under User Mappings, make sure that the user has access to, and db_owner privileges over, the FogBugz database.

Change this part of your connection string:

Integrated Security=SSPI

to:

User Id=fogbugz;Password=[yourpassword];