>>>>>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

I tried changing it in the PhysicalDbcObjectName property to be the full name and that didn't work. Sooo, I tried removing the dbo and changed it to just the table name and.... PRESTO! I did get a funny error the first time through but I tried a clean run and it worked.

Paul you are awsome. I kept reading in the Online docs for this exception it was either an invalid user id, connection string, or the server was stopped (SQL). But funny this has not shown up previous in the MM stuff as I use it every where else.

Now, any ideas where I should try to trap these "exceptions" thrown by the WCF service in the app so I don't have to display them?

Thank You
Tim