Welcome to the FogBugz Knowledge Exchange

Question

0

Hi,

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)

TIA,

edited Nov 9 2010 at 9:18

asked Nov 9 2010 at 9:13

Serge - appTranslator
43●4

db · Accepted Answer · 2010-11-09 14:34:40Z UTC

1

You need to give the FogBugz Windows user permissions on your FogBugz database. You can do this with SSMS:

Add new user with SSMS

Then specify the FogBugz user account and grant it db_owner permissions:

Specify the FogBugz user permissions

answered Nov 9 2010 at 14:34

db♦♦
13.2k●8●15

	Works! Thanks for the screenshots. OK, so the FogBugz user marked as db owner has a SID from the previous server, right? Can I delete it now? Can I also delete FogBugz6025? – Serge - appTranslator Nov 9 2010 at 15:17
	Yes, the user who is associated with the SID from the previous server is no longer needed. – Rob Sobers Nov 9 2010 at 17:39

Moving server. Can’t set DB owner

1 Answer