Integrated Security Issue

[Ross Culver]

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

 

[Mark Rae [MVP]]

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

 

[Ross Culver]

No. To test that theory, I replaced the Integrated Security=TRUE with my
credentials and the connection worked.

Any other thoughts?

Ross

 

[Jeff Dillon]

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.

Any other thoughts?

Ross

 

[Ross Culver]

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

Jeff

 

[Mark Rae [MVP]]

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

 

[Ross Culver]

Wow! Incredible.

Thanks.

http://forums.asp.net/t/1119229.aspx
http://p2p.wrox.com/topic.asp?TOPIC_ID=25837

 

[Peter Bromberg [C# MVP]]

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.

Thanks.

 

[one again]

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.

Thanks.

 

[Mark Rae [MVP]]

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

 

[Jeff Dillon]

If you want to use Kerberos delegation, then yes. Have you tried it? Any
luck?

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