Re: New Installation

Thanks for your reply. The IIS will be used to serve as the front end of SQL 2000, to access data and to store/update data as well. That would be all. It won't be used to host multiple web sites, for example, or for any other purpose.

Arnie Rowland wrote:
Using the /3GB switch will allow the SQL Server to access memory past 2GB -up to 3GB. That will leave only 1 GB for the OS and IIS.

If this is a low use IIS box, that may be fine.

You need to determine the priority of usage -SQL Server or IIS. You would be wish to test with and without the /3GB switch.

.

Relevant Pages

  • Re: Getting Started
    ... >What do I have to do to make the Access data on a machine in our office available for queries from a website form residing on a unix server somewhere out there on the internet. ... Put your Access data on the web site. ... IIS won't. ... to your web server system through your router. ...
    (microsoft.public.inetserver.iis)
  • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
    ... uses NT group based permissons on the SQL Server, ... > transfered to the IIS box and IIS does a local logon. ... > delegation for all accounts. ...
    (microsoft.public.inetserver.iis.security)
  • RE: Co-Hosting SQL with IIS FTP service
    ... there are no functional conflicts between SQL and IIS; their network resource demands are unique. ... If the machine resources are enough, you can also use your favorite virtualization technology to separate the FTP and SQL servers and thus avoid the combinational security issues that public FTP services may impose on the SQL server. ... Co-Hosting SQL with IIS FTP service ...
    (Focus-Microsoft)
  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... check the local computer - so there are no FW or Gateway problems. ... SQL Hi, I get the following error message when I try ...
    (Focus-Microsoft)
  • Re: General Network Error - MS Stumped
    ... > environment between our ASP.NET application and SQL Server 2000. ... > to be related to queries that return "large" amounts of data from SQL. ... > MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS ... > at System.Data.SqlClient.TdsParser.ReadByteArray(Bytebuff, Int32 ...
    (microsoft.public.sqlserver.server)