Ok this might be silly but I have almost tried everything. I had issues with one of my HD and had to rebuild the SQL Server. After restoring the all the DB’s I notice that none had the original logins where in them. I tried recreating the logins and then adding them to the DB, but it tells me the login is already in the database. I tried linking orphan logins and it did not help.
The DB work but the original logins are still not there and it is buggin me. Any suggestions?