>>>>Is "dbo" the actual owner of these tables?
>>>
>>>Apparently, as when I look in Sql Server Management studio they are listed as dbo.CompanyAccess. I just changed my login credentials to use the sa account but still no change. also I rechecked to make sure the BLG can access the tables and it works fine. I wonder if this is an MM issue.
>>>Tim
>>
>>Try doing a search of your project to see if the database name got embedded someplace you weren't expecting.
>
>Nothing in any of the projects for WCF Server or clients other than the commented out connection strings in Web.Config or app.config
One other idea (it won't fix it, but it might at least let you know if this is the issue). Try changing your SQL code to specify the full table reference, eg. SELECT ... FROM DatabaseName.dbo.CompanyAccess