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

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



"Aaron Young"  wrote in message 
news:8507BA19-B747-42C6-A5B0-25D0C01E3A26@microsoft.com:


> 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