title: establish remote connection to a SQL server instance
body: <p>I am not able to establish remote connections to SQL Server 2008 enterprise edition.
  I have followed and implemented a lot of tutorials available. These are the things i have done:</p>
  
  <ol>
  <li>enabled TCP/IP connections in SQL configuration manager.</li>
  <li>added a rule to allow inbound connections at port 1433.</li>
  <li>allowed remote connections in the properties window of the concerned instance.</li>
  </ol>
  
  <p>But it still gives the error
  I am trying to install samples for replication using AdventuresWorks database and i am not able to install the sample. </p>
  
  <p>here is the error i got</p>
  
  <blockquote>
    <p>Attempting to create the 'ReplData'
    share that replication uses as the
    working directory.</p>
    
    <p>A subdirectory or file C:\Program
    Files\Microsoft SQL
    Server\100\Samples\Replica
    tion\ReplData already exists. The name
    has already been shared.</p>
    
    <p>More help is available by typing NET
    HELPMSG 2118.</p>
    
    <p>HResult 0x274D, Level 16, State 1 TCP
    Provider: No connection could be made
    because the target machine actively re
    fused it.</p>
    
    <p>Sqlcmd: Error: Microsoft SQL Server
    Native Client 10.0 : A network-related
    or in stance-specific error has
    occurred while establishing a
    connection to SQL Server . Server is
    not found or not accessible. Check if
    instance name is correct and i f SQL
    Server is configured to allow remote
    connections. For more information see 
    SQL Server Books Online.. Sqlcmd:
    Error: Microsoft SQL Server Native
    Client 10.0 : Login timeout expired.</p>
    
    <p>The publication was created
    successfully. You must create a
    virtual directory to use Web
    synchronization. If you plan to use a
    separate Web server, you must run the
    Web Synchronization Wizard on that Web
    server. (A certificate that supports
    SSL must already be installed.)</p>
    
    <p>Do you want to create a virtual
    directory named SalesOrders for Web
    synchronization on S2NWORKSTATION?
    [y,n]</p>
  </blockquote>