OK I removed SQL 2005 and installed again to start fresh. I tried adding a new db. then restoring to the db as suggusted above, but I get this...

All the instructions that I have read for sp_help_revlogin show that you need to do that PRIOR to moving a database, that is in your existing database, that is where...

I'm getting the error:

[Microsoft][SQL native client][SQL server]Login failed for user 'LIMSUSA', LIMSPROD

when I try to connect with my front end client.

I can connect through SQL management studio fine.