J
Jim Corey
We're looking at logging on to SQLServer using Windows Authentication
from an ASP app, and trying to figure out what will work.
The following connection string works with Basic Authentication:
driver={SQL
Server};SERVER=MyServer;Database=MyDB;Trusted_Connection=yes;
Is there a way to do this with IIS security set to Integrated Windows
Authentication?
More: This is an existing app where currently each user has a database
login. We want to get away from that. Another option would be to
create a database user for the app, so we may do that. Any opinions
welcome.
TIA,
Jim
from an ASP app, and trying to figure out what will work.
The following connection string works with Basic Authentication:
driver={SQL
Server};SERVER=MyServer;Database=MyDB;Trusted_Connection=yes;
Is there a way to do this with IIS security set to Integrated Windows
Authentication?
More: This is an existing app where currently each user has a database
login. We want to get away from that. Another option would be to
create a database user for the app, so we may do that. Any opinions
welcome.
TIA,
Jim