title: Grant integrated security access rights for Microsoft SQL Server to LocalSystem account?
body: <p>Suppose my web application runs on a Windows server. It is hosted inside Tomcat, which runs as Windows service under the account <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/ms684190%28v=vs.85%29.aspx" rel="nofollow"><code>LocalSystem</code></a>. It accesses a Microsoft SQL Server on a remote Windows server. I would like to for the web application to authenticate to the SQL Server using integrated authentication.</p>
  
  <p>From the answer to a previous question I know that the following sequence of SQL commands would enable integrated authentication if Tomcat were to run under the account <code>&lt;your-domain-name&gt;\A1</code>.</p>
  
  <pre><code>CREATE LOGIN [&lt;your-domain-name&gt;\A1] FROM WINDOWS;
  CREATE USER [&lt;your-domain-name&gt;\A1];
  GRANT ... ON &lt;object-name&gt; TO [&lt;your-domain-name&gt;\A1];
  </code></pre>
  
  <p>What is the correct SQL syntax for granting similar rights to the <code>Local System</code>account on host <code>H1</code>, if it can be done?</p>