Looking at ProjectTracker 3.8 MVC -- I had to change my connection string to use SQL Server authentication -- when using Windows Authentication DML statements (LoginSP) ... failed with
"invalid object name .. dbo.User"
Looks like the Linq ... when using integrated security ( have not checked it with ss authentication ) ... generates [schema].[table] select statement from sp -- doing project tracker login --
But even tho the windows login that I have in my config file has dbo permissions and access to that schema .... data portal fails with "invalid object dbo.xxx"
what am I missing ???
thx,
Steve
You may want to post your connection strings (sans actual passwords, of course). The only thing I can think of at this point is your connection string isn't specifying an initial catalog and the Windows logon has master set for the default database.
Copyright (c) Marimer LLC