"...Not a member of the sys admin role in SQL Server"
Error Message:
Details:
Setup, running as the account you're currently logged on under, is trying to do administrator-level things in SQL Server like create a new login for FogBugz to use, and SQL Server is saying "you do not have permission to do this".
Solution:
Manually add the Windows account you're currently using as a system administrator inside SQL Server, even if you are logged in as an Administrator on the Windows OS side (the two sides are not agreeing about who is an administrator).
If SQL Server is on another machine it may be a problem that the SQL Server machine is not trusting the machine you're running Setup from. If that's the case, see this guide.
If all else fails, you can switch to SQL Server authentication instead of Windows auth.
Notes:
The code that Setup runs on SQL Server to do the Admin lookup is this:
{call master..sp_helpsrvrolemember('sysadmin')}
You can run that in SQL Server to see what Setup sees.
If when you run the above SQL query you DO see your account (this was observed on XP Pro SP2) you may have to manually create a login for FogBugz to use in SQL Server. That login should use SQL Server authentication, the Server Roles tab can be left alone, and on the Database Access check off the fogbugz database and check off db_owner below.
