Here's my issue.
I have a server created from a windows image that includes SQL Server 2008 and two specific windows users, these windows users are a part of the sysadmin role and are users for the SQL Server instance.
If I detach then reattach the database everything works fine, the two windows users are able to connect no problem.
If I detach the database, re-image the system, then re-attach the database the windows users will still be listed as I can see them via Management Studio.
I'd imagine that the attaching and detaching of the database has nothing to do with it since the logins are listed under 'Security' for the SQL Server instance and not the db.
At this point users exist and have rights, but they can not connect unless you delete and re-add the windows users, I believe this is because the SID's are messed up.
Any idea how to 'update' the sid's to reflect the current windows users and not the previous ones?