?? PTWeb / Windows Authentication -- Linq Query uses Schema Name

?? PTWeb / Windows Authentication -- Linq Query uses Schema Name

Old forum URL: forums.lhotka.net/forums/t/9123.aspx

SDM10012 posted on Wednesday, June 23, 2010

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




ajj3085 replied on Thursday, June 24, 2010

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