What is the "best practice" for connecting to SQL Server when it is on a
different server than IIS?

Details on implementation (processes and gotchas) would be appreciated too!

Thanks,
Marc Butenko
mbute***@mt.gov

On Wed, 17 Aug 2005 15:56:08 -0700, Marc Butenko <Marc Bute***@discussions.microsoft.com> wrote:

¤ What is the "best practice" for connecting to SQL Server when it is on a
¤ different server than IIS?
¤
¤ Details on implementation (processes and gotchas) would be appreciated too!
¤

See if the following helps:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/paght000008.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000010.asp

The biggest stumbling block is typically one of the delegation of credentials when using Integrated
Windows security:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconaspnetdelegation.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT05.asp


Paul
~~~~
Microsoft MVP (Visual Basic)

Sandboxing AppDomain
can you put a strong name assembly in a role?
Can't determine if a file exists
MD5 or SHA1 or ???
'System.Security.SecurityException' when running .exe file from ot
IIS Delegation
Strong Name broken?
windows forms UserControl compiled with beta 2 doesn't work with IE
CAS Permission Sets
CryptGenKey & CryptImportKey slow in certain situations