title: Error Accessing SQL Server from an ASMX Web Service
body: <p>I am accessing my server through remote desktop connection and have configured a webservice in IIS. I am able to see the methods but when I click on the button to "Invoke" I get the following error:</p>
  
  <p><strong>System.Data.SqlClient.SqlException: Login failed for user 'SOLDev\Server02$'.
     at ShareWare.Web.Service.WebAPI.Reservation.GetInfo()</strong></p>
  
  <p>Why is it taking the machine name as the user?
  My windows authentication user is User1Dev.
  Also my <strong>directory security</strong> in IIS is setup as follows:</p>
  
  <ol>
  <li>Option "Enable anonymous access" -- it's disabled</li>
  <li>Option  "Integrated Windows Authentication" -- checked off</li>
  </ol>
  
  <p>I am using .NET framework 2.0</p>