 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / March 2008Integrated Security Issue
I have an ASP page with several textboxes that are populated using an ADO objects and statement in the code behind. The page also has two datagridviews each populated with datasources using the same connection string as the ADO statement, all three of which utilize Integrated Security. My ADO connection fails unless I change the Integrated Security portion of the string to a specific user and password. If all three strings are the same, why would ADO fail using Integrated Security? Thanks. Ross >I have an ASP page Presumably you mean ASP.NET...? > If all three strings are the same, why would ADO fail using Integrated > Security? Might they be fetching data from different tables and the one which fails relates to a table for which the ASPNET user has no permissions...?  SignatureMark Rae ASP.NET MVP http://www.markrae.net No. To test that theory, I replaced the Integrated Security=TRUE with my credentials and the connection worked. Any other thoughts? Ross >>I have an ASP page > [quoted text clipped - 5 lines] > Might they be fetching data from different tables and the one which fails > relates to a table for which the ASPNET user has no permissions...? Integrated only works if IIS and SQL are on the same box Jeff > No. To test that theory, I replaced the Integrated Security=TRUE with my > credentials and the connection worked. [quoted text clipped - 12 lines] >> Might they be fetching data from different tables and the one which fails >> relates to a table for which the ASPNET user has no permissions...? Really?!? I find that very hard to believe, though I'm going to test that theory. I'll let you know what I find out. Ross > Integrated only works if IIS and SQL are on the same box > [quoted text clipped - 17 lines] >>> fails relates to a table for which the ASPNET user has no >>> permissions...? >> Integrated only works if IIS and SQL are on the same box > > Really?!? I find that very hard to believe, though I'm going to test that > theory. I'll let you know what I find out. http://forums.asp.net/t/1119229.aspx http://p2p.wrox.com/topic.asp?TOPIC_ID=25837 SignatureMark Rae ASP.NET MVP http://www.markrae.net Wow! Incredible. Thanks. >>> Integrated only works if IIS and SQL are on the same box >> [quoted text clipped - 3 lines] > http://forums.asp.net/t/1119229.aspx > http://p2p.wrox.com/topic.asp?TOPIC_ID=25837 What's wrong with using a SQL Server login? It might be better for throughput because connection pooling is based on the connection string, which would be the same for all users. -- Peter Site: http://www.eggheadcafe.com UnBlog: http://petesbloggerama.blogspot.com Short Urls & more: http://ittyurl.net > Wow! Incredible. > [quoted text clipped - 7 lines] > > http://forums.asp.net/t/1119229.aspx > > http://p2p.wrox.com/topic.asp?TOPIC_ID=25837 Hi folks, I have the same problem, but I don't agree Mark Rae : It is possible to use integrated authentication even if IIS and SQL are on different servers. Have a look on these links : http://msdn2.microsoft.com/en-us/library/ms998292.aspx http://msdn2.microsoft.com/en-us/library/ms998355.aspx > Wow! Incredible. > [quoted text clipped - 7 lines] > > http://forums.asp.net/t/1119229.aspx > > http://p2p.wrox.com/topic.asp?TOPIC_ID=25837 > I have the same problem, but I don't agree Mark Rae : It is possible to > use > integrated authentication even if IIS and SQL are on different servers. It was Jeff Dillon, not me, who said that... SignatureMark Rae ASP.NET MVP http://www.markrae.net If you want to use Kerberos delegation, then yes. Have you tried it? Any luck? > Hi folks, > [quoted text clipped - 17 lines] >> > http://forums.asp.net/t/1119229.aspx >> > http://p2p.wrox.com/topic.asp?TOPIC_ID=25837
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.