I've got a SQL Server 2005 Express database on a Vista system (DotNetNuke) with the dbo user connected to a login of foo. This is the account that DNN uses to log in to the db.
I made a backup of the db and restored it on a Win7 SQL Server 2008 R2 Express. The dbo user is now no longer associated with a login. I can't find any way to get it reassociated with a login. So:
1) Should I struggle forward with trying to get dbo reconnected to a login? If so, how does one do this?
2) Should I just create a new user, associate it with db_owner, make the default schema dbo, and then associate this new user with the login that my DNN app pool will use?
Option 1 strikes me as the better solution, but I just don't know how to get there or even whether it's possible.