I just moved my FB (software + website + SqlServer 2008 R2 express DB) to a new server.
I followed the steps explained in this question except that I used SSMS and did a backup/restore rather than detach/attach. The problem is that when I restore the DB, SSMS doesn't allow me to specify the owner of the DB. Therefore the DB is created with sa as owner and the FogBugz Windows user can't connect to it. I temporarily solved it by specifying sa in the connection string (registry) but I'd like to fix that ownership (or permissions) issue.
Can anyone help (please assume I'm a newbie regarding SqlServer administration and security)