Glad to hear it's working!

Oscar,

If there are no users listed there when you restore the database, then this is what you will need to do:

1. Create a new SQL Server Login, set the password,...

Give this a shot:

- EXEC sp_change_users_login 'Auto_Fix', 'user'

All you need to do is just change the 'user' variable to whatever the SQL Server Login is. For example, if I created...

Ok - sorry, I thought you were just moving the database to another new SQL Server.

Since you had to reinstall it, the other way that I've resolved those issues is...

Oscar,

If you have several user accounts that are used to access the application, you can always create a script using an MS stored procedure to transfer these logins over to...

Thanks Ranjith. This was a great "quick fix" and now all our weekly database maintenance jobs are running sucessfully.

Yeap. But on the flip side, our firm is a little different in that we all wear many hats. We are actually in the process of implementing a new password...

Thanks for the response Roy....

I'm on the fence on this one too, but we were going to use a random password generator to create the pwds for the service accounts....