title: SQL Server 2008 on localhost: Connection continually refused
body: <p>The problem I am having is that I keep receiving the </p>
  
  <blockquote>
    <p>(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)</p>
  </blockquote>
  
  <p>error every time I try to connect to the database.</p>
  
  <p>I can see the database in SQL Server Manager Studio and have created a login for it by right clicking the <code>security folder-&gt;new-&gt;login</code> and entering a username and password with SQL Server authentication. I can also see the <code>SQLSERVER (SQLSERVERDB)</code> process running in the services window.</p>
  
  <p>The connection string in my Web.config file is</p>
  
  <pre><code>  &lt;connectionStrings&gt;
       &lt;add name="MainConnString" connectionString="Data Source=MEETING-ROOM\SQLSERVERDB,48006;Initial Catalog=Palace_Live;
            User ID=Palace_Live;Password=p@l@c310!;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <ul>
  <li>The server name/instance is: <code>MEETING-ROOM\SQLSERVERDB</code></li>
  <li>The database is called <code>Palace_Live</code></li>
  <li>User/Pass is <code>Palace_Live / p@l@c310!</code></li>
  </ul>
  
  <p>I know the issue relates to the connection string as if I change the Data Source parameter to say Googl.com I receive a different error message.</p>
  
  <p>I can't see what steps I have missed or what I am doing wrong. Could anyone help point me in the right direction as to what I might be missing</p>
  
  <p>I am using IIS7 and SQL Server 2008 locally on a windows 7 32bit machine.</p>