Integrated Security Issue

  • Thread starter Thread starter Ross Culver
  • Start date Start date
R

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
 
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...?
 
No. To test that theory, I replaced the Integrated Security=TRUE with my
credentials and the connection worked.

Any other thoughts?

Ross
 
Integrated only works if IIS and SQL are on the same box

Jeff

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

Any other thoughts?

Ross
 
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


Jeff Dillon said:
Integrated only works if IIS and SQL are on the same box

Jeff
 
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...
 
Back
Top