July 30, 2003 at 4:41 pm
Hi,
It is easy to setup IIS and SQL with Windows Authentication if both IIS and SQL are on same box. When IIS and SQL are on separate boxes I guess I have no choice but follow Microsoft Knowledge Base Article - 176380. My Web Admin won't change the default local IIS user acct to a domain acct per that article. So I am kind of stucked here. Do you know any work around or other way to use Windows Auth. beside following this MS article?
Thx.
July 31, 2003 at 1:10 am
Are you trying to connect to sql*ser using the User's credencials (windows login id)?.
I have IIS and Sql*Server on separate PCs.
I used the following configuration
Anonymous Access unchecked.
Integrated Windows Authentication checked
In the Ado Connection, the Trusted_Connection=Yes attribute used to connect to sql server.
This connects to Sql*Server using the users context.
However note that this works only in intranet scenario where in all users are logged into to the domain.
July 31, 2003 at 8:23 am
hthan, no, if you're not able to use a domain account you'll have to have local accounts on both sides with matching usernames and passwords.
You can set the anonymous user for a web application even if the main web site still runs under the default anonymous user. Is this possible?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
Edited by - bkelley on 07/31/2003 08:24:29 AM
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply