We have a prod server that is 2005. Then we have a dev server that is 2008R2.
We copied over the DB's from 2005 to 2008 worked fine. But then one of the BA's 'accidently' deleted all the users on the 2008 dev server.
I wasn't even able to login using my account. So, I logged in to the server as admin and I'm able to see the db's.
I went into SSIS and transferred all the logins from 2005 to the 2008R2 server.
All the users look to be there, but I still can't login as my user. I've checked and my user is there and enabled..? What can I check next?