I ended up switching to the local system account for the sql server service and now everything is working...for the moment.

I am now under the assumption the Windows login I had...

Thank you so much.  I never tried the join within the join before.  I am sure I will use this over and over again now that you have shown me...