Hi,
I would like to host a .NET Remoting data access layer for a SQL Server
database in IIS. The server will be available to the general public so there
is no VPN involved. Anyone can download a demo smart client which will then
access the SQL Server data through the .NET Remoting layer in IIS.
The problem that I have is I don't know how to setup the security on the
server side in both IIS and SQL Server. As the clients are not part of the
server domain I guess I have to use anonymous access and map it to a Windows
account. However, what permissions do I need to setup in IIS and SQL Server?
Any help I can get will be greatly appreciated.
Thanks in advance,
Aaron
Bryan Phillips - 17 Jun 2007 00:05 GMT
You will mostly likely want to configure IIS to use Anonymous Access and
disable all other kinds of access. Depending on your server OS and your
SQL Server security configuration, you may be able to allow the identity
of the app pool in IIS to access the SQL Server database using Windows
Authentication via Kerberos.
--
Bryan Phillips
MCT, MCSD, MCDBA, MCSE
Blog: http://bphillips76.spaces.live.com
Web Site: http://www.composablesystems.net
> Hi,
>
[quoted text clipped - 13 lines]
>
> Aaron