title: Sql Exception: No Process Is on the Other End of the Pipe
body: <p>I can not access my sql server connection from c# code. I get this error:</p>
  
  <p>Sql Exception: No Process Is on the Other End of the Pipe</p>
  
  <p>thats the connection string in my app.config:</p>
  
  <pre><code>&lt;add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=BELLA\SQLEXPRESS;Initial Catalog=TLP;User Id=pascal;Password=test;Pooling=False"/&gt;
  </code></pre>
  
  <p>When I use windows authentication: Integrated Security=True;</p>
  
  <p>Then I can connect to the database.</p>
  
  <p>BUT I can NOT use windows authentication because the opening of the sql connection is done from within a windows service which is run as LocalSystem. When I do this I get this error:</p>
  
  <p><a href="https://stackoverflow.com/questions/6894651/login-failed-login-failed-for-user-nt-authority-system">Login failed. Login failed for user &#39;NT AUTHORITY\SYSTEM&#39;</a></p>
  
  <p>Its the first time I create a login + user in sql management studio so I am nearly sure I did something wrong and its my fault.</p>
  
  <p>This is what I did:</p>
  
  <p>1) Create a new login in the server`s security folder with sql authentication user:pascal and password:test.</p>
  
  <p>2) Went to my database and create a new user in the security folder with user: pascal and login: pascal and schema: dbo</p>
  
  <p>3) Did I forget something?</p>
  
  <p>Solutions from other people:</p>
  
  <p>1) I have also tried this link but no luck my Sql Select on the suspect_pages table is empty.</p>
  
  <p><a href="https://stackoverflow.com/questions/17974506/error-no-process-is-on-the-other-end-of-the-pipe">Error: No process is on the other end of the pipe</a></p>
  
  <p>2) My Sql Server network configuration has ENABLED on the tcp/ip, names pipes and shared memory settings.</p>
  
  <p>3) <a href="https://stackoverflow.com/questions/1719399/sql-server-2008-cant-login-with-newly-created-user?rq=1">SQL Server 2008 can&#39;t login with newly created user</a> </p>
  
  <p>Number 1 to 3 did not help at all.</p>
  
  <p>All this is done on my local machine. No network is here.</p>