How to establish trust between IIS and SQL Server on different machines?

Question

I have a .net web application hosting in IIS6 with windows authentication and anonymous access. The web application connects to SQL Server located in the same domain but on a different computer.

I want the IIS workflow to execute the I_USR _... query in order to access SQL Server.

Will this work?

(Is there one-to-one trust? Or should I make some extra effort to make the trust work?)

(edit) On this page I read:

IUSR_ must be in the domain and have proper access to SQL Server; or you must disable anonymous access on the site / application, which will allow IIS to transfer user credentials to SQL Server. Failure to perform any of these errors will result in an error.

Answer 1

This may work if you provide SQL access to the application pool id.

You cannot transfer your user credentials to SQL even with impersonation.

Answer 2

You should be fine by allowing access to the domain account in the SQL Server block or by creating a SQL Server account and using this to query the database.

: http://www.connectionstrings.com/sql-server-2008

Answer 3

sql . : http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx

Answer 4

, Active Directory - . . , , - .

:

http://msdn.microsoft.com/en-us/library/ff647404.aspx

:

http://www.databasejournal.com/features/mssql/article.php/3696506/Setting-Up-Delegation-for-Linked-Servers.htm