how  to configure sqlserver 2000 in host or
how to configure server for sql server 2000

I think you should explain more information about your problem. Now I am not sure your question.
If you have sql server in your localhost, it is simple to configure.
<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ import Namespace="System" %>
<script runat="server">
    void Page_Load(){
       OleDbConnection conn=new OleDbConnection("Provider=SQLOLEDB;user ID=sa;pwd=sa; SERVER=buntha;Database=Inventory");
       conn.Open();
       Response.Write("Successfully");
       }
</script>
This is how to connect to sql server. Sql server when you installed it, it will automatically run.

____________________________
ly buntha

thanks
but how to configure web server  for sql server

Hi.. what access to the sql box are you using? Is this a security question (namely, using SQLXML and accessing SQL via the URL)?
Can you provide more specific information and how searching MSDN hasn't helped?
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)