Turns out the problem was workstation related. 

I went to a coworker's machine and asked him to add the group to the logins.  It worked perfectly for him as he...

I am logged into my machine with my network login.  I'm logged into SQL with the sa username and password.

At this point it makes absolutely no sense.  If I add...

Thank you for your reply.

Dave

Thanks. 

I'm able to connect to SQL via IP address, but cannot connect via name.  Does this pose any problems?

Thanks.  With this approach I'll have to log into each instance and then go to each Current Activity to determine who or how many are in the system.

Still looking...

Thanks again,

Dave

Thank you for your reply.

That did the trick. Thanks and sorry for being the confusing type.

Thanks, but either way, after the restore, the File Name (right-click db, choose properties and then click Data Files or Transaction Log) will show the ABC.mdf File Name instead of...

Thanks guys.

Yes, these are all on one server.

The activity for the server is primarily deletes and bulk inserts, though there are manual entries of data through...